Posted: Mon Mar 26, 2007 10:29 am Post subject: Write Displayable Data using Sort
Hi Guys,
I've a small problem and hope you can help me.
I have a file with Fixed numbers and would like to read it and rewrite in a more readable form.
My file is composed by 3 number:
FIELD1: FIXED ( 11) - a number
FIELD2: FIXED ( 3) - a number
FIELD3: FIXED(9) - a date formatted DDMMYYYY in a number
I would like to read the file and rewrite it more "readble" with numbers as picture and maybe a date as a character reformatted as YYYYMMDD (I'm sorry, I hope you understand what I mean).
For example here's the hexadecimal of my record:
Code:
1000630008098
00009C1C0119C
I would like to obtain:
Code:
10000000693 010 19980810
I hope my example is clear, sorry and thanks a lot for any help!
Wish you a good one! _________________ Maxisnowhere
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Mar 26, 2007 10:50 am Post subject:
Here's a DFSORT job that will do what you asked for. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.
_________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
