My Input file has the date as CCYYDDD format and it is in Packed Decimal. I need to convert it to MM/DD/YY format. I couldn't found abot PD dates converison in the existing posts.
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
Hi,
This feature is available in SyncSort for z/OS 1.3 via OUTREC DT or OUTREC DTNS. You might need to use CENTWIN parameter as well. To get a better help, please tell the position of Date field & the SORT product you are using - in case it's SyncSort you need to tell what version of this is in use at your shop.
The Vesrion is SYNCSORT FOR Z/OS 1.2.3
The Date Positions details are given below:
FIELD LEVEL/NAME ---------- -PICTURE- -NUMBER START END LENGTH
-LAST-REQ-DATE S9(7) 10 41 44 4
As you can see It's a COMP-3 field.
Plea suggest the solution.
(Sorry I was away for long weekend)
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
jpdeshai,
The below SyncSort job does what you're trying to achieve. It works with my SyncSort version (SYNCSORT FOR Z/OS 1.2.1.0R). Please note that it assumes that the input file has CC values of 19,20 and 21 only.