Compare analysis generates CREATE DDL for Stored Procedures

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

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

Environment

Release : 20.0

Component : RC/Compare for DB2 for z/OS

Resolution

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.