Previous Topic: Type G - Number of Records With Unique Key ValuesNext Topic: Sample Report:  REPORT IXX - Type G


Example JCL

The following shows the command to print key related information for database 1, sequenced by table name.

Note: Use the following as a guide to prepare your JCL. The JCL statements are for example only. Lowercase letters in a statement indicate a value you must supply. Code all statements to your site and installation standards.

 * $$ JOB ...           See the previous note and JCL Requirements.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see JCL Requirements.
 // ASSGN SYSnnn,device-type,VOL=volser,SHR
 // DLBL CXX,'cxx',,DA                             Directory data set
 // EXTENT SYSnnn,volser
 // DLBL IXX001,'db001.index',,DA                  Index Area for DBID 001
 // EXTENT SYSnnn,volser
 // EXEC DBUTLTY,SIZE=750K
         REPORT   AREA=IXX,DBID=1,TYPE=G,UPDATE=YES
 /*
 /&
 * $$ EOJ