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.
Note:
To use CONVERTALLFLOATSTOTDM
, the Extract and Replicat must be native objects; not TNS.
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;