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:
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.