Datatype Mapping Reference

Back Next

Virtual Source Columns and DB2 for Linux, UNIX, and Windows Target Columns

The following table identifies the recommended datatype mappings for virtual source columns and DB2 target columns:

Virtual Source Datatype	DB2 Target Datatype	Comments
BIGINT	DECIMAL(19)	-
DATE	TIMESTAMP	-
DECIMAL(`p`,`s`)	DECIMAL(31, 10) Mapping condition: `p` == -1 and `s` == -1 DECFLOAT(34) Mapping condition: `p` > 31 and `s` != -1 DECIMAL(31, 0) Mapping condition: `p` <= 31 and `s` == 0 DECIMAL(`p`,`s`)	-
DOUBLE	DOUBLE DECFLOAT	-
FLOAT	DOUBLE	-
INTEGER	DECIMAL(10)	-
NVARCHAR(`n`)	VARGRAPHIC(`n`)	-
TIMESTAMP	TIMESTAMP	-
VARCHAR(`n`)	VARCHAR(`n`)	If a SQL script gets values from CHAR or NCHAR source columns that include trailing space characters, the Applier and InitialSync truncate the trailing spaces on the target. The truncation occurs in Merge Apply mode or in Audit Apply mode if the apply.direct_load_for_audit_tables runtime parameter is set to 1.