Remote Execution

To have FOCUS automatically log you on to a server, create a FOCEXEC containing the REMOTE DESTINATION, REMOTE USERID, and REMOTE PASSWORD commands.

• The REMOTE DESTINATION command directs requests to a particular server.
• The REMOTE USERID command sets the user ID for logging on to the server. When FOCUS issues a request, it sends the user ID to the security system on the server (for example, RACF on z/OS).
• The REMOTE PASSWORD command sets the user password. When FOCUS issues a request, it sends the password to the security system on the server (for example, RACF).

You can send FOCUS requests to the server for execution as follows:

• Use the REMOTE EX command from the FOCUS Session prompt to name a FOCEXEC on the client that you want to execute on the server.
• Include the commands -REMOTE BEGIN and -REMOTE END around the code you are sending to the server. Then execute the procedure as you would any other FOCUS procedure. Expansion of Dialogue Manager amper variables takes place on the client, before the request is forwarded to the server.
• Use TableTalk to create the request and select the Execute on Remote Server option on the final TableTalk screen.

When the server returns report output, FOCUS displays the report in Hot Screen.

Another way to execute report requests against remote data is to begin the FOCEXEC that you want executed on the server with the command -REMOTE BEGIN, and follow the END command with -REMOTE END. Then execute the FOCEXEC.

Using -REMOTE BEGIN and -REMOTE END provides the following advantages:

• The command for executing the procedure is the same that you would use locally.
• By adding -REMOTE BEGIN and -REMOTE END, developers can separate FOCEXECs into different components, each of which may be executed remotely or locally.
• You do not need to have a Master File for the target data source on the client with this approach.

Keep the following restrictions in mind:

• When developing applications (that is, when coding FOCEXECs), you can use multiple -REMOTE BEGIN and -REMOTE END pairs in the FOCEXEC. You cannot nest -REMOTE BEGIN and -REMOTE END pairs.
• If a -RUN command falls between a -REMOTE BEGIN and -REMOTE END command pair, it is treated as if it were a -REMOTE END, followed immediately by a -REMOTE BEGIN. All FOCUS commands preceding the -RUN are sent up to and executed on the server. Commands following the -RUN are placed on the FOCUS stack when control returns to the client and are executed on the server when the -REMOTE END is encountered.
• You cannot mix REMOTE commands in a FOCEXEC. For example, you cannot use the REMOTE EX command for a FOCEXEC that contains -REMOTE BEGIN and -REMOTE END commands. This restriction applies to other FOCEXECs executed from within your main FOCEXEC by -INCLUDE or EX commands.

 
1. -REMOTE BEGIN 
2. JOIN PROD_CODE IN &1 TO PROD_CODE IN PROD AS AJOIN
   TABLE FILE &1
   PRINT UNIT_SALES
   AND COMPUTE
   MARGIN/D8.2= RETAIL_PRICE - UNIT_COST;
   BY STORE_CODE BY PROD_CODE
   END 
3. -REMOTE END

EX MARGIN SALES

All FOCUS and system messages returned by the server are displayed, as are error messages resulting from remote execution.

FOCUS places the error message numbers in the Dialogue Manager variable &FOCERRNUM, which can then be tested in FOCEXECs.

The REMOTE FIN command logically terminates a FOCUS session with a server. It should be issued at the conclusion of remote data access. The server must be available when you issue this command.

Note: Issuing a FIN command in native FOCUS closes all active sessions.

The ? REMOTE command displays all remote session parameters in effect. Issue it at any time in your FOCUS session.