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


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

   
 
  • Causa
    • THE OBJECT HAS BEEN DELETED.

      The application program has either:
      • Dropped an index and then tried to access its object table using that index. Dropped a table and then attempted to accesss it.
      • Dropped or altered an index and then accessed the table on which the index was defined.
      • Executed the EXCHANGE statement on a table more than once without executing a COMMIT statement between consecutive EXCHANGE statements.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • The logic of the application program must be corrected such that it does not attempt to access or use an object after it has been dropped.

      Dropping indexes within an application program is especially hazardous, because there is no way of determining whether or not the plan that has been generated for the application (by BIND or REBIND) actually uses a particular index for access to its object table.
      If the indicated authorization id should be allowed to bind, change the entry in the active RLST table.
      If AUTO-REBIND operations are disabled, rebind the package before reexecuting the package.

      SQLSTATE: 57007
© Copyright IBM Corp.