If you create a SQL or Java 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 Data Source Explorer, you can use the routine editor or the SQL and XQuery editor.
Before you create SQL or Java stored procedures, you must complete some setup steps. See Preparing to develop routines for more information.
Stored procedure development is not supported for every available data source. See Routine support by server type for details.
To create SQL or Java stored procedures, you must have the required authorities and privileges. See Authorities for DB2 stored procedures and user-defined functions for details.