Focal Point
[Solved] FOCUS to WebFOCUS hub-sub relationship

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/897106211

May 12, 2009, 06:22 PM
Diptesh Patel
[Solved] FOCUS to WebFOCUS hub-sub relationship
Does anyone know if a FOCUS to WebFOCUS hub-sub relationship is possible?
I have a Focexec on MVS that I execute via JCL. I want that Focexec to -INCLUDE another focexec that resides on AIX, in a WebFOCUS environment. This Focexec uses Oracle data.
I can't move the focexecs, because I need the output of the MVS Focexec on the mainframe (and I'm trying to avoid FTPing the data up) and the focexec on AIX is used by other processes in WebFOCUS.
And for obvious reasons, I do not want to make copies of the Focexecs either.
I am thinking a hub-sub setup would do what I need, but I've never heard of a hub-sub with FOCUS.
Another option would be to invoke a WebFOCUS focexec on the mainframe using JCL. Anyone know how to do that?
We have FOCUS language running on the mainframe. We also have a WebFOCUS reporting server on the mainframe, and another WebFOCUS reporting server on AIX. The WebFOCUS Client is on AIX (for both the reporting servers).
Thanks for any help.
Diptesh

This message has been edited. Last edited by: Diptesh Patel,


Diptesh
WF 7.1.7 - AIX, MVS
May 12, 2009, 11:43 PM
Waz
You can do this with WebFOCUS to WebFOCUS.

In the past, you could do the following.

Create a sub server under the WebFOCUS server on MF. The sub server will point to the AIX WebFOCUS server.

If ports and access's are available and correct, you should be able to connect.

You should be able to execute the fex on AIX with the REMOTE command.

REMOTE DEST = {AIX Node in the ODIN file on the MF.}
REMOTE USER = {AIX User}
REMOTE_PASS = {AIX Users Password}

either

-REMOTE BEGIN
code
-REMOTE END

or
REMOTE EX {AIX Fex}


Hope it works.


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!

May 13, 2009, 03:47 AM
<JG>
Download the following

FOCUS for Mainframe Overview and Operating Environments DN1001055.1108

Chapter 8 Using FOCUS as a Client to a Reporting Server

Has all the information you need including how to set it up
May 13, 2009, 09:03 AM
Diptesh Patel
Thanks JG. I downloaded the manual, and am going thru it now.
Waz: I knew about the hub-sub between WebFOCUS servers. I need to do this between FOCUS and WebFOCUS, or figure out a way to kick off a Focexec in WebFOCUS via JCL.

Thanks all. I'll mark this topic as solved.


Diptesh
WF 7.1.7 - AIX, MVS