Is there a way not to generate 'SET CURRENT SQLID' statements in the RC/Migrator analysis output?

Document ID : KB000054709
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

By default, the 'SET CURRENT SQLID' statements are generated automatically in the DDL that RC/Migrator for DB2 for z/OS (RCM) generates. 'SET CURRENT SQLID' statements are issued to ensure that correct CREATOR and CREATEDBY authorization IDs are used when creating objects.

However, sometimes users may not want to have these statements generated. Is there a way that they can be suppressed?

Solution:

If you do not want RC/Migrator to generate 'SET CURRENT SQLID' statements, set the 'NO SET CURRENT SQLID' in the RC/Migrator's profile settings to Y.

From the RC/Migrator main menu, select option:
0 - Profile, then
2 - RC/Migrator Profile Variables, then
Set "NO SET CURRENT SQLID ===> Y"

For more information, please refer to "Chapter 3: Profile Variables" of the RC/Migrator for DB2 for z/OS User Guide.