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


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

   
 
  • Causa
    • A POSITIONED DELETE OR UPDATE STATEMENT FOR CURSOR cursor-name SPECIFIED A ROW OF A ROWSET, BUT THE CURSOR IS NOT POSITIONED ON A ROWSET

      The FOR ROW n OF ROWSET clause was specified on a positioned DELETE or UPDATE statement, but the cursor is not currently positioned on a rowset.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Issue a FETCH statement to position the cursor on the correct rowset, and then reissue the positioned DELETE or UPDATE statement.
      If the cursor is not defined for rowset access, redefine the cursor first.

      SQLSTATE: 24520

© Copyright IBM Corp.