Create and deploy a stored procedure to a DB2® database by using the IBM® Integration Toolkit.
You create a stored procedure that takes an input value for Employee Number, and returns data for the selected employee from four different tables in the database. Within the procedure, selected values from one table are used to select rows from other tables. This stored procedure shows that you can make a single call to the database. The database server then completes a number of operations before returning the result.
The scenario demonstrates how to deploy a stored procedure from the IBM Integration Toolkit to a DB2 database. Typically, a database administrator creates and deploys stored procedures. The steps are included here to demonstrate the tools that IBM Integration Bus provides to interact with databases.