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     [SOLVED] Extract the data from mainframe FOCUS to webfocus
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Extract the data from mainframe FOCUS to webfocus
 Login/Join
 
Member
posted
HI,

Please help me. how to extact the mainframe focus file using WEBFocus.

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


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What version for Webfocus, what platform?

What do you mean by "extract"

Do you have ETL?

Did you have some training?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Member
posted Hide Post
I want read data from mainframe focus file through the webfocus.


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
So not extract but reporting.

Try this

TABLE FILE XXX
PRINT *
WHERE RECORDLIMIT EQ 100
END




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I don't think you can.
As far as I know, webfocus is not able to communicate with foucs.
There are at least two ways to do what you need to done, but it is not going to be a one-step process.
1. Table the file and export it to a flat file. Transfer the flat file (and accompanying master) using ftp or some other file traqnsfer protocol to the webfocus environment, where you can read the file.
2. Install webfocus on the mainframe. Quite costly, but then, in the end it will be a one step process.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
<JG>
posted
It is totally dependant on where your WebFOCUS is.

If it is also on the mainframe/USS then all you have to do is issue the corrcet
DYNAM statement (providing you have the corrcet authorizations)
You must use DYNAM ALLOC as WebFOCUS does not understand the FOCUS TSO ALLOC command.

If it is not on the same mainframe then you need to install the iWay FOCUS DBMS adapter.
As GAMp says not a cheap option.
But if you want dynamic access the only option.

Again as GAMp says If all you want is extract, then a batch FOCUS job on the mainframe and ftp
to the WebFOCUS server.
 
Reply With QuoteReport This Post
<SomeUsr>
posted
What type of mainframe OS for FOCUS? (z/OS, z/VM, etc...) Where is the FOCUS data? (USS, minidisk, SU, etc...) If WebFOCUS and FOCUS are on different boxes, you may want to look at a HUB/SUB Setup. Your IBI Rep should be able to help.
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Our FOCUS databases are created by CORE FOCUS and reported against by WebFOCUS. Both WF and FOCUS reside on the HP UX box. In UNIX the owner of the databases must be "root" and the directory needs to be in you app path. As long as the FOCUS directory is in your app path you can even run/alter FOCUS programs from within WF, this is all possible if your WF Reporting server can see the box where the CORE FOCUS resides.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Raghuraman K, please update you signature, and can you give more information in your question.

JG is right to ask where your installation of FOCUS and WebFOCUS is, this is very important, as giving the right answer quickly is dependant on this.

If they are on different machines, then you will probably need to transfer the information as well, there have been other posts regarding this.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It would require a license, but The mainframe MVS /ZOS version of EDASERVER is a great way to access mainframe stuff. It would become "just another" WebFocus EDA Server to the Server side client. Many times I miss the channel speed to get thought masive amounts of data, from when we had when we had a mainframe installation. We now do a lot of ETL process to copy data onto a server.


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



 
Posts: 129 | Registered: June 01, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Extract the data from mainframe FOCUS to webfocus

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