(1)
|--+-| Adding or Modifying a Routine Modifier |------+----------|
   '-| Dropping a Routine Modifier |-----------------'
 
Dropping a Routine Modifier:
 
        (2)    (3)
|--+-+---------------+-----+--VARIANT-+-+-----------------------|
   | |               '-NOT-'          | |
   | '-NEGATOR------------------------' |
   |  (4)                               |
   +--------+-CLASS----------+----------+
   |        +-ITERATOR-------+          |
   |        '-PARALLELIZABLE-'          |
   |  (2)                               |
   '--------+-HANDLESNULLS-+------------'
            +-INTERNAL-----+
            +-PERCALL_COST-+
            +-+-SELFUNC--+-+
            | '-SELCONST-' |
            '-STACK--------'
 

1. See Adding or Modifying a Routine Modifier
2. C only
3. SPL only
4. External routines only

If you drop an existing modifier in an ALTER FUNCTION, ALTER PROCEDURE, or ALTER ROUTINE statement, the database server sets the value of the modifier to the default value, if a default exists.

Some modifiers are available only with user-defined functions. For information on whether a specific routine modifier applies only to user-defined functions (that is, if it does not apply to user-defined procedures), see the description of the modifier in the sections that follow. In these sections, as elsewhere in this manual, external refers to UDRs written in the C or Java languages. Features valid for only one language are so designated in the previous diagrams.

Except for VARIANT and NOT VARIANT modifiers, none of the options in this segment are valid for SPL routines.