Stored procedure properties

Properties for IBM® data server stored procedure objects

For more information about stored procedure syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Result set Specifies a DYNAMIC RESULT SETS value.
Language Specifies the language interface convention to which the procedure body is written.
Param style Specifies a PARAMETER STYLE value.
External name Specifies an EXTERNAL NAME value.
Deterministic Specifies that the procedure is DETERMINISTIC. If this option is not selected, the procedure is set as NOT DETERMINISTIC.
Parameters page
In edit mode, use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for parameters.
  • Click the New toolbar button to add a new parameter to the bottom of the grid.
  • Click the Delete toolbar button to delete a parameter.
  • Select a parameter in the grid and click Move Up or Move Down to change the order of parameters.
  • Use the grid to modify the properties of a parameter. Double-click a cell or click a check box in a cell to edit the cell contents.
    Property Description
    Name Type a name.
    Data type Specifies a valid data type.
    Mode Specifies a parameter mode. You can select IN, OUT, or INOUT.
    DB2® for z/OS® only: Locator If set to true, specifies the AS LOCATOR option. This option can be specified only for a LOB data type or a distinct type based on a LOB data type.
Source page
Shows the source code for the procedure.
Options page
Property Description
Specific name Specifies a specific name for the SPECIFIC clause of the procedure.
Package For SQL and SQLJ stored procedures only: Specifies a package ID for the procedure.
Access Specifies an option for the level of data access for SQL statements included in the procedure. You can select NO_SQL, CONTAINS_SQL, READS_SQL_DATA, or MODIFIES_SQL_DATA.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.
Related information
CREATE PROCEDURE statement syntax, Version 9.1 for z/OS
CREATE PROCEDURE statement syntax, DB2 Version 9.1 for Linux, UNIX, and Windows
CREATE PROCEDURE statement syntax, IBM Informix Dynamic Server v10.0

Feedback