Access module management

ALTER ACCESS MODULE

CREATE ACCESS MODULE

DROP ACCESS MODULE

EXPLAIN

Authorization

GRANT definition privileges

GRANT EXECUTE

REVOKE SQL definition privileges

REVOKE EXECUTE

TRANSFER OWNERSHIP

Data manipulation

DECLARE EXTERNAL CURSOR

Logical data description

ALTER CATALOG

ALTER INDEX

ALTER SCHEMA

ALTER TABLE PROCEDURE

CREATE CALC

CREATE CONSTRAINT

CREATE INDEX

CREATE KEY

CREATE TABLE PROCEDURE

CREATE TEMPORARY TABLE

DROP CALC

DROP CONSTRAINT

DROP INDEX

DROP KEY

DROP TABLE PROCEDURE

Precompiler-directive

INCLUDE

Session management

RELEASE

RESUME SESSION

SET SESSION

SUSPEND SESSION

Transaction management

SET ACCESS MODULE

Identifiers

• Keywords as identifiers

Data-type

• GRAPHIC data type
• LONGINT data type
• NUM as a synonym for NUMERIC
• VARGRAPHIC data type

Literal

• G'double-byte-character-string-literal'

rowid-pseudo-column

SQL declaration sections

• Support for coding delimiters across multiple lines

Special-register

• GROUP
• CURRENT DATE
• CURRENT TIME
• CURRENT TIMESTAMP
• CURRENT DATABASE
• CURRENT SCHEMA
• CURRENT SQLID

Aggregate-function

• Column-name without DISTINCT in the COUNT function

COMMIT WORK statement

• CONTINUE parameter
• RELEASE parameter

CREATE TABLE statement

• IN parameter
• COMPRESS parameter
• ESTIMATED ROWS parameter

DECLARE CURSOR statement

• GLOBAL parameter

FETCH statement

• BULK parameter
• Buffer specification in the INTO parameter

INSERT statement

• BULK parameter

ROLLBACK WORK statement

• RELEASE parameter

SELECT statement

• PRESERVE parameter
• BULK parameter

WHENEVER statement

• Label without a colon
• CALL parameter