-473 A USER DEFINED DATA TYPE CANNOT BE CALLED THE SAME NAME AS A SYSTEM PREDEFINED TYPE (BUILT-IN TYPE)
Explanation
The name of a data
type to be created has an unqualified name that is the same as a system-predefined
data type. The name that you specified is not allowed. Adding delimiters
does not make the name valid. The following names are restricted:
BIGINT | DECIMAL | REF |
BINARY | DECFLOAT | ROWID |
BLOB | DOUBLE | SMALLINT |
BOOLEAN | DOUBLE PRECISION | TIME |
CHAR | FLOAT | TIMESTAMP |
CHAR VARYING | GRAPHIC | VARBINARY |
CHARACTER | INT | VARCHAR |
CHARACTER VARYING | INTEGER | VARGRAPHIC |
CLOB | LONG VARCHAR | XML |
DATALINK | LONG VARGRAPHIC | |
DATE | NUMERIC | |
DBCLOB | REAL | |
DEC | ROWID |
System action
The statement cannot be processed.
Programmer response
Correct the statement to use another identifier for the name of the new user-defined type.
SQLSTATE
42918