Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Changing a file in File to readable format.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
alan_blore

New User


Joined: 01 Aug 2007
Posts: 50
Location: Hosur

PostPosted: Fri Jul 11, 2008 12:37 pm    Post subject: Changing a file in File to readable format.
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 11, 2008 8:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
alan_blore

New User


Joined: 01 Aug 2007
Posts: 50
Location: Hosur

PostPosted: Sun Jul 13, 2008 1:12 am    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Sun Jul 13, 2008 3:05 am    Post subject: Reply to: Changing a file in File to readable format.
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jul 13, 2008 4:16 am    Post subject:
Reply with quote

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
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sun Jul 13, 2008 5:42 am    Post subject:
Reply with quote

Hi,
can someone please explain what this actually means "few Hexadecimal values too which is readable only with File Aid. " ?


Gerry
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jul 13, 2008 7:57 am    Post subject:
Reply with quote

Hi Gerry,

Same as tso/ispf HEX ON possibly. . .
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sun Jul 13, 2008 2:25 pm    Post subject:
Reply with quote

Hi Dick,

thanks for the explanation, the "readable only with FILEAID" threw me off.


Gerry
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jul 13, 2008 5:52 pm    Post subject: Reply to: Changing a file in File to readable format.
Reply with quote

Hi Gerry,

You're welcome icon_smile.gif

d
Back to top
View user's profile Send private message
alan_blore

New User


Joined: 01 Aug 2007
Posts: 50
Location: Hosur

PostPosted: Sun Jul 13, 2008 11:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 14, 2008 12:27 am    Post subject:
Reply with quote

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:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.7?DT=20060615173822

"Editing Numeric Fields" at:

http://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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us