Preface

Table of Contents

ALLBASE Manuals
New Features in G1, G2 and G3

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 Statements E - 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.

Preface

Technical documentation

» Table of Contents

» Index