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


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 -783

   
 
  • Causa
    • SELECT LIST FOR CURSOR cursor-name IN FOR STATEMENT IS NOT VALID.
      COLUMN column-name IS NOT UNIQUE.

      The SELECT list in the FOR statement must contain unique column names.
      The SELECT list specified either contains duplicate column names or unnamed expressions.
      • If two column names are the same, the column name is column-name.
      • If the problem is the result of unnamed expressions then *N is returned for column-name.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Specify unique column names in the SELECT list specified in the FOR statement.

      SQLSTATE: 42738
© Copyright IBM Corp.