Generate RCM/RCC DDL file compatible with SPUFI or DSNTEP2

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

Can RC/Migrator for Db2 (RCM) and RC/Compare for Db2 (RCC) generate a DDL file that can then be executed through SPUFI or DSNTEP2? How?

Resolution

• For RC/Migrator, specify S for the BND/DAT/STAT/SQL/GRNT/RI Analysis Option.
• For RC/Compare, specify Y for the SQL ONLY Analysis Option.

Using these options, generates the DDLONLY parameter in the JCL PARMFILE DD.

You can use this in conjunction with the COMMIT Analysis Option.

This will generate a DB2 SQL only DDLFILE with COMMITs after each statement. The file can be executed through SPUFI or DSNTEP2 as there are no Batch Processor statements.

Additional Information

For further information refer to the Analysis Options documentation.