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.