Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
bshkris

New User

Joined: 21 Mar 2005
Posts: 29
Location: pune

 Posted: Tue Jul 08, 2014 1:56 pm    Post subject: Date calculation thru SORT card. Hi, I have 2 date feilds in input file. Let say the date feilds starts in below positions Length start pos end pos DATE1 10 308 317 DATE2 10 318 327 I have date1 value 2014-09-23. Now i want to add 9months to date1 and place it in date2 feild. I was able to calculate 1 year to date1 but failed to add 9 months. The below is sort card for adding one year. OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29) the file's total length is 350 bytes, our date feilds exists from 308 to 327 bytes. If any one has idea how to do calculate the 9 months advanced date from given input value by using sort card, please let me know. Appriciate your help. Thanks.

Bill Woodger

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7314

 Posted: Tue Jul 08, 2014 3:31 pm    Post subject: Reply to: Date calculation thru SORT card. Can you post the sysout from a SORT step (doesn't matter which) so we can see what version you are at?
bshkris

New User

Joined: 21 Mar 2005
Posts: 29
Location: pune

 Posted: Tue Jul 08, 2014 3:59 pm    Post subject: ********************************* TOP OF DATA ********************************** 1 SYNCSORT FOR Z/OS 1.4.1.0R U.S. PATENTS: 4210961, 5117495 (C) 2010 SYNCS EAST z/OS 1.13.0 SYNCSORT LICENSED FOR LICE SYSIN : SORT FIELDS=COPY INREC OVERLAY=(308:30,10,318:30,10) OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29) OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29) * WER269A OUTREC STATEMENT : DUPLICATE STATEMENT FOUND WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000 WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE ******************************** BOTTOM OF DATA ********************************
Bill Woodger

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7314

 Posted: Tue Jul 08, 2014 5:21 pm    Post subject: Reply to: Date calculation thru SORT card. OK, you have SyncSort, whose questions belong in the JCL forum. You are fairly current with SyncSort. Consult your documentation. You should find DATEADD which is of use to you if you can define "nine months" as a number of days. If not, ask the analyst what is supposed to happen when you add nine months to 31 of May. You need to know, exactly, what "nine months" means. These are computers, they know nothing themselves.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Relational operator compare date rang... maxsubrat CLIST & REXX 14 Wed Feb 06, 2019 6:19 pm Build Dynamic Sort output and limit '... balaji81_k DFSORT/ICETOOL 1 Sat Feb 02, 2019 4:40 am PARAMETER 'F1' IS UNIDENTIFIED error ... Poha Eater DFSORT/ICETOOL 14 Fri Feb 01, 2019 2:39 pm SORT INNER JOIN [F1] OUT OF SEQ ERROR balaji81_k DFSORT/ICETOOL 8 Wed Jan 30, 2019 3:21 am Dates compare on specific dates using... balaji81_k DFSORT/ICETOOL 2 Thu Jan 24, 2019 12:03 am

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us