HP 3000 Manuals HP 3000 Manuals
SQL Statement Categories
Writing queries is the basis of data manipulation in ALLBASE/SQL. All
users employ the SELECT statement for this purpose. SQL has several
other general-purpose statements, and also has statements specifically
for use by application programmers or database administrators. The SQL
statements are functionally summarized in Table 1-1. For the commands in
each category, refer to Table 10-1, "SQL Statement Summary."
Table 1-1. SQL Statement Categories
-----------------------------------------------------------------------------------------------
| | | |
| Group | Category | Purpose |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| General-purpose | DBEnvironment session | Statements for obtaining and |
| statements | management | 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 | Single row data manipulation | Statements for manipulating a |
| statements | | 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 | Statements for handling |
| | queries | statements preprocessed at run |
| | | time. |
| | | |
| | Status messages | A statement for retrieving an |
| | | ALLBASE/SQL message describing |
| | | the status of an SQL statement |
| | | execution. |
| | | |
-----------------------------------------------------------------------------------------------
Table 1-1. SQL Statement Categories (cont.)
-----------------------------------------------------------------------------------------------
| | | |
| Group | Category | Purpose |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Database administration | Authorization | Statements for controlling |
| statements | | DBEnvironment access. |
| | | |
| | DBEnvironment configuration | Statements for controlling |
| | and use | 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 | Statements related to the |
| | management | system catalog. |
| | | |
| | Procedure control flow | Statements used only inside |
| | statements | procedures. |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| Procedure statements | General and Control Flow | Statements used only inside |
| | Statements | procedures. |
| | | |
-----------------------------------------------------------------------------------------------
If you are embedding SQL statements in an application program, refer to
the ALLBASE/SQL application programming guide for the language you are
using. Bulk data manipulation is not available for FORTRAN. COBOL and
FORTRAN do not provide the full set of dynamic preprocessing statements.