4.7 CONVERTFLOAT

@CONVERTFLOAT converts HP NonStop Tandem (TDM) float numbers to Windows and UNIX Institute of Electrical and Electronics Engineers (IEEE) format or from IEEE float format to TDM float format.

The @CONVERTFLOAT function always converts if you map the column; it does not check whether it is a 32 or 64 bit float data type. However, it is not necessary or wise to use @CONVERTFLOAT to map 32 bit float columns for conversion to IEEE, because Oracle GoldenGate for Windows and UNIX automatically does this conversion.

Note:

Because Tandem floats compared to IEEE floats are stored using differing sizing for both the exponent and precision, conversion can result in an inexact result. When this happens it is generally seen as a slight rounding on the converted value.

Syntax

@CONVERTFLOAT (col_name, (TOIEEE | TOTDM))

col_name

The name of the column containing the float numbers to be converted.

TOIEEE | TOTDM

The format to which to convert; IEEE or TDM.

Example

COLMAP num01 = @CONVERTFLOAT (num01, TOIEEE)