Generate RCM/RCC DDL file compatible with SPUFI or DSNTEP2
search cancel

Generate RCM/RCC DDL file compatible with SPUFI or DSNTEP2

book

Article ID: 281918

calendar_today

Updated On: 06-17-2024

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.