Previous Topic Next topic Print topic

Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Database Access > DB2 > DB2 Stored Procedures > Writing and Preparing Stored Procedures > Preparing Stored Procedures

Preparing Stored Procedures

The following are tasks which must be completed before a stored procedure can be run on an DB2 LUW Server:

  1. Prepare the application according to your embedded SQL documentation for creating stored procedure.
  2. Define the stored procedure to the DB2 LUW Server. See Defining Stored Procedures under DB2 LUW.
  3. Place the stored procedure DLL or JAVA routine on the DB2 LUW Server machine in a location specified in the CREATE PROCEDURE. If not specified, the default location is the sqllib\function subdirectory where DB2 LUW is installed.
Parent topic: Writing and Preparing Stored Procedures
Previous Topic Next topic Print topic