Distribute long column data - 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

You can distribute MS SQL Server columns that contain large objects to MS SQL Server and Oracle targets. The individual datatype mappings allowed by the Connect CDC Director are displayed in the table in Character and long character categories and in the table in Decimal numeric category .

Replication support for MS SQL Server long columns is limited to those methods of updating long data that allow Connect CDC insert, delete, and update triggers to fire on the user table. Consequently, long columns updated by the following methods may not be replicated:

  • WRITETEXT and UPDATETEXT SQL statements

  • DB-Library applications using dbwritetext and dbupdatetext function calls