The following example lists all tables in all schemas of the TSTDICT dictionary that have referencing access modules.
The use of the DICTNAME clause on the DATABASE parameter allows CA Culprit for CA IDMS to retrieve QRPT005 syntax from the DIRLDICT dictionary.
DATABASE DICTNAME=dirldict
USE "QRPT005" WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
REQUESTED_SCHEMA='%'
REQUESTED_TABLE='%' )
Sample QREPORT 005:
.sp QREPORT 005 SQL TABLE ACCESS REPORT mm/dd/yy PAGE 1 .sp .sp ACCESS MODULES THAT REFERENCE TABLE SCHEMA.TABLE NAME AM NAME VERSION AM SCHEMA ───────────────── ─────── ─────── ───────── .sp DEMO.TAB1 DYNDIAL1 1 JMA EXTCURS 1 JMA EXTCURSA 1 JMA INSBDIAL 1 DEMO JMADYN1 1 JMA .sp DEMOEMPL.DBCSTAB2 DBCSDIA2 1 DEMOEMPL .sp DEMOEMPL.DBCSTAB3 DBCSDIA5 1 DEMOEMPL .sp DEMOEMPL.DIVISION AMDCSQLT 1 DEMOEMPL .sp EMPDEMO.EMPLOYEE JMAAUG01 1 JMA JMABAT02 1 JMA JMABAT03 1 JMA JMANEST 1 JMA JMAPREP 1 JMA JMAPREP4 1 JMA JMASQL 1 JMA JMASQLB 1 JMA JMASQLD 1 JMA JMASQL2 1 JMA JMASQL2A 1 JMA JMASQL30 1 JMA SQLDEMOD 1 TSTSQL 1 JMA TSTSQLAM 1 JMA .sp INV.COMPONENT JMASQLI2 1 JMA .sp INV.PART JMASQLIV 1 JMA JMASQLI2 1 JMA .sp
|
Copyright © 2013 CA.
All rights reserved.
|
|