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 |