Properties for IBM® data
server stored procedure objects
For more information about specific syntax, see the reference
information that is included with each database product. Syntax definitions
for some database vendors or versions might differ from the following
descriptions.
- 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.