How can I change the SET CURRENT SQLID statement when templating an object?

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

 

Using RC/Update to template an object, the generated CREATE DDL on the 'RC/Update Template Confirmation' panel is in read only format. The only option on the screen is to press ENTER or to PF3.

 

Press ENTER to perform creation.  Press PF3/15 to return to template session.

    SET CURRENT SQLID = 'userid';

CREATE  TABLE NEW.TABLE        

...

..

.

 

How can I amend the SET CURRENT SQLID statement to specify a different SQLID?

 

Answer:

 

There are 3 ways to amend the SQLID depending on whether this is a one-off requirement, or whether you want to change this for the entire session or on a more permanent basis. 

 

1. The EDIT command can be used to change any of the generated DDL statements, including the SET CURRENT SQLID statement, on the 'RC/Update Template Confirmation' panel. This will display the SQL Editor panel so that the statements can be edited prior to being processed.

 

Alternatively, you could override the SQLID in one of two ways before generating the DDL:

 

2. By specifying the desired SQLID on the CA Database Management Solutions for DB2 for z/OS main menu:

For example:

DB2 SSID ==> TEST LOCATION ==> LOCAL
ACM ==> OFF ACMID ==> TESTACM SQLID ==> xxxxxxx

 

3. You can also enter the 'SET CURRENT SQLID xxxxxx' on any of the panels to change the SQLID on the fly.

Now when you generate the DDL using the template option in RC/Update, the generated SET CURRENT SQLID statement will be set to the ID specified. 

 

Note, when using both option 2 and option 3, the SQLID value is stored in your ISPF Profile, in member RCPROF.