Properties for IBM® data
server user-defined function (UDF) 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 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.