User-defined function properties (DB2)

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.

Feedback