Working with stored procedures

You can use the workbench to create, test, and deploy stored procedures. You can also debug stored procedures.

Stored procedures contain procedural constructs with SQL statements. Stored procedures are stored in databases and run on servers. An application can call a stored procedure by name and run the SQL statements that are included in the stored procedure. The application can be on the client, while the stored procedure executes its logic on the server. Stored procedures and user-defined functions are sometimes referred to collectively as routines.

Before you create stored procedures, you must complete some setup steps. See Prerequisites for developing routines for more information.

Stored procedure development is not supported for every available data source. See Stored procedure and user-defined function support by server type for details.

To create stored procedures, you must have the required authorities and privileges. See Authorities for DB2 stored procedures and user-defined functions for details.

Related concepts
Importing and exporting routines
Related tasks
Deploying and running routines
Prerequisites for developing routines
Related reference
Stored procedure and user-defined function support by server type
Related information
Changing default options for stored procedure and UDF development

Feedback