Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2007Report 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, 2006Report This Post
Member
posted Hide Post
I want read data from mainframe focus file through the webfocus.


Raghuraman K
 
Posts: 26 | Registered: March 16, 2007Report 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, 2006Report 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 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report 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.
 
Report 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.
 
Report 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, 2007Report 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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders