Modifiers in a Java UDR
The following table shows the routine modifiers that are
valid for Java™ routines.
Routine modifier | Type of UDR |
---|---|
CLASS | Access to JVP |
HANDLESNULLS | UDR that supports SQL null values as arguments |
ITERATOR | Cursor function that returns a data set by successive calls |
NEGATOR | Function that takes the same arguments in the same order as another function (called its companion function), but that returns the Boolean complement |
NOT VARIANT | All invocations of the UDR with the same arguments return the same value |
PARALLELIZABLE | Function that can be executed within a parallel database query statement |
VARIANT | All invocations of the UDR with the same arguments do not necessarily return the same value |