search cancel

RCQ : HDDL command returns DDL for multiple data bases when one database was specified


Article ID: 214634


Updated On:


RC/Query for DB2 for z/OS


 In RC/Query, issuing 'HDDL' on a Database is generating DDL for many other databases in addition to the one the command was on, why?


Release : 20.0

Component : CA RC/Query for DB2 for z/OS


HDDL will build hierarchical DDL, the DB2 catalog is queried and all the necessary parent/child object dependencies are maintained.  If executed this will create the full set on the target environment with all the dependencies.

If there is a View with tables that cross databases, then the other Databases, Tablespaces, Tables, Indexes  etc,  will also be included.  The DDL that is generated by HDDL command is meant to create all the objects successfully and include related objects.

If it is known what object is causing all the related objects to be included, place an 'N' by the object type.  That will limit what is returned from the HDDL, however the object type that was not included will need to be generated another way so the parent objects are not missing dependents.