Developing 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.

About this task

Before you create routines, you must complete some setup steps. See Preparing to develop routines for more information.

Routine development is not supported for every available data source. See Routine 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.


Feedback