General-purpose statements | DBEnvironment session management | Statements for obtaining and terminating database access. |
| Data definition | Statements for defining tables, views, indexes,
DBEFiles, DBEFileSets, TempSpace, and other SQL objects. |
| Data manipulation | Statements for selecting, inserting, and changing rows. |
| Transaction management | Statements for committing or rolling back work done within a single transaction. A transaction is a unit of work and may consist of one or multiple SQL statements. |
| Concurrency | Statements for managing data contention in multiuser mode. |
| Module Maintenance | Statements for managing modules and procedures.
|
Application programming statements | Single row data manipulation | Statements
for manipulating a single row with each statement execution. |
| Bulk data manipulation | Statements for
manipulating multiple rows with a single statement execution. |
| Cursor management | Statements for manipulating individual rows
in a set of rows that satisfy a SELECT statement. |
| Preprocessor directives | Statements for declarations in application programming. |
| Dynamically preprocessed queries | Statements for handling statements
preprocessed at run time. |
| Status messages | A statement for retrieving an ALLBASE/SQL message
describing the status of an SQL statement execution.
|
Database administration statements | Authorization | Statements for controlling DBEnvironment access. |
| DBEnvironment configuration and use | Statements for controlling DBEnvironments. |
| Space management | Statements for managing DBEFiles used for tables and indexes;
statements for managing temporary space for sorting. |
| Logging | Statements for managing log files. |
| DBEnvironment statistics management | Statements related to the
system catalog. |
| Procedure control flow statements | Statements used only inside procedures. |
Procedure statements | General and Control Flow Statements | Statements used only inside procedures.
|