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


Stored procedure properties

Stored procedure properties are shown in the Properties view. You can use the Properties view to modify the properties of a stored procedure.

If the stored procedure already exists in a metadata catalog on a data server and you want the changes that you make to the stored procedure to be reflected in the metadata catalog, you must follow these steps:

  1. Drop the stored procedure from the metadata catalog. You can generate the DDL to drop the stored procedure by right-clicking the stored procedure and selecting Generate DDL. In the Generate DDL wizard, select the DROP statements check box.
  2. Run the generated DDL on the data server.
  3. Make your changes to the stored procedure.
  4. Generate the DDL to create the stored procedure. You can generate this DDL by opening the Generate DDL wizard and selecting the CREATE statements check box.
  5. Run the DDL on the data server.

The Properties view for a stored procedure contains the following information:

General page
Property Description
Name Type the name of 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 a 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 procedure name is an SQL identifier (the schema name) followed by a period and an SQL identifier. The schema name can be 'SYSIBM' or 'SYSPROC'. It can also be 'SYSTOOLS' if you have SYSADM or SYSCTRL privileges. 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.
Label Type a label. This label is displayed in visual diagrams, if you use visual diagrams.
Result set Specifies 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.
Language Specify the language interface convention to which the procedure body is written:
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.
Parameter style Specify the convention to use for passing parameters to and returning the value from procedures.
External name Type the name of the load module that exists on the data server for loading the stored procedure.
Deterministic Specifies whether the stored procedure is deterministic or nondeterministic.
Parameters page
Shows the parameters for the stored procedure. You can add or remove parameters.
Source page
This page is not supported by Classic Data Architect.
Privileges page
Shows the privileges for the stored procedure. You can grant or revoke the EXECUTE privilege on the stored procedure.
Documentation
Lets you add comments to a stored procedure.
Related tasks
Adding or replacing columns in tables based on data definition files
Modifying the selection of records in tables for CA-IDMS databases
Creating stored procedures
Related reference
Column properties
Database properties
Index properties
Table properties
View properties


Feedback

Update icon Last updated: 2007-10-09