Target keys - use source indexes - connect_cdc_sqdata - Latest

Connect CDC (SQData) Db2 for z/OS Capture Quickstart

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Db2 for z/OS Capture Quickstart
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:14:41.127003

You may either update the table definition to specify the key or, as in this example, specify that the generated script should include the KEY IS clause by setting Auto-Detect Primary Keys to N, type REF on the command line and press ENTER.

You will then see when the script is generated that each of the target keys are specified in a KEY IS clause on the target descriptions. Those with a primary key or unique index will include the keys on the "KEY IS" clause, those that do not must be manually specified directly in the script.



  1. Press F3 to generate the replication script.
  2. You will find the KEY IS clause generated for each target Table as seen below.