Use this wizard to specify the values for parameters that are used
in the DDL that is generated for defining a stored procedure in a metadata
catalog.
Procedure Definition page
Use this page to define
the stored procedure.
- Procedure name
- Type a name for the stored procedure. The
name cannot be a single asterisk even if you specify it as a delimited identifier
("*").
- The name is implicitly or explicitly qualified by a schema. The name,
including the implicit or explicit qualifier, must not identify an existing
stored procedure at the current server.
- The unqualified form of procedure-name is an SQL identifier. The unqualified
name is implicitly qualified with a schema name according to the following
rules:
- If the statement is embedded in a program, the schema name is the authorization
ID in the QUALIFIER bind option when the plan or package was created or last
rebound. If QUALIFIER was not specified, the schema name is the owner of the
plan or package.
- If the statement is dynamically prepared, the schema name is the SQL authorization
ID in the CURRENT SQLID special register.
- The qualified form of the name is an SQL identifier (the schema name)
followed by a period and an SQL identifier. The schema name can be SYSIBM
or SYSPROC. The schema name can also be SYSTOOLS if the CREATE statement user
has SYSADM or SYSCTRL privilege. Otherwise, the schema name must not begin
with SYS unless the schema name is SYSADM.
- The owner of the procedure is determined by how the CREATE PROCEDURE statement
is invoked:
- If the statement is embedded in a program, the owner is the authorization
ID of the owner of the plan or package.
- If the statement is dynamically prepared, the owner is the SQL authorization
ID in the CURRENT SQLID special register.
- The owner is implicitly given the EXECUTE privilege with the GRANT option
for the procedure.
- External name
- Type the name of the load module for loading the
stored procedure.
- Language
- Specify the language interface convention to which
the procedure body is written. There are three choices:
- Assembler
- Indicates that the stored procedure is written in Assembler.
- C
- Indicates that the stored procedure is written in C or C++.
- COBOL
- Indicates that the stored procedure is written in COBOL.
- Result sets
- Specify the maximum number of query result sets
that the stored procedure can return. The default is 0, which indicates that
there are no result sets. The value must be 0 or 1.
- Stay resident
- Specify whether the stored procedure load module
is to remain resident in memory when the stored procedure ends.
- Run options
- Specify the Language Environment® run-time
options to be used for the stored procedure. For a description of the Language
Environment® run-time options, see z/OS® Language Environment Programming
Reference.
- Remarks
- Optional: Provide any comments to describe the
stored procedure.