Data Replication
- Data Replication 9.8.0 HotFix 2
- All Products
DB2 Source Datatype
| Greenplum Target Datatype
| Comments
|
---|---|---|
BIGINT
| BIGINT
| -
|
BLOB
| BYTEA
| Data Replication does not extract LOB data from compressed rows.
Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB.
|
CHARACTER( n )
| CHAR( n' )
| -
|
CHARACTER FOR BIT DATA
| BYTEA
| -
|
CLOB( n )
| VARCHAR( n' )
| Data Replication does not extract LOB data from compressed rows.
Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB.
|
DATE
| DATE
| -
|
DBCLOB
| TEXT
| Data Replication does not extract LOB data from compressed rows.
Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB.
|
DECFLOAT
| VARCHAR(45)
| -
|
DECIMAL( p ,s )
|
| -
|
DOUBLE
| DOUBLE PRECISION
| When replicating an 8-byte floating-point numeric value to a DOUBLE PRECISION column on the target, the Applier rounds this value and preserves only 15 digits after the decimal point by default. Use the apply.merge.double_precision runtime parameter to change the default precision value.
|
GRAPHIC( n )
| CHAR( n' )
| -
|
INTEGER
| INTEGER
| -
|
LONG VARCHAR( n )
| VARCHAR( n' )
| Data Replication does not extract LONG VARCHAR data from compressed rows.
|
LONG VARCHAR FOR BIT DATA
| BYTEA
| Data Replication does not extract LONG VARCHAR FOR BIT DATA data from compressed rows.
|
LONG VARGRAPHIC
| TEXT
| Data Replication does not extract LONG VARGRAPHIC data from compressed rows.
|
REAL
| REAL
| When replicating a 4-byte floating-point numeric value to a REAL column on the target, the Applier rounds this value and preserves only 8 digits after the decimal point by default. Use the apply.merge.float_precision runtime parameter to change the default precision value.
|
SMALLINT
| SMALLINT
| -
|
TIME
| TIME
| -
|
TIMESTAMP
| TIMESTAMP
| -
|
VARCHAR( n )
| VARCHAR( n' )
| -
|
VARCHAR FOR BIT DATA
| BYTEA
| -
|
VARGRAPHIC( n )
| VARCHAR( n' )
| -
|