The following are high level tasks that must be completed before a stored procedure can be run on a DB2 LUW Server:
- Prepare the application according to your embedded SQL documentation for creating stored procedure.
- Define the stored procedure to the DB2 LUW Server. See
Defining Stored Procedures under DB2 LUW.
- Place the stored procedure
on the DB2 LUW Server machine in a location specified in the CREATE PROCEDURE statement. If not specified, the default location
function subdirectory under
sqllib in the home directory of your DB2 LUW instance.
Note: IBM provides specific documentation on preparing stored procedures. Look in your IBM documentation for information on creating
external routines and developing user-defined routines.