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


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 -173
   
 
  • Causa
    • UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY

      The cursor is not a read-only cursor.
      WITH UR can be specified only if DB2 can determine that the cursor is read-only.
  • Ação do sistema
    • Statement execution fails.
  • Resposta ao Desenvolvedor
    • If the cursor is intended to be read-only but is ambiguous, add the FOR FETCH ONLY clause.
      If the cursor is updateable, change the isolation level specified on the WITH clause.

      SQLSTATE: 42801

© Copyright IBM Corp.