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

Syntax Element      In MUMPS
prefix              &SQL(
terminator          )
target              statement label

Variable Definition Syntax

MUMPS variable definition =
    { numeric variable | character variable };

MUMPS character variable =
    VARCHAR { host identifier (length) }...

MUMPS numeric variable =
    { DEC [ ( precision [ , scale ] ) ] }
  | INT
  | REAL }
    host identifier...

SQL Type            MUMPS Type
CHAR                VARCHAR
DECIMAL             DEC
INTEGER             INT
REAL                REAL
VARCHAR             VARCHAR
SQLCODE             INTEGER
SQLSTATE            VARCHAR (5)
indicator           INT

Syntax Element      In Fortran
prefix              SQLstr = "
terminator          ";
target              label

Variable Definition Syntax

Type variableName = value;

    where Type is:
    boolean | char | double | float | int | long | short | string

SQL Type            Java Type
BIGINT              long
BLOB(n)             byte
CHAR(1)             char
CHAR                string
CLOB(n)             string
DATE                date
DOUBLE              double
GRAPHIC             string
INTEGER             int
REAL                float
SMALLINT            short
TIME                time
TIMESTAMP           timestamp
VARCHAR             string
VARGRAPHIC          string
SQLCODE             int
SQLSTATE            char
indicator           int