Type the name of the procedure. The procedure name can be up to 18
characters long. Do not duplicate an existing stored procedure at the current
server.
Click on the Browse button to view a list of objects.
Unavailable if you are altering a procedure.
Optional: Type a DB2 user name. This setting controls remote access.
When a CALL statement invokes the stored procedure remotely, the system
compares this setting to the calling authorization ID. The authorization
ID can be up to 8 characters long. If you leave this field blank a default
value is used.
Unavailable if you are altering a procedure.
Optional: Type up to 8 characters for the LUNAME. To ease migration
to future releases of DB2, leave this field blank.
Unavailable if you are altering a procedure.
Type the name of the MVS load module for DB2 to use when running a
stored procedure. The name can be up to 8 characters.
Use this setting where input parameters cannot be null.
Use this setting where an indicator array is passed to the stored procedure
(and where null input parameters are allowed).
Optional: Type up to 18 characters for the name of the package collection
to use when the stored procedure is executed. Leaving this field blank
indicates that the package collection is the same as the package collection
of the program that issued the SQL CALL statement.
Optional: Type the number of service units permitted for any single
invocation of the stored procedure. You can type non-negative integers;
the default value is zero. Zero indicates no limit. If you set this
field to a value other than zero and a stored procedure uses more service
units than allowed by the setting, DB2 cancels the stored procedure.
Optional: Type the maximum number of query result sets that can be
returned by this stored procedure. You can type small integers; the default
value is zero. A value of zero indicates that no query results set is returned.
Optional: Type up to 18 characters for the name of the address
space where the stored procedure will run. A blank indicates that the procedure
will run in the stored procedure's address space established by DB2.
Specify how this stored procedure runs.
Specify how this stored procedure runs.
Specify whether you want the load module to remain resident in memory
after the stored procedure ends.
Specify whether you want to require a special RACF environment
to control access to non-SQL resources. Stored procedures that access non-DB2
resource, such as IMS or CICS transactions, MVS/APPC conversations, or
VSAM files, might need to use RACF to manage access to non-SQL resources.
If you want the unit of work to be committed immediately upon the successful
return from this stored procedure, select the Commit on return check
box. (A non-negative SQL code signifies a successful return.)
Select the programming language used to create the stored procedure.
Optional: If you don't want to use default the language environment
run-time options, type options. You can type up to 256 characters.
Opens the Add Parameter window.
Opens the Change Parameter window. Available only if a 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.
Removes the selected parameter.
Displays a list of currently defined parameters.