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.