Focal Point
[RESOLVED]Running Fexes Remotely

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

May 10, 2011, 05:05 PM
moyer1dl
[RESOLVED]Running Fexes Remotely
We have upgraded to 7.7 but they eliminated the project environment which had the gui check box and button to run the EDA fex remotely in our MVS environment.

What is the equivalent of this in code?

Any help

Dan

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


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
May 10, 2011, 05:30 PM
Waz
I guess the code would be:

REMOTE DEST
REMOTE USER
REMOTE PASSWORD

REMOTE EX {fex}

or

-REMOTE BEGIN
{code}
-REMOTE END


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 11, 2011, 08:42 PM
Jim Morrow
I have a couple of things which submit a MVS batch job from the WINDOWS NT WebFocus using FTP. Look at file type of "JES". The RACF authority must be properly configured.

Because of "security policy" Direct Connect transfers the job output back to the server. The requester receives an e-mail from the MVS with a link.

This takes a bit of doing to get working, but the entire mainframe becomes a "reporting server".


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



May 12, 2011, 09:41 AM
moyer1dl
Thanks WAZ the second solution worked.


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
July 25, 2011, 01:35 PM
vaayu
I am curious if the REMOTE BEGIN/REMOTE END will only work with HTML output? We have a situation where we have to use it for other output types PDF, EXL etc., Any ideas?
July 25, 2011, 05:51 PM
Waz
What you have to understand about REMOTE BEGIN/END or EX is that the current session becomes the client and the remote connection become the server.

Therefore any output that is PCHOLDed will return to the client (current session).

Once the output is there, it can be "handled".

I recently posted an example of returning PDF from a REMOTE connection to solve a performance issue.


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!

July 26, 2011, 05:21 PM
vaayu
Thank you! I will try this and see.
 
-REMOTE BEGIN 
TABLE FILE CAR
PRINT CAR SALES
ON TABLE PCHOLD FORMAT EXL2K
END
-REMOTE END

July 26, 2011, 09:35 PM
j.gross
quote:
ON TABLE PCHOLD FORMAT EXL2K

That gets it to the local server, but then what?

More likely you need something like:

-REMOTE BEGIN 
  TABLE FILE CAR
    PRINT CAR SALES
    ON TABLE PCHOLD 
  END
-REMOTE END
TABLE FILE HOLD
  PRINT *
  ON TABLE PCHOLD FORMAT EXL2K
END



- Jack Gross
WF through 8.1.05