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
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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