Routine Editor - User-Defined Function - Return Types page

Use the Return Types page to view the type of output of the user-defined function.
Name
Shows the table column names if the output is a table.
SQL type
Shows the SQL data type of the user-defined function output or the SQL data type of the table columns if the output is a table.
Length
Shows the length for the SQL type. Available only for SQL types BLOB, CHAR, CLOB, DBCLOB, GRAPHIC, VARCHAR, and LONG VARCHAR.
Unit
Shows the unit of size (Byte, KByte, MByte, GByte) for the SQL type. Available only for the following SQL types BLOB, CLOB, DBCLOB.
Precision
Shows a number between 1 and 31 for the total number of digits that the value can contain. Available only for SQL types DECIMAL, FLOAT, and NUMERIC.
Scale
Shows the number of digits to the right of the decimal point. Only available for SQL types DECIMAL, FLOAT, and NUMERIC. The scale can not be negative or greater than the precision. The maximum precision is 31 digits.
For bit data
Shows the bit data subtype for all character strings. Available for the SQL types CHAR and VARCHAR.

Feedback