Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

DB2 Datatypes Supported for CDC

DB2 Datatypes Supported for CDC

PowerExchange supports most DB2 for i5/OS datatypes for CDC.
The following table identifies the DB2 for i5/OS source datatypes that PowerExchange supports and does not support for CDC:
DB2 Datatype
Supported for CDC?
BIGINT
Yes
BINARY
Yes
BLOB
No
CHAR
Yes
CLOB
No
DATALINK
No
DATE
Yes
DBCLOB
No
DECFLOAT
No
DECIMAL
Yes
DISTINCT (user-defined)
No
DOUBLE
Yes
FLOAT (floating-point)
Yes
GRAPHIC
Yes
INTEGER
Yes
LONG VARCHAR
Yes
LONG VARGHAPHIC
Yes
NUMERIC
Yes
REAL
Yes
ROWID
No
SMALLINT
Yes
TIME
Yes
TIMESTAMP
Yes
VARBINARY
Yes
VARCHAR
Yes
VARGRAPHIC
Yes

0 COMMENTS

We’d like to hear from you!