Restrictions - 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

Restrictions on the creation of DDL are as follows:

  • Oracle does not return DESCending index fields properly; some generated system names are returned, so the generated CREATE INDEX will fail.

  • Sybase and MS SQL Server currently do NOT determine if an index column is ASCending or DESCending, so all the CREATE INDEX statements generated will assume ASCending.

  • The Generate DDL command does not generate a CREATE TABLE statement that maintains column definitions that specify case sensitivity.

Case sensitivity can be set at the column level so if you have case-sensitive data and used the Generate DDL command to create the target table, replication might fail.  For example, case sensitive data may include values such as "Ab" and "aB" and "ab".  If you do not properly defined the target column, all values will be translated to "AB" or "ab".  This is only a problem if the target column is part of the primary key or unique index.