Keywords That Introduce Modifications
Use these keywords to introduce the items in the UDR that
you want to modify:
| Keyword | Effect |
|---|---|
| ADD | Add a routine modifier to the UDR |
| DROP | Delete a routine modifier from the UDR |
| MODIFY | Change an attribute of the routine modifier |
| MODIFY EXTERNAL NAME (for external routines only) | Replace the file specification of the executable file. When the IFX_EXTEND_ROLE configuration parameter = ON, this option is valid only for users to whom the DBSA has granted the EXTEND role. With IFX_EXTEND_ROLE = OFF (or not set), the UDR owner or the DBA can use this option. |
| WITH | Introduces all modifications |
If the routine modifier is a BOOLEAN value, MODIFY sets
the value to be T (equivalent to using the keyword
ADD to add the routine modifier).
For example, both of the following statements alter the func1 UDR
so that it can be executed in parallel in the context of a parallelizable
data query statement:
ALTER ROUTINE func1 WITH (MODIFY PARALLELIZABLE);
ALTER ROUTINE func1 WITH (ADD PARALLELIZABLE);