DSNH473I E csectname LINE nnnn COL cc. 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. This is not allowed. Adding delimiters does not make the
name valid. The following names are restricted:
| Restricted names | Restricted names | 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 executed.
User response
Correct the statement to use another identifier for the name of the new user-defined type.
Severity
8 (error)