Opens a window where you can browse for the item you want to specify.


Specify a schema name, which is used as the second part of the three-part name. Unavailable if you are altering a procedure.

The name can be up to 18 characters long and must not duplicate an existing stored procedure at the current server. Unavailable if you are altering a procedure.

Optional: Type a name that identifies the user-written code that implements the stored procedure. The name must not be longer than 8 characters.

Optional: Type the name of the package collection to use when the stored procedure is executed. The name must not be longer than 18 characters.

Specify whether the stored procedure can contain SQL statements.

Optional: Type the maximum number of query result sets that can be returned by this stored procedure. This field accepts the small integer data type; the default value is zero.

Specify how this stored procedure runs.

Specify how this stored procedure runs.

Specify whether successive calls of the stored procedure with identical input arguments return the same results.

Specify whether stored procedure requires specific information known by DB2.
With the setting selected, an additional argument is passed when the stored procedure is invoked. For information about this argument see the DB2 Application Programming and SQL Guide.

Specify if the load module to remain resident in memory after the stored procedure ends.

Specify if the unit of work is committed immediately upon the successful return from this stored procedure. (A non-negative SQL code signifies a successful return.)

Specify if you want to limit the service units permitted for any single invocation of the stored procedure.

If you select Limit service units type the number of service units.
The field accepts non-negative integers; the default value is zero. Zero indicates that there is no limit on the service units.

Optional: Type a comment for this procedure.


Select a method for accessing an external security environment. If the stored procedure does not require a special external security environment, select DB2.

Do not select No WLM environment if:



Do not select No WLM environment if:

Do not select No WLM environment if:
If you specify a WLM environment, specify a Name for the environment. The Name is a long identifier and must not contain an underscore.
If you name a WLM environment, specify whether nested procedures run in:
If you name a WLM environment, specify whether nested procedures run in:

Select the programming language used to create the stored procedure.


Optional: If you don't want to use the default language environment run-time options, type options in the Run-time options field. You can type up to 256 characters.


Specify a method for handling parameters:


Opens the Add Parameter window.

Opens the Change Parameter window. Available only if an item in the Parameters list is selected.

Removes the selected parameter from Parameters list.

Changes the selected parameter's position in the parameters list. Available only if there is a parameter above the selected parameter.

Changes the selected parameter's position in the parameters list. Available only if there is a parameter below the selected parameter.
Displays a list of currently defined parameters.

Submits the data in the window and closes the window. Available when the required fields are complete.

Displays the SQL statements that would be generated by your choices in this window. Available when the required fields are complete.

Closes this window.