Use the Properties view to modify the properties of a DB2® user-defined
function.
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. |
- Return type page
-
Property |
Description |
Data type |
Select the data type of the output. |
Precision |
Specify a precision value. Available only if the data
type you selected requires a precision value. |
Scale |
Specify a scale value. Available only if the data type
you selected requires a scale value. |
- 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. |
Contains SQL |
Select to specify that the body of the function contains
SQL statements. |
External action |
Select to specify the EXTERNAL ACTION option. If you
do not select this option, the options is specified as NO EXTERNAL ACTION. |
- Documentation page
- Type information about the object.
- Annotation page
- Add or delete properties and edit their values.