|
View previous topic :: View next topic
|
| Author |
Message |
alan_blore
New User
Joined: 01 Aug 2007
Posts: 50
Location: Hosur
|
|
|
|
Hi,
I have a dataset with some 1500 lines and it has a few Hexadecimal values too which is readable only with File Aid. Now one of my end user is asking the data, but for which I should send it in a readable format.
I believe i can write a small program for putting into report and download that for sending,
I wanted to know a easy way if we can send this file in a readable way to the user.
Thanks
alan....?! |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
I believe i can write a small program for putting into report and download that for sending,
I wanted to know a easy way if we can send this file in a readable way to the user. |
Probably. . .
How will the user "process" the data? Will they simply read it or will the data be used for a spreadsheet, database, or some other software?
Simply said, you would pass the input data and reformat it into a "download friendly" format. This could be a delimited text file for use in some local softwae or a report to be read by the user.
Either can be done with your own code or some utility. |
|
| Back to top |
|
|
alan_blore
New User
Joined: 01 Aug 2007
Posts: 50
Location: Hosur
|
|
|
|
Thanks Dick Scherrer for the info.
The user wants it in a readable format, either a text file or as a excel.
Since this was a one time request, I didn't want spend writing a smal code and executing it. I wanted to know if there is a way to provide this dataset containing Hexadecimal format to user in a readable way.
Thanks
alan....?! |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the file will not transform itself...
whether You like it or no You will have to write up something...
a small program, or the control cards for some utilities(fileaid,sort,....)
it does not matter if it is a one time job... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I didn't want spend writing a smal code and executing it. |
FWIW, writing some small cobol program would have probably been the far fastest way to do what you want (unless you have only 1 "problem field" and it being the first in the record). The time to clone some existing program to do what you want should be less than 30 minutes (see steps below).
For a 1-time shot, i usually want the fastest way to get the needed output. Sometimes that is using the sort product or some other utility, sometime it is a small program.
If you haven't already gotten something running, you might consider:
| Code: |
cloning a program that already reads or writes that file and throw away the procedure division code afte the open,
duplicating the fd with another name changing the "picture" of thd needed fields to make them visable,
adding another open (input or output depending on what the cloned program already does) and close,
read the file, move corresponding to the output record (field names would be the same, pics different), and write the new records. |
If you want to use your sort product, there are many topics in the forums on how to reformat data using either DFSORT or Syncsort.
One reason i use code for things like this is speed. Most utilities require you to count bytes and this is both very time comsuming and error prone. Counting bytes is also a pain with multi-format files and redefines. |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
can someone please explain what this actually means "few Hexadecimal values too which is readable only with File Aid. " ?
Gerry |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Gerry,
Same as tso/ispf HEX ON possibly. . . |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi Dick,
thanks for the explanation, the "readable only with FILEAID" threw me off.
Gerry |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Gerry,
You're welcome 
d |
|
| Back to top |
|
|
alan_blore
New User
Joined: 01 Aug 2007
Posts: 50
Location: Hosur
|
|
|
|
Thanks Dick Scherrer and Enrico-Sorichetti..
The exact issue is, am new to a project where I don't find people using COBOL for programming, So I wanted a sort to do this and wanted to know if there was any other way too,
And regarding the Sort, i tried searching for posts on how to reformat data using either DFSORT or Syncsort, but i didn't get exact one now. Anyhow I am having a look at the posts one by one.
Thanks for your information. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| am new to a project where I don't find people using COBOL for programming |
What are they using?
If this is a 1-tme shot, it should be no problem for you to use cobol even if cobol is not the main language used. . .
| Quote: |
| So I wanted a sort to do this and wanted to know if there was any other way too, |
In addition to sort, is suspect there are several other utilities available on your system - they key is that this would be on your system and we would not know what you have. Others in your organization should.
If your system uses DFSORT look at:
"Converting Numeric Fields to Different Formats" at:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.7?DT=20060615173822
"Editing Numeric Fields" at:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.8?DT=20060615173822
If you are not sure which sort product is used on your system, run any sort and the release info will be shown in the output info. |
|
| Back to top |
|
|
|
|
