Routine modifiers
The routine modifiers that you specify in the WITH clause of the CREATE FUNCTION or CREATE PROCEDURE statement tell the database server about attributes of the UDR.
The database server supports the following routine modifiers
for UDRs.
| Routine modifier | Type of UDR |
|---|---|
| CLASS | Accesses to the JVP |
| HANDLESNULLS | Handles SQL null values as arguments |
| ITERATORS | Iterator function |
| NEGATOR | Negator function |
| NOT VARIANT | Might return cached results |
| PARALLELIZABLE | Parallelizable UDR |
| VARIANT | Returns different results when invoked with the same arguments |
The following routine modifiers are C-language specific
and do not apply to UDRs in Java™ code:
- COSTFUNC
- INTERNAL
- SELFUNC
- STACK
- PERCALL_COST
- SELCOST