How to get a future date with Syncsort

anjanav · New User Joined: 07 Mar 2007 Posts: 1 Location: NY

Hi,

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?

Appreciate your help in this.

Have a good day.

Thanks.

Frank Yaeger · Posted: Wed Mar 07, 2007 10:22 pm Post subject:

You can use INCLUDE or OMIT with DATE1-d where d is the number of days (yyyymmdd-days) or DATE2-m where m is the number of months (yyyymm-m).

For more information, see:

www.ibm.com/servers/storage/support/software/sort/mvs/peug/

Shanthi Jayaraman · New User Joined: 11 Jun 2007 Posts: 7 Location: Malaysia

Dear All,

I am trying to get future/previous date with the below code but getting abend as syntax error :

dick scherrer · Posted: Thu May 08, 2008 11:40 am Post subject:

Hello,

You are using Syncsort rather than DFSORT.

What version of Syncsort are you running? The version is shown near the top of the information printed when you execute the sort.

Shanthi Jayaraman · New User Joined: 11 Jun 2007 Posts: 7 Location: Malaysia

The version is :

SYNCSORT FOR Z/OS 1.2.1.0R

It doesn't work with SyncSort?

arcvns · Posted: Thu May 08, 2008 1:59 pm Post subject:

It works with syncsort as well.

Shanthi Jayaraman · New User Joined: 11 Jun 2007 Posts: 7 Location: Malaysia

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.

sril.krishy · Posted: Fri May 09, 2008 12:38 am Post subject:

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.

Thanks
Krishy

dick scherrer · Posted: Fri May 09, 2008 5:07 am Post subject:

Hello,

arcvns · Posted: Fri May 09, 2008 10:26 am Post subject:

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.