search cancel

Generate HDDL in RCQ When RCQ_OFS is Set to NO in R16

book

Article ID: 21026

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description:

Using RC/Query for DB2 for z/OS (RCQ), HDDL can be generated through batch with the ENABLEXX parmlib member RCQ_OFS set to NO. This will allow the HDDL to be produced without quotations marks around the object and creator names.

Solution:

  1. Select an object in RC/Query

    <Please see attached file for image>

    Figure 1

  2. Issue "HDDL" on the CMD line, press Enter

    <Please see attached file for image>

    Figure 2

  3. On the RC/Query Hierarchical DDL Request Options screen, select B for Batch; press Enter

    <Please see attached file for image>

    Figure 3

  4. Execute the job, which should have a RC=0000 or RC=0004

  5. Go to your JES output and find the HDDLOUT DSN file name

    <Please see attached file for image>

    Figure 4

  6. Browse the DSN file and you will have the HDDL with no quotes

    <Please see attached file for image>

    Figure 5

Environment

Release:
Component: RCQ

Attachments

1558717893218000021026_sktwi1f5rjvs16uq3.gif get_app
1558717891212000021026_sktwi1f5rjvs16uq2.gif get_app
1558717889236000021026_sktwi1f5rjvs16uq1.gif get_app
1558717887266000021026_sktwi1f5rjvs16uq0.gif get_app
1558717885311000021026_sktwi1f5rjvs16upz.gif get_app