-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:
| Restricted names | ||
|---|---|---|
| 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