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


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

   
 
  • Causa
    • THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH A DROP OR ALTER IS PENDING.

      The application program has issued a DROP or ALTER against an object, and then attempted to access that object before the DROP or ALTER is completed.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • In the case of ALTER, the logic of the application program must be modified so that a COMMIT (or the IMS or CICS equivalent) is executed between the ALTER and the failing SQL statement.

      For DROP, the logic of the application program should be modified such that there is no attempt to access an object after the DROP has been executed.

      Note that DROP includes the case when rollback to a savepoint includes rolling back to a CREATE.

      SQLSTATE: 57007
© Copyright IBM Corp.