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

Syntax Element      In Fortran
prefix              EXEC SQL
terminator          none
target              unsigned integer (must be
                    the label of a statement
                    that appears in the same
                    program unit as the
                    WHENEVER clause)

Variable Definition Syntax

Fortran variable definition =
    type spec host identifier.,..

Fortran type spec =
    {BIT [ * length]}
  | { CHARACTER [ * length]
    [CHARACTER SET [IS] character set name] }
  | DOUBLE PRECISION
  | INTEGER
  | REAL

SQL Type            Fortran Type
BIT(n)              CHARACTER*L3
CHAR(n)             CHARACTER*n
DATE                CHARACTER*10
DECIMAL(p,s)        REAL*8
DOUBLE              REAL*8
INTEGER             INTEGER*4
NUMERIC(p,s)        REAL*8
REAL                REAL*4
SMALLINT            INTEGER*2
TIME                CHARACTER*8
TIMESTAMP           CHARACTER*26
VARCHAR(n)          requires conversion
SQLCODE             INTEGER
SQLSTATE            CHARACTER
indicator           INTEGER*4