VMS Help  —  SQLPRE72  Host Language Variable Declarations, FORTRAN Variables
    The following list describes the variable declaration syntax
    for character data types that the SQL precompiler supports in
    FORTRAN:

    o  CHARACTER

    o  CHARACTER character-set-name

    For information about the supported character sets, see the
    Oracle Rdb SQL Reference Manual.

    The following list describes the variable declaration syntax that
    the SQL precompiler supports in FORTRAN:

    o  Declarations - See the following table

    o  Initial values assigned in the declaration

    o  STRUCTURE declarations

    o  UNION declarations within structures

    o  RECORD statements

    o  DIMENSION statements

       -  DIMENSION statements are permitted only for declarations
          of indicator arrays. Although you can use any data type for
          indicator array elements, Oracle Rdb recommends that you
          use variables of the INTEGER data type.

       -  Multidimension arrays and dynamic-sized arrays are not
          supported.

    Table 8 Supported FORTRAN Datatypes

    FORTRAN type   SQL type       Comments and Restrictions

    BYTE           TINYINT
    CHARACTER*n    CHAR           The n represents a positive integer
                                  literal
    INTEGER        INTEGER
    INTEGER*1      TINYINT
    INTEGER*2      SMALLINT
    INTEGER*4      INTEGER
    INTEGER*8      BIGINT
    LOGICAL        INTEGER
    LOGICAL*1      TINYINT
    LOGICAL*2      SMALLINT
    LOGICAL*4      INTEGER
    LOGICAL*8      BIGINT
    REAL           REAL
    REAL*4         REAL
    REAL*8         DOUBLE
                   PRECISION
    STRUCTURE      VARCHAR        The named structure can be used
    /name/                        to define other FORTRAN host
      integer*2                   variables. The len component of
    len                           the structure must be set to the
      character*n                 correct length of the string before
    body                          use as a parameter to SQL. The
    END                           n represents a positive integer
    STRUCTURE                     literal
                   SQL_DATE       The SQL precompiler will transform
                   SQL_DATE_      the pseudo types in native FORTRAN
                   ANSI           datatypes.
                   SQL_DATE_VMS
                   SQL_TIME
                   SQL_
                   TIMESTAMP
                   SQL_INTERVAL   Use this data type for variables
                   (DAY TO        that represent the difference
                   SECOND)        between two dates or times.
                                  Precompiler Date-Time Data Mapping
                                  lists all the supported INTERVAL
                                  data types.

    Implicit declarations are not supported. SQL generates a "host
    variable was not declared" error when it encounters an implicitly
    declared variable in an SQL statement.
Close Help