Restrictions On The Replacement Of Methods That Implement Ordering Or Transform Operations On UDTs
The following restrictions apply to replacing methods that implement ordering or transform operations on UDTs.
This means that the definitions for both the referenced UDT and the method to be replaced, as defined by the CREATE TYPE and CREATE METHOD statements, must already exist.
If the function is currently set to EXECUTE NOT PROTECTED mode, then you must perform an ALTER METHOD request (see “ALTER METHOD” on page 20) to change the mode to EXECUTE PROTECTED before you can perform the REPLACE METHOD request.
Unless all of these conditions have been met when you submit the REPLACE METHOD request, Teradata Database aborts it and returns an error to the requestor.