Learn about the datatypes supported and unsupported for replicating into and out of IBM DB2 UDB.
These Sybase datatypes are supported or unsupported by ECDA 15.0 ESD #3 for replicating into IBM DB2 UDB.
|
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)) |
||
|
UDDs (as underlying type) |
These IBM DB2 UDB datatypes are supported or unsupported by ECDA 15.0 ESD #3 for replicating into IBM DB2 UDB.
|
Datatypes |
Supported |
Unsupported |
|---|---|---|
|
IBM DB2 UDB |
bigint |
blob |
|
graphic |
clob |
|
|
vargraphic |
dbclob |
|
|
decfloat (for replication only, not gateway) |
long varchar |
|
|
smallint |
long vargraphic |
|
|
float |
ROWID |
|
|
integer |
long varchar for bit data |
|
|
decimal |
xml |
|
|
real |
UDDs |
|
|
double |
||
|
time |
||
|
timestamp |
||
|
date |
||
|
char |
||
|
varchar |
||
|
char for bit data |
||
|
varchar for bit data |
The decfloat datatype is supported only in a replication environment (not for gateway or any other ECDA use).
These IBM DB2 UDB datatypes are supported or unsupported by Replication Agent for replicating out of IBM DB2 UDB.
|
Datatypes |
Supported |
Unsupported |
|---|---|---|
|
IBM DB2 UDB |
bigint |
ROWID |
|
char |
UDDs |
|
|
char for bit data |
xml |
|
|
blob |
||
|
clob |
||
|
date |
||
|
dbclob |
||
|
decfloat |
||
|
decimal |
||
|
double |
||
|
float |
||
|
graphic |
||
|
integer |
|
|
|
long varchar |
||
|
long varchar for bit data |
||
|
long vargraphic |
||
|
real |
||
|
smallint |
||
|
time |
||
|
timestamp |
||
|
varchar |
||
|
varchar for bit data |
||
|
vargraphic |
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 with XML columns. To replicate all but the XML columns of a table, use the force option when marking the table for replication.
When replicating DECFLOAT columns from 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.