Description:
RC/Migrator provides a DDL Only option that generates the necessary DDL statements needed to re-create a DB2 structure. The generated DDL re-creates the DB2 structure including any referential integrity rules or security.
Solution:
Create a Migration strategy which specifies the Name and Creator of the Database on the RC/M Create Migration Strategy screen. Once the required object(s) are selected, proceed to the RC/M Strategy Analysis Options screen and under the label "Exclusive Options" BND/DAT/STAT/SQL/GRNT/RI ==> , select S for SQL. This option will generate SQL only with no Batch Processor commands included. This option will generate a snapshot of the DDL/DCL of the objects in the strategy.