DBTEST (Execute Test/Analysis Programs) › DBTEST DBTSTPR (Test Program) › Example DBTSTPR JCL

Example DBTSTPR JCL

The following shows the commands to build a User Requirements Table for the PMF table in database 1, allowing no update ability. The DBTEST command invokes the CA Datacom/DB test program to locate the first key value with a state/zip code key of TX75000 or greater.

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.

 //jobname    See the previous note and JCL Requirements.
 //       EXEC PGM=DBUTLTY,REGION=2M
 //STEPLIB    See the previous note and JCL Requirements.
 //CXX      DD DSN=cxx.data.set,DISP=SHR           Directory data set
 //SYSIN    DD *                                   Command Input
          DBURSTR  MULTUSE=YES
          DBURTBL  DBID=1,TBLNAM=PMF
          DBUREND  SYSTEM=OS
          DBTEST   PGM=DBTSTPR
 DUMP=P
 *CMD TBLKEYNM  DBI KEY            ELEM*4
 LOCKGPMFSTZIP      TX75000
 /*

Sample Report

Following is a sample report page. For an example report header, see Sample Report Headers.