EXTRACT (Extract Data Table) › EXTRACT › Example JCL (Output to Tape)

Example JCL (Output to Tape)

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. 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.

 * $$ JOB ...           See the note above and JCL Requirements.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see JCL Requirements.
 // ASSGN SYSnnn,device type,VOL=volser,SHR
 // DLBL CXX,'cxx',,DA                             Directory data set
 // EXTENT SYSnnn,volser
 // DLBL DEM001,'db001.dem',,DA                    Area DEM in DBID 1
 // EXTENT SYSnnn,volser
 // ASSGN SYS010,TAPE
 // PAUSE MOUNT TAPE
 // TLBL OUT1DD,'out1dd'                           Output data
 // EXEC DBUTLTY,SIZE=750K
          EXTRACT  AREA=DEM,DBID=1,DTFNAME=OUT1DD,TABLE=POL,
            DEVICE=TAPE,SEQ=PHYSICAL
 /*
 /&
 * $$ EOJ