REPLACE (Replace All Data in a Table) › Example JCL

Example JCL

Following is a JCL example for the REPLACE function.

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
 //IN1      DD DSN=input                           Input data set
 //*
 //* NOTE: The following sort work allocations are not  
 //*       required if your sort package can dynamically
 //*       allocate sort work areas.  Be sure to provide
 //*       sufficient space for all keys to be sorted.  
 //*
 //SORTWK01 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SORTWK02 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SORTWK03 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SYSIN    DD *                                   Command Input
                      REPLACE DBID=1,TABLE=F01,DDNAME=IN1,SLACK=12,
                      SORT=300,MULTUSE=YES

 /*

Sample Report

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