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] FOCUS to WebFOCUS hub-sub relationship
Go
New
Search
Notify
Tools
Reply
  
[Solved] FOCUS to WebFOCUS hub-sub relationship
 Login/Join
 
Gold member
posted
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
 
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
<JG>
posted
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
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] FOCUS to WebFOCUS hub-sub relationship

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