logo  
Google
 

DB2 SQL-Error: -473

SQLState: 42918

Short Description: A USER DEFINED DATA TYPE CANNOT BE CALLED THE SAME NAME AS A SYSTEM PREDEFINED TYPE BUILTIN TYPE

The name of a data type to be created has an unqualified name that is the same as a system-predefined data type or is BOOLEAN. This is not allowed. Adding delimiters does not make the name valid. The following names are restricted: BLOB CHAR CHARACTER CLOB DATE DBCLOB DEC DECIMAL DOUBLE FLOAT GRAPHIC INT INTEGER NUMERIC REAL ROWID SMALLINT TIME TIMESTAMP VARCHAR VARGRAPHIC System action: The statement could not be processed. Programmer response: Correct the statement to use another identifier for the name of the new user-defined type.

 <-  BACK TO INDEX