SQL Statement Descriptions
SQL statements in Mimer SQL may be divided into the following groups:
- Access control statements
- Connection statements
- Data definition statements
- Data manipulation statements
- Declarative statements
- Diagnostics statements
- Dynamic SQL statements
- Embedded SQL control statements
- Procedure control statements
- System administration statements
- Transaction control statements
The exact usage mode allowed for each statement is described with the syntactic definition for it appearing in this chapter, see Usage Modes for a description of the different usage modes.
Procedural SQL Statements
Note that four of the groups listed above, i.e. data manipulation statements, diagnostics statements, procedure control statements and transaction control statements can be considered as also belonging to a procedural SQL statement group.
Procedural SQL statements may be used within a function, procedure or trigger, see the Mimer SQL Programmer's Manual for a detailed discussion of the use of SQL in a Procedural usage context.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40