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:

To use @CONVERTFLOAT, the Extract and Replicat must be native objects; not TNS.

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)