Previous Topic: Multivolume INITsNext Topic: FILEOUT (Define Output Data Sets)

EXTRACT (Extract Data Table) › Example JCL

Example JCL

The following shows the command to extract the data table POL in area DEM in database 1 to the output data set, OUT1DD, on tape or disk. CA Datacom/DB outputs the data in physical track sequence.

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 note above and JCL Requirements.
 //       EXEC PGM=DBUTLTY,REGION=2M
 //STEPLIB    See the note above and JCL Requirements.
 //CXX      DD DSN=cxx.data.set,DISP=SHR           Directory data set
 //OUT1DD   DD DSN=out1dd,DISP=SHR                 Output data set
 //SYSIN    DD *                                   Command Input
          EXTRACT  AREA=DEM,DBID=1,DDNAME=OUT1DD,TABLE=POL,SEQ=PHYSICAL
 /*

Sample Report

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