Use the Properties view to modify the properties of a DB2® stored procedure.
For more information about DB2 syntax, see the reference information
that is included with each product. There may be differences between DB2 syntax and
the syntax for other vendors.
- General page
-
Property |
Description |
Name |
Type a name. |
Label |
Type a label. This label is displayed in visual diagrams. |
Result set |
Specify a DYNAMIC RESULT SETS value. |
Language |
Specify the language interface convention to which the
procedure body is written. |
Param style |
Specify a PARAMETER STYLE value. |
External name |
Specify an EXTERNAL NAME value. |
Deterministic |
Select to specify that the procedure is DETERMINISTIC.
If you do not select this option, the procedure is set as NOT DETERMINISTIC. |
- Parameters page
- 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 |
Select or type a valid data type. |
Mode |
Select a parameter mode. You can select IN, OUT, or
INOUT. |
Locator |
For DB2 UDB for z/OS only: Set
to true to specify 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 |
Specify a specific name for the SPECIFIC clause of the
procedure. |
Package |
For DB2 UDB for z/OS only: Specify
a package ID for the procedure. |
Access |
Select 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
- Type information about the object.
- Annotation page
- Add or delete properties and edit their values.