BYTEA in PostreSQL

BYTEINT in Teradata, 8-bit integer, -127 to 127

DB2, Teradata CALL statement

CASE as expression

CASE expression

Data type casting operator :: in Informix, PostgreSQL

PostgreSQL CAST(TIMEOFDAY() AS TIMESTAMP) that returns current date and time

CHAR and CHAR VARYING in Oracle, SQL Server, DB2, MySQL, PostgreSQL, Informix, Sybase ASE, Sybase ASA

CHARACTER & CHARACTER VARYING in Oracle, SQL Server, DB2, MySQL, PostgreSQL, Informix, Sybase ASE, Sybase ASA

CHECK constraint

CLOB in Oracle, DB2, Informix

CLOSE cursor statement

COLLECT STATISTICS statement in Teradata

Column constraint or propertirs

Parse a comment token

Oracle COMMENT statement

COMMIT statement

String concatenation CONCAT operator in DB2

CONNECT BY in Oracle

DB2 CONNECT statement

Constraint option

COPY statement

CREATE AUXILIARY TABLE in DB2

CREATE DATABASE in DB2, MySQL

CREATE FUNCTION

CREATE INDEX

CREATE INDEX storage options

CREATE PACKAGE

CREATE PACKAGE BODY

CREATE PACKAGE Specification

CREATE PROCEDURE

Sybase ASE CREATE RULE

CREATE SCHEMA in SQL Server, MySQL, Redshift

Oracle CREATE SEQUENCE

CREATE statement

DB2 for z/OS CREATE STOGROUP

CREATE TABLE statement

Parse CREATE TABLE column and constraints definitions

CREATE TABLESPACE in Oracle and DB2

CREATE TRIGGER statement

Body of CREATE TRIGGER statement

Try to recognize well-known patterns in Oracle trigger

CREATE TYPE in Oracle, SQL Server

CREATE VIEW statement

CURDOUBLE in Sybase ADS

DATA DIVISION

FILE SECTION. of DATA DIVISION

LINKAGE SECTION. of DATA DIVISION - program input/output parameters

Parse data section that can contain variable definitions, COPY and INCLUDE commands

Parse data type definition

WORKING-STORAGE SECTION. of DATA DIVISION - program static data

DATETIME2 in SQL Server

Parse datetime literal

DATETIME in SQL Server, MySQL, Informix, Sybase ASE, Sybase ASA

DATETIMEOFFSET in SQL Server, Sybase ASA

Parse specific DB2 AND syntax: (c1, c2, ...) = (v1, v2, ...)

DB2 for z/OS COMMENT ON tab (col IS 'comment' , ...)

DB2 CREATE INDEX storage options

DB2 CREATE TABLESPACE

DB2 FETCH FIRST n ROWS ONLY clause in SELECT statement

FOR COLUMN system_name in OS/400 to specify 10-char system name to access by old apps (like 8-char file name in Windows for DOS apps)

DB2 identity options in GENERATED ALWAYS or BY DEFAULT AS IDENTITY

Parse DB2 partitioning clause

DB2 RESULT_SET_LOCATOR declaration

Various SET options such as SET CURRENT SCHEMA

DB2 z/OS USING STOGROUP clause

Parse DB2 CREATE TABLE storage clause

DBCLOB in DB2

DECFLOAT in DB2

DB2 DECLARE name CONDITION FOR SQLSTATE 'value'; Sybase ASA DECLARE name EXCEPTION FOR SQLSTATE VALUE 'value'

DECLARE GLOBAL TEMPORARY TABLE in DB2

DB2, MySQL, Teradata DECLARE type HANDLER

DECLARE LOCAL TEMPORARY TABLE in Sybase ASA

SQL Server, DB2, MySQL DECLARE variable statement; Oracle DECLARE block (inner or anonymous)

SQL Server DECLARE TABLE variable

DECLARE for variable in SQL Server, DB2, MySQL; DEFINE in Informix

DEFAULT or DB2 WITH DEFAULT clause

Informix DEFINE variable statement

DELETE statement

DELIMITER statement in MySQL

Division operator /

DOUBLE PRECISION in Oracle, SQL Server, DB2, MySQL, PostgreSQL, Informix, Sybase ASE, Sybase ASA

DROP DATABASE statement in DB2, MySQL

DROP PROCEDURE statement

DROP SCHEMA in MySQL

Oracle DROP SEQUENCE

DROP statement

DB2 for z/OS DROP STOGROUP

DROP TABLE statement

DROP TRIGGER statement

ENVIRONMENT DIVISION

INPUT-OUTPUT section of ENVIRONMENT DIVISION

FILE-CONTROL. section of INPUT-OUTPUT section

Oracle EXCEPTION block

EXEC SQL statement

SQL Server, Sybase ASE EXEC statement

Oracle, Teradata EXECUTE IMMEDIATE; Teradata, MySQL, PostgreSQL EXECUTE statement; SQL Server, Sybase ASE EXECUTE/EXEC;

EXIT statement in Oracle, Informix, Netezza

DB2 CLP EXPORT command