On a DDL or HDDL command in RC/Query why is the SET CURRENT SQLID not the creator of the object

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

When using the RC/Query for Db2 for z/OS (RCQ) DDL or HDDL command on an object the user is expecting the
SET CURRENT SQLID to be the CREATOR of the object. Instead it is the ID of the person using the tool.

Resolution

The intent of the DDL/HDDL command is for the user to create their own version of the object, therefore the SQLID is set to the ID of
the person using the tool. DDL generated using a Quick Migrate will pick up the CREATOR of the object for the SET CURRENT SQLID
since the objective is to migrate the object to another subsystem.