User-defined function properties

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.

Feedback