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


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 -873
   
 
  • Causa
    • DATA ENCODED WITH DIFFERENT CCSIDS CANNOT BE REFERENCED IN THE SAME SQL STATEMENT.

      You cannot refer to a column defined in a table in one encoding scheme in the same SQL statement as a column defined in a table of another encoding scheme.

      This situation can occur when a table created in either the ASCII, EBCDIC, or UNICODE encoding schemes is referenced in a statement with a table that is not in the same encoding scheme.

      This situation can also occur when a table is created; a DECP CCSID value is changed; another table is created, and then the two tables are referenced in a single SQL statement.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the SQL statement.

      SQLSTATE: 53090
© Copyright IBM Corp.