I need to get from a particular Input sequential File of length 350, the records which have not been updated for last 6 months from current date.The update Timestamp is in position 224 to 249.
ie i need to know if UPDT-TIMESTAMP(1:10) > 6 months frm run date.
Is there anyway i can do it using a DFSORT? I went through material but could not figure how to do DATE1 - 6months?
It still doesn't work for me.
No changes on the sortout file although the abend doesn't happen anymore.
My requirement is I need to dynamically create the parm with the date values depending on when the job will be executed. If it is after 12AM, then I need to get the previous date in CCYYMMDD format.
Shanthi Jayaraman,
The arcvns card is working fine.Please note that you can olny use the &date with INCLUDE/OMIT conditions.I think ,to achive the final results as you are expecting,you need to have a turn around method.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
It still doesn't work for me.
I'd suggest you run the test exactly as it is posted. Until you can get the proven test to work on your system, there is no need to try for your version.
Please reply here if the test will work or will not work. We can proceed from there. If it does not work, post the jcl, control statements, the file output, and the queued output from the run.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Hi all,
My earlier post was to compare a date field with an offset of current date. If you are trying to create a future date (say current date+1 ), try out this synctool job.
********************************* TOP OF DATA **********************************
20080510
20080511
20080512
20080515
20080516
******************************** BOTTOM OF DATA ********************************
My earlier post was to compare a date field with an offset of current date. If you are trying to create a future date (say current date+1 ), try out this synctool job.
You can increment the value '+100001' in order to get different offsets.
e.g., '+100002' to get current date + 2.
Thanks,
Arun
Dear Arun,
I've tried this code and it works for me. I am very sorry I was not able to get back on this earlier.
Actually, I have created a COBOL pgm as a solution last week.
But I am still eager to find out solution using SORT utilities and your code has helped me much, in case in future there is similar requirement, I can use utilities instead of creating programs.
Once again, thank you very much for the knowledge...
********************************* TOP OF DATA **********************************
20080510
20080511
20080512
******************************** BOTTOM OF DATA ********************************