DB2 - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

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.

Related Topics:

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 infor­mation.

eIf the CCSID is 1200 or 13488, then this is Unicode.