Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to extract data from mainframe FOCUS to Flat file
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to extract data from mainframe FOCUS to Flat file
 Login/Join
 
Silver Member
posted
Hi Team,

I just want to know the list of possible ways to extract the mainframe FOCUS DB data to flat files into windows system.

Please let me know what are all the possible ways to extract data and put it in a flat file like notepad, csv etc.,

Regards,
Suresh

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA
 
Posts: 47 | Location: Bengaluru, India | Registered: December 04, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Open a new report, go to Output Format and take a look at those available, it's a god start.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2234 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Create a report on MF FOCUS that prints all the fields you want and at the end of that report add an ON TABLE HOLD AS whateverfilename FORMAT ALPHA.

This will create a text file with fix formatted columns of all the fields you have in your report. You can also use FORMAT COM or COMMA or COMT depending on what you want the output to look like. The best place to start learning the syntax and find examples is in the doc. Search for HOLD here http://documentation.informati...te77/mf_create77.pdf


WebFOCUS 8206, Unix, Windows
 
Posts: 1720 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Let's not forget that you are going to have to allocate the file prior to table request otherwise it will be created in temp space.

Then you will have to download the file and MASTER using either FTP or ConnectDirect.

Then you have to uncatalog the file on the MF to free up the disk space. This will keep the mainframe team off your back ... but they are old like me, so they are easy to outrun.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1101 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Also, what is the intention here? I mean what are we using the flat files for? Say you have some hideously ancient venerable legacy database on FOCUS with rows going past the excel limits, you'll need to remember you can't open those files if you just dump everything 'as is'... If you have a WebFOCUS on the windows, then reading them off the FOCUS and writing into an XFOC db, or MS SQL or even Access...

Making a text extract in itself is pretty elementary - the role of the MF FOCUS and the 'what' will reflect on the 1001 crazy and insane ways you CAN do it - vs. the one or two ways that are feasible, and doesn't upset the morlocks MF admins. Also remembering the cost structure of MF.


Cheers,
H.

WebFOCUS 8.1.05M
Oracle 11g - DB2
RedHat
 
Posts: 114 | Location: Brighton UK | Registered: February 19, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Hank W.:
hideously ancient
morlocks MF admins.


Hey! Just because we - quite rightfully Smiler - hold the keys to the kingdom doesn't give you the right to mock us!


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1101 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Smiler
quote:
Hey! Just because we - quite rightfully - hold the keys to the kingdom doesn't give you the right to mock us!
Cute, but I agree with Darryl.

This message has been edited. Last edited by: Doug,


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
 
Posts: 3045 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to extract data from mainframe FOCUS to Flat file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.