Joined: 20 Dec 2006 Posts: 2 Location: Bangalore, India
I need to develop a job with the following criteria:
I have an input file containing a date (Run Date) and another one containing input data with a date field in all records.
I need to extract all the records from this input file having a date field equal to the Run Date + 1 Day(i.e. 2007-02-21).
Is it possible to increment the Run date by one day using DFSORT directly?
Please note that i will not be using the System Date for the Run Date file
Joined: 29 Nov 2006 Posts: 32 Location: Jacksonville, FL
Can your input date file have two dates in it, one to signify the run date and one to signify the extract date? Or, can you just specify the extract date and use the system date for the run date?
Joined: 20 Dec 2006 Posts: 2 Location: Bangalore, India
Sorry Alan,
The Input date file would contain only one date and it is quite possible that it may be much before the System Date.
I am afraid I cannot use the system date in any way in the job.
I just wanted to know if DFSORT can handle Date manipulations on non-system dates. Would make life a lot easier if it were so
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
basu_b,
With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct, 2010), you can use parm to pass values via parm and also add days to a given date.