WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Create Stored Procedure wizard

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.

Parameter Specification page

Use this page to add parameters to the stored procedure.

New button
Adds a new parameter.
Edit button
Edits the selected parameter.
Delete button
Deletes the selected parameter.
Up button and Down button
Moves the selected parameter up or down in the list of parameters.


Feedback

Update icon Last updated: 2006-12-15