RQE02001I HDDL COMPLETED RC=12,68,400 doing Batch HDDL

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

When attempting to use a wildcard to bring in multiple databases for the HDDL command within RC/Query for Db2 for z/OS (RCQ),
the following error occurs:

SSID xxxx
LOCATION LOCAL
SQLID ABCDE
OBJTYPE DB
NAME "TESTDB*"  <<<<
SQLDLIM ;
SPUFIIND N
OBJECTS NYYYYYYYYYYY
OWNERIND N
RICHAIN  Y
GENGRANT Y

Error: RQE02001I - HDDL COMPLETED.  RC=12,68,400.

Resolution

Wildcards are not supported. To bring in multiple databases see the information below:

Use the ALL Command to Apply Changes to Many Objects

1. In RCQ get a list of the wanted Databases :  DB L TESTDB*

2. On the top command line type 'ALL HDDL'.  This will place 'HDDL' next to all the databases. Press ENTER.  You are taken to the Execution Specifications.

3. Choose Batch, then 'P to preview the JCL. There will be an entry for each DB:

 OBJTYPE DB
 NAME "TESTDB1"
 OBJTYPE DB
 NAME "TESTDB2"
 OBJTYPE DB
 NAME "TESTDB3"
  

This functionality was part of Level Set 20.0.10 (PTF LU12138) distributed 11/30/2023.
The PTF for the ALL functionality is LU11816 (11/7/23).

New Features in Level Set 20.0.10