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
• DECLARE CURSOR
• DECLARE HANDLER
• DECLARE VARIABLE.

Dynamic SQL Statements

Dynamic SQL statements include the following statements:

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

Embedded SQL Control Statements

Embedded SQL control statements include the following statements:

• DECLARE SECTION
• WHENEVER.

Procedural SQL Statements

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

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

System Administration Statements

System administration statements include the following statements:

• ALTER DATABANK RESTORE
• CREATE BACKUP
• SET DATABANK
• SET DATABASE
• SET SHADOW
• UPDATE STATISTICS.

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