Distribute long columns - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User 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 Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

Connect CDC supports the copying and replication of long datatype columns, that is, columns that contain large objects. The support is limited to IMAGE, TEXT, and NTEXT datatypes in MS SQL Server, IMAGE and TEXT in Sybase (Copy only), and to LONG, LONG RAW, CLOB and BLOB datatypes in Oracle.

Distributing long datatype columns requires no additional Connect CDC installation, setup, or modeling considerations, except that you cannot use such columns for data transformation, Distribution Keys, or conditional selection. In addition, Connect CDC conflict detection does not report exact long column values if a row containing a long column has a conflict.

See also System Reference for specific information on long column data.