Data Requester DB2AS400DataRequester_CustomRPC Project

The DB2AS400DataRequester_CustomRPC project contains three processes demonstrating remote procedure call mode using stored procedures and functions.

The processes in this project are:
  • Execute_procedure_GETPRICE
  • Execute_procedure_PARAMTEST
  • Execute_procedure_SETDESCRIPTION

JDBC Connection Resource

In this example, the JDBC Connection resource is configured as follows:

ADB Connection Resource

In this example, the ADB Configuration resource is configured as follows:

The Configuration tab is used to specify the mode and to select custom operations. The structure of the selected stored procedure is displayed on the Schema tab. In the following figure, RPC mode with custom operations has been selected.

Execute_procedure_GETPRICE Process

The following figure shows the General tab of the Execute_procedure_GETPRICE process:

Execute_procedure_PARAMTEST Process

The following figure shows the General tab of the Execute_procedure_PARAMTEST process:

Execute_procedure_SETDESCRIPTION Process

The following figure shows the General tab of the Execute_procedure_SETDESCRIPTION process: