Creating database routines

You can use the workbench to develop stored procedures and user-defined functions, also known collectively as routines. Typically, you develop routines from a data development project in the Data Project Explorer. You can import and export routines to and from a data development project, deploy routines to database servers, and run and debug routines.

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

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

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

Related concepts
Comparing and modifying routines
Related tasks
Using Visual Explain for routines
Prerequisites for developing routines
Related reference
Authorities for DB2 stored procedures and user-defined functions
Stored procedure and user-defined function support by server type
Related information
Changing default options for stored procedure and UDF development

Feedback