SQL - SQLCODE's - Códigos negativos -473


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -473

   
 
  • Causa
    • A USER DEFINED DATA TYPE CANNOT BE CALLED THE SAME NAME AS A SYSTEM PREDEFINED TYPE (BUILT-IN 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 DEC DECIMAL DOUBLE
      FLOAT GRAPHIC INT INTEGER NUMERIC REAL ROWID
      SMALLINT TIME TIMESTAMP VARCHAR VARGRAPHIC
  • Ação do sistema
    • The statement could not be processed.
  • Resposta ao Desenvolvedor
    • Correct the statement to use another identifier for the name of the new user-defined type.

      SQLSTATE: 42918

© Copyright IBM Corp.