![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Platinum Member |
I'm trying to use the EXEC command to run a procedure on a remote server. The [AT server] part of the syntax is being ignored, and the version of the focexec that resides on the local server is run, rather than the one on the remote server. How might I get this to work? WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL | ||
|
Expert |
What code are you using ? Can you post it ? Waz...
| |||||||||||||||||||||||||||
|
Platinum Member |
For testing, I'm using this in the main focexec: EXEC EMPDATA AT server_name I've tried both the IP address and the server name for server_name. The EMPDATA procedure is: TABLE FILE EMPDATA SUM SALARY BY DIV BY DEPT END WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL | |||
|
Virtuoso |
From the help-file: There is nothing that indicates that you can use it like you did to cause it to runon a different server. The way to do that is to use the -REMOTE command set. The syntax you used is valid for MAINTAIN only... GamP
| |||||||||
|
Member |
GamP is right stating EXEC REMOTE DEST= -REMOTE BEGIN EX -REMOTE END In both case you need to have in the server communication configuration file (odin.cfg) [where your code is executing) the definition of the remote server. This is something that looks like (from memory) NODE= BEGIN CLASS=CLIENT HOST=ip_address_of_your_remote_machine PORT=your_remote_server_port END You can configure this REMOTE Server from the adapter tab on your local server console. | |||
|
Virtuoso |
JBK -- You did not indicate the nature of the interaction you are trying to accomplish. Do you need to pass local data to the remote server? Do you need the remote server to pass back an answer-set to the local server? | |||
|
Platinum Member |
j.gross, I will need the focexecs on the remote servers to create hold files to be passed back to the local server for reporting. WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL | |||
|
Expert |
Is the call being done from MAINTAIN ? Please check the previous posts. Use REMOTE for FOCUS, and EXEC AT with MAINTAIN. Waz...
| |||||||||||||||||||||||||||
|
Platinum Member |
The call is not being done in Maintain. WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|