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:
-
The stored procedure is a Subroutine..
-
The stored procedure uses external security accessed though the user's
or definer's authorization ID.
- If the stored procedure uses a parameter of the LOB data type or a
distinct type based on a LOB data type.
Do not select No WLM environment
if:-
The stored procedure is a Subroutine.
-
The stored procedure uses external security accessed though the user's
or definer's authorization ID.
- If the stored procedure uses a parameter of the LOB data type or a
distinct type based on a LOB data type.
Do not select No WLM environment
if:-
The stored procedure is a Subroutine.
-
The stored procedure uses external security accessed though the user's
or definer's authorization ID.
- If the stored procedure uses a parameter of the LOB data type or a
distinct type based on a LOB data type.
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:
- A different address space
- The same address space
If you name a WLM environment, specify whether nested procedures run in:
- A different address space
- 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:
-
DB2SQL: DB2 passes the parameters on the CALL statement and additional
arguments, including the null indicator.
-
General: DB2 passes the parameter on the CALL statement. The parameters
cannot be null.
-
General with nulls: passes the parameter on the CALL statement. The parameters
cannot be null.
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.