View previous topic :: View next topic
|
Author |
Message |
Radhika N
New User
Joined: 03 Jun 2010 Posts: 1 Location: Hyderabad
|
|
|
|
I have unloaded data from multiple tables to a file. This unload file is not in a readable format, because some of the fields are declared in COMP, decimal etc.
How to convert this to a readable format file.
I want an output file in a readable format with each field separated by comma.
What is the SORT condition for this? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Before anyone can help you, you have to provide the information needed to help you.
Post the recfm and lrecl of the input and output files (prefereably one that is only a few fields and covers the datatypes you need to deal with).
Show some sample input data and the output you want from that input. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
If you can identify the individual fields in each record, yes, sort can do this.
Are you familiar with the inrec/outrec reformatting functions?
For instance: 10,4,BI,TO=ZD,LENGTH=8 which takes a four byte comp field beginning at the 10th byte of the file and converts it to an eight digit displayable decimal number.
The only trick is that you need to know exactly where each field is in order to convert it.
Sticking commas between the converted fields is very simple. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
Back to top |
|
|
|