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.