search cancel

Compare analysis generates CREATE DDL for Stored Procedures


Article ID: 239374


Updated On:


RC/Migrator for DB2 for z/OS


CREATE DDL is generated for Stored Procedures despite the Ruleset attributes for Routines set to N.


Release : 20.0

Component : RC/Compare for DB2 for z/OS


The CREATE DDL can be explained by the following.

1. The Stored Procedures that are included in the analysis are dependent on objects in the strategy, so their inclusion as dependents is correct.

2. These Stored Procedures exist on the source subsystem but do not currently exist on the target.

3. CREATE DDL is generated for the Stored Procedures as they are source created new.

4. The Rule Set is only applicable to paired objects (those that exist in source and target) so they will not be applied to the Stored Procedures.