Hi!
I have one vsam file as input in which dates are in hex values so while sorting index field I'm using these date
Now I want data should be come in alphanumeric, flat file.
I have already use
(1,8,bi,zdf) didn't worked file have spaces
(1,8,hex)
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
Not a JCL/VSAM topic but a sort topic - moved to DFsort (if you use Syncsort then let us know and it will be moved there).
All data is in hex so please state which format your values are in: zoned decimal, packed or binary. And show examples of what they are and what you want. and use the code tags to present the data.
SORT FIELDS=COPY
INCLUDE COND=(27,4,BI,GE,X'20000101',AND, * EXPIRY DATE
27,4,BI,LE,X'20170520')
OUTREC FIELDS=(1,8,,C'!',9,2,C'!',20,1,C'!',47,6,C'!')
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
I think you are EXTREMELY confused. "zoned decimal" data would be X'F2F0F0F0F0F1F0F1' and X'F2F0F1F7F0F5F2F0' for your dates. You are treating them as full word binary values in your INCLUDE statement. Furthermore, you do NOT specify where you are getting spaces in your output -- if you think the date values should be there, then you need to include those bytes in your OUTREC FIELDS statement. Since you did not specify what you want from bytes 21 to 46 (which includes your date field), what did you think you would get there?