As shown below, Connect CDC supports distribution of most DB2 datatypes. In the tables of supported datatypes in the following pages, the Numeric Length column shows the maximum supported number of numeric digits, while Display Length is the maximum number of characters, or the numeric length plus an included sign, if any.
An asterisk (*) means the length is taken from the column definition in the DBMS catalog. For decimal numeric types, the length is the number of positions to the left of the decimal point. For example, a NUMERIC(10,2) column has a length of 8.
|
Datatype |
Category |
NumericLength |
DisplayLength |
|---|---|---|---|
|
BIGINT |
Integral Numeric |
19 |
20 |
|
CHAR a |
Single-byte characterb |
|
* |
|
CHAR FOR BIT DATAc |
Binary |
|
* |
|
DATEd |
Date/Interval |
|
10 |
|
DECIMAL, DEC |
Decimal Numeric |
* |
|
|
DOUBLE,DOUBLE PRECISION |
Approximate Numeric |
|
|
|
FLOAT |
Approximate Numeric |
|
|
|
GRAPHIC |
Double-byte charactere |
|
|
|
INTEGER, INT |
Integral Numeric |
10 |
11 |
|
NUMERIC |
Decimal Numeric |
* |
|
|
REAL |
Approximate Numeric |
|
|
|
SMALLINT |
Integral Numeric |
5 |
6 |
|
TIME |
Interval |
|
8 |
|
TIMES d |
Date/Interval |
|
26 |
|
VARCHAR,CHARACTER VARYINGa |
Single-byte characterb |
|
* |
|
VARCHAR FOR BIT DATA c |
Binary |
|
* |
|
VARGRAPHIC |
Double-byte charactere |
|
|
|
a Columns with a length greater than 254 cannot be a distribution key. bIf the CCSID is 1208, then this is Unicode. cFor Bit data is not allowed as the distribution key or in data enhancement, expressions or gate conditions in any table mapping. d See the table for the supported range of dates, and see Supported Formats for DB2/400 DATE Columns for format information. eIf the CCSID is 1200 or 13488, then this is Unicode. |