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


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 -581
   
 
  • Causa
    • THE DATA TYPES OF THE RESULT-EXPRESSIONS OF A CASE EXPRESSION ARE NOT COMPATIBLE

      There is a CASE expression in the statement that has result-expressions (expressions following THEN and ELSE keywords) that are not compatible.
      The data type of the result-expressions might be incompatible because the CASE condition result data types are not all:

      • character
      • graphic
      • numeric
      • date
      • time
      • timestamp

      If encoded in Unicode, character and graphic data types are compatible, howver.
      Refer to DB2 SQL Reference for more information about Unicode.

  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Correct the result-expressions so that they are compatible.

      SQLSTATE: 42804

© Copyright IBM Corp.