Certain SQL data types cannot be used in a UDF declaration, either as data types for
arguments to a UDF, or as return-value data types.
- BIT – Should typically be handled in the UDF declaration as a TINYINT
data type, and then the implicit data type conversion from BIT
automatically handles the value translation.
- DECIMAL – (<precision>, <scale>) or
NUMERIC(<precision>, <scale>) – depending on the
usage, DECIMAL is typically handled as a
DOUBLE data type, but various conventions may be imposed to
enable the use of INT or BIGINT data
types.
- LONG VARCHAR – (CLOB) – supported only as an input argument, not as a
return-value data type. An exception exists for pass-through TPFs, where
LONG VARCHAR is supported as a return-value data type.
- LONG BINARY – (BLOB) – supported only as an input argument, not as a
return-value data type. An exception exists for pass-through TPFs, where
LONG BINARY is supported as a return-value data type.
- TEXT – not currently supported.