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.
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.
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.
Datatypes |
Supported |
Unsupported |
---|---|---|
IBM DB2 UDB |
bigint |
ROWID |
char |
user-defined datatypes |
|
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 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.