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.