Properties for IBM® data server user-defined function
(UDF) objects
For more information about user-defined function
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 function is written. |
Param
style |
Specifies a PARAMETER STYLE value. |
External name |
Specifies an EXTERNAL NAME value. |
Deterministic |
Specifies
whether the procedure is DETERMINISTIC. If
you do not select this option, the function is set as NOT DETERMINISTIC. |
- Return
type page
Property |
Description |
Data type |
Specifies the data type of the output. |
Precision |
Specifies
a precision value. Available only if the selected
data type requires a precision value. |
Scale |
Specifies a scale
value. Available only if the selected
data type requires a scale value. |
- 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. Available options
are IN,
OUT, or INOUT. |
DB2® for z/OS® only: Locator |
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 function.
- Options page
Property |
Description |
Specific name |
Specifies
a specific name for the SPECIFIC clause of
the function. |
DB2 for z/OS only: Package |
Specify a package ID for the function. |
Contains SQL |
Specifies that the body of the function contains SQL
statements. |
External action |
Specifies the EXTERNAL ACTION option. If you
do not
select this option, the option is specified as NO EXTERNAL ACTION. |
- Documentation
page
- Specifies user-supplied information about the object.
- Annotation
page (in edit mode only)
- Add,
modify, or delete properties.