Using 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