Rocket® Visual COBOL® (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
Preparing Stored Procedures
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 module on the DB2 LUW Server machine in a location specified in the CREATE PROCEDURE statement. If not specified, the default location is the 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.