CONFIRM (Verify Constraint Integrity) › CONFIRM › Example JCL

Example JCL

This example confirms table DAT in database 30 and records exceptions to table DB.OPEN.

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.
 // EXEC DBUTLTY,SIZE=750K
   CONFIRM DBID=30,TABLE=DAT,VERIFY=YES,DELETE=YES,EXCEPT=DB.OPEN
 /*
 /&
 * $$ EOJ