Creating stored procedures

You can create a stored procedure from the Data Project Explorer, either from a data development project, from an existing SQL statement in a data development project, or by using the toolbar buttons. You can also create a stored procedure from a database connection in the Database Explorer.

If you create a stored procedure from a data development project, from an existing SQL statement in a data development project, or by using the toolbar buttons, a wizard guides you through the entire process. You can also simply specify a name and language for the stored procedure and then modify the source code in the routine editor. If you create a stored procedure from the Database Explorer, you can use the routine editor or the SQL editor.

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