SQL Statement Descriptions

---

This chapter documents SQL statements in Mimer SQL.

Access Control Statements

Access control statements can be divided into two categories: GRANT and REVOKE.

For information on GRANT statements, see:

• GRANT ACCESS PRIVILEGE
• GRANT OBJECT PRIVILEGE
• GRANT SYSTEM PRIVILEGE.

For information on REVOKE statements, see:

• REVOKE ACCESS PRIVILEGE
• REVOKE OBJECT PRIVILEGE
• REVOKE SYSTEM PRIVILEGE.

Connection Statements

For information on connection statements, see:

• CONNECT
• DISCONNECT
• ENTER
• LEAVE (PROGRAM ident)
• SET CONNECTION.

Data Definition Statements

For information on data definition (DDL) statements, see:

• ALTER DATABANK
• ALTER IDENT
• ALTER SHADOW
• ALTER STATEMENT
• ALTER TABLE
• COMMENT
• CREATE COLLATION
• CREATE DATABANK
• CREATE DOMAIN
• CREATE FUNCTION
• CREATE IDENT
• CREATE INDEX
• CREATE MODULE
• CREATE PROCEDURE
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE SHADOW
• CREATE STATEMENT
• CREATE SYNONYM
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• DROP.

Declarative Statements

Declarative-statements, denoted as declarative-statement in syntax diagrams, include the following statements:

• DECLARE CONDITION, see page 205
• DECLARE CURSOR, see page 206
• DECLARE HANDLER, see page 209
• DECLARE VARIABLE, see page 212.

Dynamic SQL Statements

Dynamic SQL statements include the following statements:

• ALLOCATE CURSOR, see page 138
• ALLOCATE DESCRIPTOR, see page 140
• DEALLOCATE DESCRIPTOR, see page 203
• DEALLOCATE PREPARE, see page 204
• DESCRIBE, see page 217
• EXECUTE, see page 224
• EXECUTE IMMEDIATE, see page 225
• GET DESCRIPTOR, see page 230
• PREPARE, see page 259
• SET DESCRIPTOR, see page 280.

Embedded SQL Control Statements

Embedded SQL control statements include the following statements:

• DECLARE SECTION, see page 211
• WHENEVER, see page 296.

Procedural SQL Statements

Procedural SQL statements, denoted procedural-sql-statement in syntax diagrams, include the following statements:

• CALL, see page 152
• CASE, see page 153
• CLOSE, see page 155
• COMMIT, see page 157
• COMPOUND STATEMENT, see page 159
• DELETE CURRENT, see page 215
• DELETE, see page 214
• EXECUTE STATEMENT, see page 226
• FETCH, see page 227
• GET DIAGNOSTICS, see page 236
• IF, see page 249
• INSERT, see page 251
• ITERATE, see page 253
• LEAVE, see page 254
• LOOP, see page 256
• OPEN, see page 257
• REPEAT, see page 260
• RESIGNAL, see page 261
• RETURN, see page 263
• ROLLBACK, see page 269
• SELECT INTO, see page 274
• SELECT, see page 271
• SET SESSION, see page 282
• SET TRANSACTION, see page 286
• SET, see page 276
• SIGNAL, see page 289
• START, see page 290
• UPDATE CURRENT, see page 293
• UPDATE, see page 291
• WHILE, see page 298.

System Administration Statements

System administration statements include the following statements:

• ALTER DATABANK RESTORE, see page 144
• CREATE BACKUP, see page 163
• SET DATABANK, see page 278
• SET DATABASE, see page 279
• SET SHADOW, see page 284
• UPDATE STATISTICS, see page 295.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se