Opens a window so that 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. The default depends on the value of special register CURRENT RULES. Main is the default when CURRENT RULES is DB2.

Specify how this stored procedure runs. The default depends on the value of special register CURRENT RULES. Subroutine is the default when CURRENT RULES is STD.

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

Attention: There are some utilities functions that you cannot perform if you do not use a WLM environment.

Do not select No WLM environment if:

The default WLM environment is an environment that is already established by your DBA when DB2 for OS/390 was installed. The install panel DSNTIPX, uses DSN1WLM as the default.

Specify to use a particular WLM environment that is different from the WLM environment established when DB2 for OS/390 was installed. You must have already defined this environment using the OS/390 ISPF panels.

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 you want nested procedures to run in a different address space.

If you name a WLM environment, specify whether you want nested procedures to run in the same address space.

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.