HI,

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

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

What version for Webfocus, what platform?

What do you mean by "extract"

Do you have ETL?

Did you have some training?

I want read data from mainframe focus file through the webfocus.

So not extract but reporting.

Try this

TABLE FILE XXX
PRINT *
WHERE RECORDLIMIT EQ 100
END

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.

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.

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.

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.

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.

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.