HP 3000 Manuals HP 3000 Manuals
Chapter 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 chapter "SQL Statements" in this manual. For information about database administration, refer to the ALLBASE/SQL Database Administration Guide.