HOw to add 1 day to the given input date (format: YYYY-MM-DD) using JCL Syncsort?

I want to add 1 day to the given input date. The input date is in YYYY-MM-DD format.

Can anybady please let me know how can I do this using Syncsort?

Ex:

Input date: 2011-10-31 (Format: YYYY-MM-DD)

Output date after add 1 day: 2011-11-01 (Format: YYYY-MM-DD)

Thank you, Raja开发者_如何学编程sekhar Jannu.

You can use DATEADD in Syncsort MFX for z/OS 1.4 to add one day.

Example syntax (where p= field position and l= field length):

OUTREC FIELDS=(...DATEADD=(p,l,DT=(4MD-),+1,DAY),...)

Please contact zos_tech@syncsort.com if you require further assistance.

Brian Wood Customer Service Representative Syncsort Incorporated 201-930-8260