A user is planning to drop a table that has RI constraints; 1 parent and 7 children. He would like to extract the RI DDL for later use.
How can I generate the ALTER statements for RI DDL from an RC/Migrator Analysis?
DB2 for Z/os
Release : R20
RC/Migrator has an Analysis Option called "Exclusive Options". "BND/DAT/STA/SQL/GRNT/RI ==>". This option has a number of values that each alter the generated output.
This option is applicable only for Migrate strategy analysis.
The appropriate value to generate RI Alter Statements is:
I Generate only alters for table objects that are associated with
the referential integrity structure. You must specify the RI
Control Option 'L' (Local) or 'G' (Global), or select 'RI' for
at least one table on the RC/M Implode/Explode Services panel.
The following selections on the Strategy Analysis Options panel
will be ignored: Drop Objects; Image Copy; Bind; Rebuild Index;
and all Data Unload, Dataset Delete and VSAM Options.
As stated above in the help text for the field the accompanying option is
"RI (foreign keys) ==>" "G" or "L".
This will generate "ALTER TABLE" statements for the tables within the scope of the migration along with .SYNC statements and the other required Batch Processor statements such as .CONNECT and