September 28th, 2009

Host Programs, Fortran

Posted by admin in S. Host Programs
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

Leave a reply

:mrgreen: :neutral: :twisted: :shock: :smile: :???: :cool: :evil: :grin: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: