Sample JCL files for mtsmaker on z/OS®

The following is sample JCL for using mtsmaker with an .mdq file:

//MTSMAKER EXEC PGM=MTSMAKER,
// PARM=`-Q <query_name> -M MDQFILE -F <query_name>.MTT -O OUTPUT'
//*-------------------------------------------------------------*
//*  Load library containing MTSMAKER and DBUTIL *
//*-------------------------------------------------------------*
//STEPLIB  DD  DSN=<load_library>,DISP=SHR
//*-------------------------------------------------------------*
//*  Print datasets *
//*-------------------------------------------------------------*
//SYSPRINT DD  SYSOUT=<sysout_class>
//SYSOUT   DD  SYSOUT=<sysout_class>
//SYSUDUMP DD  DUMMY
//*-------------------------------------------------------------*
//*  The MDQ file                                               *
//*-------------------------------------------------------------*
//MDQFILE  DD  DSN=<mdq_file>,DISP=SHR
//*-------------------------------------------------------------*
//*  The output MTS file.  This must be a variable format file. *
//*  Maximum record length is optional; 255 is sufficiently * 
//*  large while not being too large to allow viewing in ISPF.  *
//*-------------------------------------------------------------*
//OUTPUT   DD  DSN=<mts_file>, 
//             DISP=(NEW,CATLG,DELETE),
//             DCB=(LRECL=255,RECFM=VB),
//             UNIT=<unit_adapter command>,
//             SPACE=<space_allocation>                           

The following is sample JCL for using mtsmaker without an .mdq file:

//MTSMAKER EXEC PGM=MTSMAKER,PARM=`-@PARMS'
//*-------------------------------------------------------------*
//*  Load library containing MTSMAKER and DBUTIL *
//*-------------------------------------------------------------*
//STEPLIB  DD  DSN=<load_library>,DISP=SHR
//*-------------------------------------------------------------*
//*  Print datasets *
//*-------------------------------------------------------------*
//SYSPRINT DD  SYSOUT=<sysout_class> 
//SYSOUT   DD  SYSOUT=<sysout_class> 
//SYSUDUMP DD  DUMMY
//*-------------------------------------------------------------*
//*  The output MTS file.  Can be a member of a PDS as long as  *
//*  the format is variable.                                    * 
//*-------------------------------------------------------------*
//OUTPUT   DD  DSN=<mts_library>(<member_name>),DISP=SHR
//*-------------------------------------------------------------*
//*  The -@ option allows MTSMAKER parms to reside in a file    *
//*-------------------------------------------------------------*
//PARMS    DD  *
   -T <table_name>
   -D <DB2_subsystem_name>
   -F <table>.MTT -O OUTPUT
/*