ALLBASE/SQL Reference Manual (36216-90216)

Chapter 2 59
Using ALLBASE/SQL
2 Using ALLBASE/SQL
This chapter shows how to use SQL statements for the following basic tasks:
Creating DBEnvironments
Starting and Terminating a DBE Session
Creating Physical Storage
Defining How Data is Stored and Retrieved
Understanding Data Access Paths
Controlling Database Access
Manipulating Data
Managing Transactions
Auditing DBEnvironments (including setting up partitions)
Using Wrapper DBEnvironments
Using SQLAudit
Application Programming
Using Multiple Connections and Transactions with Timeouts
Administering a Database
Understanding the System Catalog
The next chapters contain more detailed information about the following topics:
SQL Queries
Constraints, Procedures and Rules
Concurrency Control
The examples in this chapter are not intended to show all the functionality of the
statements. For detailed information on ALLBASE/SQL statements, refer to the chapters
“SQL Statements” in this manual. For information about database administration, refer to
the ALLBASE/SQL Database Administration Guide.