Replicating datatypes for IBM DB2 UDB

This section lists the datatypes supported and unsupported by ECDA 15.0 ESD #3 for replicating into and out of IBM DB2 UDB.

Table 7 lists the Sybase datatypes supported and unsupported by ECDA 15.0 ESD #3 for replicating into IBM DB2 UDB.

**Table 7: Supported and unsupported Sybase datatypes**
Datatype	Supported	Unsupported
Sybase	bigint	bigdatetime
	integer	bigtime
	smallint	image
	tinyint	text
	decimal	unitext
	numeric
	unsigned bigint
	unsigned integer
	unsigned smallint
	unsigned tinyint
	unichar
	univarchar
	float
	double
	real
	money
	smallmoney
	date
	time
	datetime
	smalldatetime
	timestamp
	char
	nchar
	varchar
	nvarchar
	binary
	varbinary
	bit
	sysname (same as varchar(30))
	longsysname (same as varchar(255))
	user-defined datatypes (as underlying type)

Table 8 lists the IBM DB2 UDB datatypes supported and unsupported by ECDA 15.0 ESD #3 for replicating into IBM DB2 UDB.

**Table 8: Supported and unsupported IBM DB2 UDB datatypes**
Datatypes	Supported	Unsupported
IBM DB2 UDB	bigint	blob
	graphic	clob
	vargraphic	dbclob
	decfloat (for replication only, not gateway)	long varchar
	smallint	long vargraphic
	integer	ROWID
	decimal	long varchar for bit data
	real	xml
	double	user-defined datatypes
	time
	timestamp
	date
	char
	varchar
	char for bit data
	varchar for bit data
	float

The decfloat datatype is supported only in a replication environment (not for gateway or any other ECDA use).

Table 9 lists the IBM DB2 UDB datatypes that are supported and not supported by Replication Agent for replicating out of IBM DB2.

Replication Agent does not support these features of IBM DB2 UDB 9.5:

Replication of XML datatype

Since Replication Agent does not support replicating XML, restrictions have been imposed on marking a table containing XML columns. Replication Agent generates an error message each time an attempt is made to mark a table that has XML columns. To replicate all but XML columns of a table, use the force option when marking the table for replication.
When replicating DECFLOAT columns from IBM DB2 UDB to other back ends that do not support DECFLOAT or an equivalent datatype, DECFLOAT is mapped to FLOAT, which may cause a loss of precision.
Replication Agent does not support replication of DECFLOAT special values such as positive and negative INFINITY, NAN, and SNAN. Replication Agent replicates these values to NULL if the column is nullable, or “0.0” if the column is not nullable.