The following example reports on all Access Modules defined for the JMA schema in TSTDICT.
DATABASE DICTNAME=dictionary-name
USE "QRPT004" WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
REQUESTED_SCHEMA='JMA '
REQUESTED_AM='%')
Sample QREPORT 004:
QREPORT 004 SQL ACCESS MODULE INFORMATION mm/dd/yy PAGE 1 .sp .sp TABLES ACCESSED AM NAME VERSION SCHEMA TIME OF CREATION LENGTH SCHEMA NAME TABLE NAME ─────── ─────── ────── ──────────────── ────── ─────────── ────────── .sp DYNDIAL1 1 JMA yyyy-mm-dd-hh.mm 0 DEMO TAB1 .sp EXTCURS 1 JMA yyyy-mm-dd-hh.mm 0 DEMO TAB1 .sp EXTCURSA 1 JMA yyyy-mm-dd-hh.mm 0 DEMO TAB1 .sp JMAAUG01 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMABAT02 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMABAT03 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMADYN1 1 JMA yyyy-mm-dd-hh.mm 0 DEMO TAB1 .sp JMANEST 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE .sp JMAPREP 1 JMA yyyy-mm-dd-hh.mm 4,800 EMPDEMO EMPLOYEE .sp JMAPREP4 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE .sp JMASQL 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE .sp JMASQLB 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMASQLD 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE .sp JMASQLIV 1 JMA yyyy-mm-dd-hh.mm 0 INV PART .sp JMASQLI2 1 JMA yyyy-mm-dd-hh.mm 0 INV COMPONENT INV PART .sp JMASQL2 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMASQL2A 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp JMASQL30 1 JMA yyyy-mm-dd-hh.mm 4,900 EMPDEMO EMPLOYEE .sp PREPARE 1 JMA yyyy-mm-dd-hh.mm 0 .sp TSTSQL 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE .sp TSTSQLAM 1 JMA yyyy-mm-dd-hh.mm 0 EMPDEMO EMPLOYEE
|
Copyright © 2013 CA.
All rights reserved.
|
|