Executing a Remote Procedure Call via SQL

  1. Select the RPC Interface Table check box.

  2. Specify the name of the program to execute in the File Name field.

  1. For VSAM running under CICS, specify the name of the CICS program to execute

  2. For VSAM running as started task, specify the name of the TSO program to execute.

  3. For VMS, specify the name of the DCL program to execute (prefixed by a $), or the name of the VMS RPC to execute (see the VMS RPC documentation)

    image31.gif

  1. Under Table Columns create a set of columns to map over the input and output buffers for the RPC.

  1. For VSAM running under CICS, specify the a set of columns to map over the COMMAREA on input, and another set of columns to map over the COMMAREA on output.

    image33.gif

  1. Under Table Properties, specify the total number of bytes for RPC input.

  2. Finally, specify the total number of bytes for the input and output as the Record Length.

  3. To execute the RPC, issue a select statement against the CONNX SQL Table that holds the RPC information. For example, the following statement will execute the RPC, and return the output columns.

Select * from CNXTime
  1. To specify data for the input columns, supply where criteria for them in the SQL Statement. For example, the following statement will execute the RPC, and return the output columns.

Select * from CNXTime where inputtime = '12:33:01'