Before developing Java UDFs and Java table UDFs, familiarize yourself with the restrictions specific to the Java external environment for UDFs.
- Aggregate Java functions are not supported.
- Query fragments involving Java UDFs are not eligable for DQP or SMP processing.
- You cannot DROP tables involved in the current query from within the Java external environment.
- You cannot ALTER tables involved in the current query from within the Java external environment.
- UNSIGNED SMALLINT datatype is not supported.
- Numeric functions are limited to a precision of 255 or less.
- Only one result set is permitted for Java table UDFs.