Syntax Element      In PL/I
prefix              EXEC SQL
terminator          ;
target              label constant or
                    PL/I label variable

Variable Definition Syntax

PL/I variable definition =
    { DCL | DECLARE }
    { host identifier | (host identifier.,..) }
    type spec [ character representation...] ;

type spec =
    { { CHAR | CHARACTER } [VARYING] (length)
    [CHARACTER SET [IS] character set name] }
  | { BIT [VARYING] (length) }
  | { type fixed decimal ( precision [ , scale ] ) }
  | { type fixed binary [ ( precision ) ] }
  | { type fixed binary ( precision ) }

type fixed decimal =
    { DEC | DECIMAL } FIXED | FIXED { DEC | DECIMAL }

type fixed binary =
    { BIN | BINARY } FIXED | FIXED { BIN | BINARY }

type float binary =
    { BIN | BINARY } FLOAT | FLOAT { BIN | BINARY }

SQL Type                 PL/I Type
BIT(length)              BIT(length)
BIT VARYING(length)      BIT VARYING(length)
CHAR(length)             CHAR(length)
DECIMAL                  FIXED DECIMAL
  (precision, scale)       (precision, scale)
FLOAT(precision)         FLOAT BINARY(precision)
INTEGER                  FIXED BINARY
SMALLINT                 FIXED BINARY
VARCHAR(length)          CHAR VARCHAR(length)
SQLCODE                  FIXED BINARY (PP)
                         where PP = the
                         implementation defined
                         precision for SQLCODE.
SQLSTATE                 CHAR (5)
indicator                FIXED BINARY

Syntax Element      In PHP
prefix              $sql = "
terminator          ";
target              unsigned integer (must
                    correspond to a valid label)

Variable Definition Syntax

PHP variable definition =
host identifier... : type spec;

type spec =
    BIGINT | BINARY | BIT | CHAR | DATETIME | DECIMAL
  | FLOAT | INT | NUMERIC | REAL | SMALLDATETIME
  | SMALLINT | TIMESTAMP | TINYINT | VARCHAR

SQL Type            PHP Type
BITINT              String
BINARY              Stream
BIT                 Integer
CHAR                String
DATETIME            Datetime
DECIMAL             String
FLOAT               Float
INT                 Integer
NUMERIC             String
REAL                Float
SMALLDATETIME       Datetime
SMALLINT            Integer
TIMESTAMP           String
TINYINT             Integer
VARCHAR             Stream
SQLCODE             INTEGER
SQLSTATE            CHAR(5)
indicator           INTEGER

Syntax Element      In Pascal
prefix              EXEC SQL
terminator          ;
target              unsigned integer (must
                    correspond to a valid label)

Variable Definition Syntax

Pascal variable definition =
    host identifier... : type spec;

In Pascal, brackets ([ and ]) are part of the syntax of
variable declarations. They are also one of the
conventions used to create a syntax diagram. In the
following diagram, the expressions left bracket and right
bracket mean that brackets are literally used in the
Pascal statement. Brackets shown as ([ and ]) enclose an
optional portion of the statement.

 type spec =
    { PACKED ARRAY left bracket 1..length right bracket
    OF CHAR [ CHARACTER SET [IS] character set name] }
    | { PACKED ARRAY left bracket 1..length right bracket OF BIT }
    | BIT
    | INTEGER
    | REAL
    | { CHAR [CHARACTER SET [IS] character set name] }

SQL Type            Pascal Type
BIT(n)              BIT(n)
BIT VARYING(n)      BIT(n) VAR
CHAR(n)             CHAR
CHAR(length)        CHAR(n)
DECIMAL(p,s)        DEC(p,s)
DOUBLE PRECISION    BIN FLOAT(53)
INTEGER FIXED       BIN(31)
NUMERIC(p,s)        FIXED
REAL                BIN FLOAT(21)
SMALLINT            FIXED BIN(15)
VARCHAR(n)          CHAR(n) VAR
SQLCODE             INTEGER
SQLSTATE            CHAR(5)
indicator           INTEGER