October 19th, 2009

Host Programs, Pascal

Posted by admin in Uncategorized
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