The following example retrieves QRPT008 syntax from the CULLIB copybook library, and produces a Table Constraint Report for those tables in SYSTEM schema of TSTDICT that begin with the letter D.
DATABASE DICTNAME=dictionary-name
USE "QRPT008" WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
REQUESTED_SCHEMA='SYSTEM '
REQUESTED_TABLE='D%')
Sample QREPORT 008:
.sp QREPORT 008 SQL TABLE CONSTRAINT REPORT mm/dd/yy PAGE 1 .sp .sp TABLE NAME CONSTRAINT NAME TABLE REFERENCED REFERENCING TABLE ────────── ─────────────── ──────────────── ───────────────── SYSTEM.DBNAME DBTABLE-DBNAME SYSTEM.DBTABLE DBNAME-DBSEGMENT SYSTEM.DBSEGMENT DBNAME-DBSSC SYSTEM.DBSSC .sp .sp SYSTEM.DBSEGMENT DBNAME-DBSEGMENT SYSTEM.DBNAME .sp .sp SYSTEM.DBSSC DBNAME-DBSSC SYSTEM.DBNAME .sp .sp SYSTEM.DBTABLE DBTABLE-DBNAME SYSTEM.DBNAME .sp .sp SYSTEM.DMCL DMCL-BUFFER SYSTEM.BUFFER DMCL-DMCLSEGMENT SYSTEM.DMCLSEGMENT DMCL-JOURNAL SYSTEM.JOURNAL .sp .sp SYSTEM.DMCLAREA AREA-DMCLAREA SYSTEM.AREA DMCLSEG-DMCLAREA SYSTEM.DMCLSEGMENT .sp .sp SYSTEM.DMCLFILE DMCLSEG-DMCLFILE SYSTEM.DMCLSEGMENT FILE-DMCLFILE SYSTEM.FILE .sp .sp SYSTEM.DMCLSEGMENT DMCL-DMCLSEGMENT SYSTEM.DMCL SEGMENT-DMCLSEG SYSTEM.SEGMENT DMCLSEG-DMCLAREA SYSTEM.DMCLAREA DMCLSEG-DMCLFILE SYSTEM.DMCLFILE .sp
|
Copyright © 2013 CA.
All rights reserved.
|
|