SYSIN syntax in a separate data set
You can include all or part of the SYSIN syntax in a separate data set.
The following figure shows SYSIN syntax that includes a separate file as part of a Log Master filter. This technique allows you to dynamically generate a list of tables for each run of a job without changing your JCL.
JCL with SYSIN syntax in a separate data set
//SYSIN DD *
/* DB2DBA.$$WORKID0010 */
/* DB2DBA 2010-12-18 14.21.58 */
OPTION
FILTERREL AND EXECUTION MODE CURRENT
SORTOPTS
FILSZ NONE
HISTORY WRITE
WORKID DB2DBA.$$WORKID0010
DESC 'DB2DBA 2010-12-18 14.21.58 MIGRATE'
LOGSCAN
REPORT TYPE SUMMARY
SYSOUT
CLASS(*) NOHOLD
DB2CATALOG NO
FROM DATE(2010-12-18) TIME(12.39.00.000000)
TO DATE(2010-12-18) TIME(13.50.00.000000)
WHERE
TABLE NAME IN (
// DD DSN=DB2DBA.TABLIST.DATA,DISP=SHR
// DD *,DLM=##
)
##
//SQLCODES DD DUMMY
/* DB2DBA.$$WORKID0010 */
/* DB2DBA 2010-12-18 14.21.58 */
OPTION
FILTERREL AND EXECUTION MODE CURRENT
SORTOPTS
FILSZ NONE
HISTORY WRITE
WORKID DB2DBA.$$WORKID0010
DESC 'DB2DBA 2010-12-18 14.21.58 MIGRATE'
LOGSCAN
REPORT TYPE SUMMARY
SYSOUT
CLASS(*) NOHOLD
DB2CATALOG NO
FROM DATE(2010-12-18) TIME(12.39.00.000000)
TO DATE(2010-12-18) TIME(13.50.00.000000)
WHERE
TABLE NAME IN (
// DD DSN=DB2DBA.TABLIST.DATA,DISP=SHR
// DD *,DLM=##
)
##
//SQLCODES DD DUMMY
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*