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