HELPLIB.HLB  —  SQLPRE72  SQLPRE Command Line, Arguments  FLOAT
    Syntax options:

       FLOAT=D_FLOAT
       FLOAT=G_FLOAT
       FLOAT=IEEE_FLOAT

    Specifies the floating point representation that the SQL
    precompiler uses for floating point data types in a formal
    parameter list and specifies the floating point qualifier passed
    to the language compiler.

    The SQL Precompiler translates embedded SQL into host language
    declarations and procedure calls. In addition it generates the
    procedures behind the procedure calls. The /FLOAT qualifier
    for SQL$PRE determines the floating point format that SQL$PRE
    assumes for host language variables and, hence, determines the
    conversions that will be made internal to the generated SQL
    procedures. When SQL$PRE calls the host language compiler to
    process the precompiled program it passes an equivalent qualifier
    to its /FLOAT qualifer that is supported by the host language.
    This means that to the extent that the floating point format
    of host language variables is determined by a /FLOAT qualifier,
    the floating point formats of the host language variables and
    the parameters of procedure calls generated by SQL$PRE are
    guaranteed to be compatible. When the host language provides
    a type which explicitly declares the floating point format of
    the an individual variable, SQL$PRE uses that information to
    determine the conversion needed regardless of the setting of the
    /FLOAT qualifier.

    The SQL Precompiler's default floating point format for single
    or double precision floating point types is F-Floating and G-
    Floating format, respectively. This is equivalent to using a
    qualifier of /FLOAT=G_FLOAT with the SQL$PRE command.

    If a host language variable is a record or structure (for example
    a qualified parameter in the INTO clause of a singleton SELECT
    statement), any fields in the record or structure that are of a
    floating point type follow the same rules as described above.

                                   NOTE

       The Common Data Dictionary supports floating point types.
       However when the /FLOAT qualifier specifies IEEE_FLOAT,
       these types may not be used.
Close Help