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 DATABASE
• ALTER IDENT
• ALTER SEQUENCE
• 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 here
• DECLARE CURSOR, see here
• DECLARE HANDLER, see here
• DECLARE VARIABLE, see here.

Embedded SQL Statements

Embedded SQL statements include the following statements:

• ALLOCATE CURSOR, see here
• ALLOCATE DESCRIPTOR, see here
• DEALLOCATE DESCRIPTOR, see here
• DEALLOCATE PREPARE, see here
• DESCRIBE, see here
• EXECUTE, see here
• EXECUTE IMMEDIATE, see here
• GET DESCRIPTOR, see here
• PREPARE, see here
• SET DESCRIPTOR, see here.

Embedded SQL Control Statements

Embedded SQL control statements include the following statements:

• DECLARE SECTION, see here
• WHENEVER, see here.

Procedural SQL Statements

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

• CALL, see here
• CASE, see here
• CLOSE, see here
• COMMIT, see here
• COMPOUND STATEMENT, see here
• DELETE CURRENT, see here
• DELETE, see here
• EXECUTE STATEMENT, see here
• FETCH, see here
• FOR, see here
• GET DIAGNOSTICS, see here
• IF, see here
• INSERT, see here
• ITERATE, see here
• LEAVE, see here
• LOOP, see here
• OPEN, see here
• REPEAT, see here
• RESIGNAL, see here
• RETURN, see here
• ROLLBACK, see here
• SELECT INTO, see here
• SELECT, see here
• SET SESSION, see here
• SET TRANSACTION, see here
• SET, see here
• SIGNAL, see here
• START, see here
• UPDATE CURRENT, see here
• UPDATE, see here
• WHILE, see here.

System Administration Statements

System administration statements include the following statements:

• ALTER DATABANK RESTORE, see here
• CREATE BACKUP, see here
• DELETE STATISTICS
• SET DATABANK, see here
• SET DATABASE, see here
• SET SHADOW, see here
• UPDATE STATISTICS, see here.

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