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

1
votes

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, Rajasekhar Jannu.

1
mainframejcl

1 Answers

4
votes

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 [email protected] if you require further assistance.

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