Previous Topic: Comma-Separated ValuesNext Topic: Fixed-Format Records


Sample JCL (Comma-Separated Values)

Sample z/OS JCL

The following is a sample z/OS EXPORT job:

 //jobname    See the note above and Preparing JCL for Batch CA Dataquery Utilities.
 //       EXEC PGM=DQBATCH
 //STEPLIB    See the note above and Preparing JCL for Batch CA Dataquery Utilities.
 //SYSPRINT DD SYSOUT=*                            Print Output
 //SYSUDUMP DD SYSOUT=*
 //SNAPER   DD SYSOUT=*
 //SYSOUT   DD SYSOUT=*
 //DQOUT    DD DSN= ...  Specify according to your site standards
 //SYSIN    DD *                                   Command input
 SIGN/ON DQUSER
 FIND ALL CA-DETAIL-REC                                               X
    PRINT ITMID-ORDID=KEY ORD-QTY SHIP-QTY UNIT-PRICE DISC-PCT ACT-DT
 EXECUTE *
 EXPORT 'DOCUMENT1' DETAIL
 /*
 //

Sample z/VSE JCL

The following is a sample z/VSE EXPORT job to output to a data set on disk:

 * $$ JOB ...           See the note on the previous page and Preparing JCL for Batch CA Dataquery Utilities.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see Preparing JCL for Batch CA Dataquery Utilities.
 // DLBL DQOUTD,'datacom.dq.export',99/365
 // EXTENT ,VSEDT4
 // EXEC DQBATCH
 SIGN/ON DQUSER
 FIND ALL CA-DETAIL-REC                                                X
    PRINT ITMID-ORDID-KEY ORD-QTY SHIP-QTY UNIT-PRICE DISC-PCT ACT-DT
 EXECUTE *
 EXPORT 'DOCUMENT1' DETAIL DISK
 /*
 /&
 * $$ EOJ

The following is a sample z/VSE EXPORT job to output to a data set on tape:

 * $$ JOB ...           See the note on the previous page and Preparing JCL for Batch CA Dataquery Utilities.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see Preparing JCL for Batch CA Dataquery Utilities.
 // EXEC DQBATCH
 SIGN/ON DQUSER
 FIND ALL CA-DETAIL-REC                                                X
    PRINT ITMID-ORDID-KEY ORD-QTY SHIP-QTY UNIT-PRICE DISC-PCT ACT-DT
 EXECUTE *
 EXPORT 'DOCUMENT1' DETAIL TAPE
 /*
 /&
 * $$ EOJ