DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Condition/Restriction Reporting (DQCRRPT) › DQCRRPT JCL Samples

DQCRRPT JCL Samples

The following is a sample DQCRRPT JCL.

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.

Sample z/OS JCL

 //jobname    See the note above and Listing Libraries for CA Datacom Products.
 //       EXEC PGM=DQCRRPT
 //STEPLIB    See the note above and Listing Libraries for CA Datacom Products.
 //SYSUDUMP DD SYSOUT=*
 //SYSPRINT DD SYSOUT=*                            Print Output
 //SNAPER   DD SYSOUT=*
 //SYSIN    DD *                                   Command input
 SIGN/ON userid PASSWORD password
 REPORT    TITLE=CONDITION,TABLE=PAYROLL
 CONDITION NAME=TAXES
 REPORT    TITLE=CONDITION
 REPORT    TITLE=RESTRICTION,TABLE=PAYROLL
 GROUP     LEVELS=LEVEL1,LEVEL2,LEVEL3
 GROUP     LEVELS=LEVEL1
 USER      NAME=userid
 REPORT    TITLE=RESTRICTION
 /*
 //

Sample z/VSE JCL

 * $$ JOB ...          See the note above and Listing Libraries for CA Datacom Products.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see Listing Libraries for CA Datacom Products.
 // EXEC DQCRRPT
 SIGN/ON userid PASSWORD password
 REPORT    TITLE=CONDITION,TABLE=PAYROLL
 CONDITION NAME=TAXES
 REPORT    TITLE=CONDITION
 REPORT    TITLE=RESTRICTION,TABLE=PAYROLL
 GROUP     LEVELS=LEVEL1,LEVEL2,LEVEL3
 GROUP     LEVELS=LEVEL1
 USER      NAME=userid
 REPORT    TITLE=RESTRICTION
 /*
 /&
 * $$ EOJ