Data Type Mapping for Db2 for Linux, Unix, and Windows - DSS 6 | Data Source Solutions Documentation

Documentation: Data Type Mapping for Db2 for Linux, Unix, and Windows - DSS 6 | Data Source Solutions Documentation

Data Type Mapping for Db2 for Linux, Unix and Windows

This section lists the mapping of data types for Db2 for Linux, Unix and Windows (LUW).

Db2 for LUW as Source

When Db2 for LUW is used as a source location, following is the mapping of data types in Db2 for LUW to the corresponding Data Source Solutions DSS repository data type.

Db2 for LUW	Capture Support	Repository Data Type
bigint	Native	bigint
decfloat	Native	decfloat
decimal	Native	decimal
double	Native	double
float	Native	double
integer	Native	integer
numeric	Native	decimal
real	Native	real
smallint	Native	smallint
date	Native	ansidate
time	Native	time
timestamp	Native	timestamp
char	Native	char
char for bit data	Native	binary
clob	Native	clob
long varchar	Native	long varchar (db2)
long varchar for bit data	Native	long varbinary
varchar	Native	varchar
varchar for bit data	Native	varbinary
binary	Native	binary
blob	Native	blob
varbinary	Native	varbinary
dbclob	Native	dbclob
graphic	Native	graphic
long vargraphic	Native	long nvarchar (db2)
nclob	Native	dbclob
vargraphic	Native	vargraphic
xml	Native	db2 xml
boolean	Native	boolean
vector	Not supported
rowid	Not supported
user defined	Not supported

Db2 for LUW as Target

When Db2 for LUW is used as a target location, following is the mapping of DSS repository data types to the corresponding data type in Db2 for LUW.

* For Db2 LUW versions before 11.1.1.1, the repository data types bool and boolean are mapped to smallint. For Db2 LUW versions since 11.1.1.1, they are mapped to boolean.

Text in green cell indicates the native data type of the DBMS

{% partial file="dss6/advanced-operations/data-type-mapping/db2-for-linux-unix-and-windows-utf-8.template.md" /%}