Records in OVLY member

  OPTION COPY
  INREC OVERLAY=(59:JP1)

This example illustrates how you can use a JCL PROC symbol in a DFSORT control statement.

The JCL PROC symbol is DAY which will be set to a 1 character numeric value (2 in this example), and used to overlay the number of days in the SELECT statement (in the SEL member).

PARM='JP1"&DAY"' is used to create a DFSORT symbol named JP1 containing a string with the DAY value.

The SYMNOUT listing will show the following:

------ SYMNAMES STATEMENTS FROM EXEC PARM -------
JP1,S'2'

------------------ SYMBOL TABLE -----------------
JP1,C'2'

The DFSORT INREC statement in the OVLY member uses JP1. It will be transformed to:

  INREC OVERLAY=(59:C'2')

and used to change the SELECT statement to the following in SORTOUT:

SELECT * FROM MYTABLE WHERE TM_RECEIPT >= (CURRENT DATE - 2 DAYS)