CONVERTALLFLOATSTOTDM | NOCONVERTALLFLOATSTOTDM

Valid for

Extract, Replicat

Description

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

• There is no column mapping for the file or table

• Any SQL/MP table is not a view

• Definitions are provided for the Enscribe files

CONVERTALLFLOATSTOTDM converts both 32 and 64 bit float data types because these are not converted by Oracle GoldenGate for Windows and UNIX.

Use CONVERTALLFLOATSTOTDM and NOCONVERTALLFLOATSTOTDM as toggles around the tables in the parameter file to turn the float data type conversion on for some of the tables and off for others. The NOCONVERTALLFLOATSTOTDM parameter will be in affect until the CONVERTALLFLOATSTOTDM parameter is encountered and vice versa.

Default

NOCONVERTALLFLOATSTOTDM

Syntax

CONVERTALLFLOATSTOTDM

Example

REPLICAT REPORD
CONVERTALLFLOATSTOTDM
TABLE $DATA03.SALES.ORDERS,
  TARGET $DATA03.SALES.ORDERS;
NOCONVERTALLFLOATSTOTDM
TABLE $DATA03.SALES.ORDERS,
  TARGET $DATA03.SALES.CUSTOMER;