2.33 CONVERTALLFLOATSTOIEEE | NOCONVERTALLFLOATSTOIEEE

Valid for

Extract, Replicat

Description

Use CONVERTALLFLOATSTOIEEE to convert the Tandem (TDM) float data type numbers used by Oracle GoldenGate for HP NonStop to the Institute of Electrical and Electronics Engineers (IEEE) format used by Oracle GoldenGate for Windows and UNIX. CONVERTALLFLOATSTOIEEE converts all the float data type numbers in a file or table if the following conditions are met:

• There is no column mapping for the table or file

• Any SQL/MP table is not a view

• Definitions are provided for the Enscribe files

CONVERTALLFLOATSTOIEEE converts 64 bit float data types (SQL/MP type float or Enscribe type double.) It does not convert 32 bit float data types (SQL/MP Real or Enscribe type float) because these are converted by Oracle GoldenGate for Windows and UNIX.

Use CONVERTALLFLOATSTOIEEE and NOCONVERTALLFLOATSTOIEEE as toggles in the parameter file to turn the conversion on for some of the files or tables and off for others. A CONVERTALLFLOATSTOIEEE parameter will be in affect until a NOCONVERTALLFLOATSTOIEE parameter is encountered and vice versa.

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.

Default

NOCONVERTALLFLOATSTOIEE

Syntax

CONVERTALLFLOATSTOIEE

Example

EXTRACT EXTORD
RMTHOST host01, MGRPORT 12345
CONVERTALLFLOATSTOIEEE 
TABLE $DATA01.SALES.ORDERS;
NOCONVERTALLFLOATSTOIEEE 
TABLE $DATA03.SALES.CUSTOMER;