ALLBASE/SQL Reference Manual (36216-90216)

35
Preface
This manual contains basic information about ALLBASE/SQL as well as in-depth
information about ALLBASE/SQL data types and statements. The first three chapters are
for all readers, including new users of ALLBASE/SQL. The remaining chapters are for
experienced SQL users and SQL application programmers. The titles of the chapters are
as follows:
• Chapter 1 , “Introduction,” presents the components of ALLBASE/SQL and introduces
fundamental ALLBASE/SQL concepts and terms.
• Chapter 2 , “Using ALLBASE/SQL,” describes basic ALLBASE/SQL usage rules.
• Chapter 3 , “SQL Queries,” presents a full treatment of queries, including the use of
subqueries, UNION, and special predicates.
• Chapter 4 , “Constraints, Procedures, and Rules,” presents data objects which provide a
high degree of data consistency and integrity inside the DBEnvironment.
• Chapter 5 , “Concurrency Control through Locks and Isolation Levels,” describes ways
of managing concurrent database transactions.
• Chapter 6 , “Names,” presents general rules for names used in ALLBASE/SQL
statements.
• Chapter 7 , “Data Types,” details the data types available in ALLBASE/SQL.
• Chapter 8 , “Expressions,” describes ALLBASE/SQL expressions.
• Chapter 9 , “Search Conditions,” presents the basic syntax of ALLBASE/SQL
predicates.
• Chapter 10 , “SQL Statements A - D,” contains an alphabetical reference of all the SQL
statements and other elements of syntax.
• Chapter 11 , “SQL StatementsE-R,”contains an alphabetical reference of all the SQL
statements and other elements of syntax.
• Chapter 12 , “SQL Statements S - Z,” contains an alphabetical reference of all the SQL
statements and other elements of syntax.
The appendixes contain additional reference information as follows:
• contains an alphabetical summary of all ALLBASE/SQL statements and other
elements of syntax.
• contains an alphabetical summary of all ALLBASE/ISQL commands.
• describes the sample DBEnvironment, PartsDBE, which is supplied with the product.
An explanation is provided of how to install, and set up a copy of PartsDBE for practice
use.
• contains information about ALLBASE/SQL FIPS 127.1 compliance.
Most of the examples in this manual are based on the tables, views, and other objects in
the sample DBEnvironment PartsDBE. For complete information about PartsDBE, refer
to appendix C.