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.