The DB2 UDB Option for CICS supports the use of DB2 stored procedures in both a two-tier, gateway-less environment, and a three-tier, gateway-enabled environment.
To execute a DB2 stored procedure
Define an RPC that has the same case-sensitive name as the DB2 stored procedure you want to use.
Make sure the CICS transaction name to which the RPC is mapped has a DB2 UDB Option setting for the RPC option of the DB2 stored procedure.
Execute the defined RPC with parameters that match the definition of the DB2 stored procedure.
For information on writing and using DB2 stored procedures, refer to the appropriate IBM documentation.
