SQL Statements

This chapter documents SQL statements in Mimer SQL.

In SQL there are different types of statements:

Procedural statements, including DML (Data Manipulation Language), see Procedural SQL Statements.

Data definition (DDL) statements, see Data Definition Statements.

Access control statements, see Access Control Statements.

Connection statements, see Connection Statements.

Declarative statements, see Declarative Statements.

Embedded SQL statements, see Embedded SQL Statements.

Embedded SQL control statements, see Embedded SQL Control Statements.

System administration statements, see System Administration Statements.

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 FUNCTION

ALTER IDENT

ALTER PROCEDURE

ALTER ROUTINE

ALTER SEQUENCE

ALTER SHADOW

ALTER STATEMENT

ALTER TABLE

ALTER TYPE

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.

Embedded SQL Statements

Embedded 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 (including DML), denoted procedural-sql-statement in syntax diagrams, include the following statements:

CALL

CASE

CLOSE

COMMIT

COMPOUND STATEMENT

DELETE CURRENT

DELETE

EXECUTE STATEMENT

FETCH

FOR

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

DELETE STATISTICS

SET DATABANK

SET DATABASE

SET SHADOW

UPDATE STATISTICS.

Usage Modes

The following usage modes apply for SQL statements in Mimer SQL:

Embedded

You can embed the statement in an embedded SQL application.

Interactive

You can use the statement in interactive SQL tools such as Mimer BSQL and DbVisualizer.

JDBC

You can use the statement via the Java Database Connectivity (JDBC) interface.

Module

You can embed the statement in a Module SQL application.

ODBC

You can use the statement via the Microsoft Open Database Connectivity (ODBC) interface.

Procedural

You can use the statement in a function, procedure, trigger or method.