View previous topic :: View next topic
|
Author |
Message |
foliater
New User
Joined: 06 Apr 2006 Posts: 31
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
foliater
New User
Joined: 06 Apr 2006 Posts: 31
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
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 |
|
|
foliater
New User
Joined: 06 Apr 2006 Posts: 31
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|