http://developer.mimer.com

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

Connection statements include the following statements:

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

Data Definition Statements

Data definition (DDL) statements include the following statements:

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

Declarative Statements

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

• DECLARE CONDITION, see DECLARE CONDITION
• DECLARE CURSOR, see DECLARE CURSOR
• DECLARE HANDLER, see DECLARE HANDLER
• DECLARE VARIABLE, see DECLARE VARIABLE.

Dynamic SQL Statements

Dynamic SQL statements include the following statements:

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

Embedded SQL Control Statements

Embedded SQL control statements include the following statements:

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

Procedural SQL Statements

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

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

System Administration Statements

System administration statements include the following statements:

• ALTER DATABANK RESTORE, see ALTER DATABANK RESTORE
• CREATE BACKUP, see CREATE BACKUP
• SET DATABANK, see SET DATABANK
• SET DATABASE, see SET DATABASE
• SET SHADOW, for more information, see SET SHADOW
• UPDATE STATISTICS, see UPDATE STATISTICS.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se