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
 

 

A flat file copied in the file master Multirec. format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
foliater

New User


Joined: 06 Apr 2006
Posts: 31

PostPosted: Fri Mar 06, 2009 3:07 pm    Post subject: A flat file copied in the file master Multirec. format
Reply with quote

Hi - I have a flat file and its copybook.

We do view a flat file matching with its copybook in file master.

Can that output be put into a flat file?


I needed this for separating the data into separate fields with the field names over the top and later extracting that into an excel sheet which i will do using file transfer.
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 Mar 06, 2009 8:51 pm    Post subject:
Reply with quote

Hello,

Quote:
Can that output be put into a flat file?
Possibly.

Quote:
We do view a flat file matching with its copybook in file master.
What does the file master documentation say? Try F1 (maybe 2 times) when you are in view. There is often documentation available via the help facility for the product.
Back to top
View user's profile Send private message
foliater

New User


Joined: 06 Apr 2006
Posts: 31

PostPosted: Thu Mar 12, 2009 5:07 pm    Post subject: Reply to: A flat file copied in the file master Multirec. fo
Reply with quote

Hi - Thanks for the reply. I couldnt find anything regarding this in File Master Help. . Now I have coded in SAS to do the same activity. The problem is that for a different file and layout I have to code again.

It would be still helpful, if I get some information on doing this activity thru other tools like file aid, file manager, etc.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Thu Mar 12, 2009 11:03 pm    Post subject:
Reply with quote

I've used COBOL to accomplish what you're doing. Using the copy book for the file, I wrote out the 1st record, consisting of headings, in comma separated value format, then wrote the files records in CSV format. The 1st one was a bit time consuming, but after doing several, I could write a new COBOL program customized for a different file in very little time. The purpose of the CSV files was to provide end users an Excel version of various input and output files used for their testing, since they preferred working with spread sheets to File-Aid.
Back to top
View user's profile Send private message
foliater

New User


Joined: 06 Apr 2006
Posts: 31

PostPosted: Fri Mar 13, 2009 4:01 pm    Post subject: Reply to: A flat file copied in the file master Multirec. fo
Reply with quote

COBOL is not going to help me. I am doing the same thing in SAS, in that way I can avoid atleast the compilation.

Yes! of course we can save some time once we got the base ready for customizing as you said.

I was just wondering if we could display matching the layout format then it would be also possible to get the same into a file using file master or other tools.

If this is not possible I think I need to create some REXX tool to do that quickly.

I shall share with you people If I complete the tool. I might start doing it if I get frequent requests like this.
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 Mar 15, 2009 10:00 am    Post subject:
Reply with quote

Hello,

I believe the online has sufficient information to do what you want (if my understanding is correct).

Using the "Code" tag post a very small file (or the first several dields of one) and data that matches that file layout.

I'll see what i can do on one of my systems and see what happens.
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 -> CA Products 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