-457 A USER-DEFINED FUNCTION OR USER-DEFINED TYPE CANNOT BE CALLED name SINCE IT IS RESERVED FOR SYSTEM USE
Explanation
A user-defined function or user-defined type cannot be created or referenced because the name is reserved for use by the system.
- name
- The name of the user-defined function or user-defined type.
A number of names that are used as keywords are reserved for system use. These names cannot be used as user-defined functions or user-defined type names, even if they are delimited identifiers.
Those
names are:
= < > >= <=
< > ¬= ¬> ¬>
ALL AND ANY BETWEEN DISTINCT
EXCEPT EXISTS FALSE FOR FROM
IN IS LIKE MATCH NOT
NULL ONLY OR OVERLAPS SIMILAR
SOME TABLE TRUE TYPE UNIQUE
UNKNOWN
The names of built-in data types cannot be used as the name of a user-defined type (for example, CHAR).
You cannot use an asterisk (*) as a specific name for a user-defined type or procedure name.
System action
The statement cannot be processed.
Programmer response
Select a name for the function or user-defined type that is not reserved for system use.
SQLSTATE
42939