To manipulate date using SORT



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

To manipulate date using SORT

Postby praveen_nayak17 » Tue May 26, 2009 11:55 pm

:?: Hi All,

Could anyone help to subtract one day from a date filed(in YYYYMMDD format) in input file and write it in output file using sort???

Below is the sample file having date:
20090526
20090525

Expected output file should have records as
20090525
20090524

Thank you ...
Praveen Nayak
praveen_nayak17
 
Posts: 8
Joined: Thu Jan 15, 2009 11:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: To manipulate date using SORT

Postby Alissa Margulies » Wed May 27, 2009 12:13 am

Hello Praveen.

At this time, SyncSort does not have a special function to perform arithmetic on input date fields. We can only provide offsets to the current system date. However, I would be happy to speak with development to see if this can be incorporated into a future release of the product.

Regards,
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: To manipulate date using SORT

Postby arcvns » Wed May 27, 2009 12:28 am

I would be happy to speak with development to see if this can be incorporated into a future release of the product.
Looking forward to see that one in SyncSort. :)
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post