Embedded SQL requires that the storage representation for double variables be d_floating, because the Embedded SQL runtime system uses that format for floating-point conversions. If your Embedded SQL program has double variables that interact with the Embedded SQL runtime system, you must make sure they are stored in the d_floating format.

Because the default Pascal format is d_floating, your program will automatically use the correct storage representation unless you use the g_floating compiler option. Any module compiled with this option must not use double variables or float literals to interact with Ingres. Ingres treats float literals as double precision numbers. Note that Embedded SQL recognizes only single, and not double or quadruple, exponential notation for real constants. Thus, any real constants passed to Ingres are always single precision and are unaffected by the g_floating compiler option.