Setup of the stored procedure environment

Setting up the stored procedure environment includes establishing the stored procedure environment and defining your stored procedure to Db2. Typically, a system administrator customizes the environment, and an application programmer defines the stored procedure.

Before a stored procedure can run, you must define it to Db2. Use the SQL CREATE PROCEDURE statement to define a stored procedure to Db2. To alter the definition, use the ALTER PROCEDURE statement.