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


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

   
 
  • Causa
    • Execução mal sucedida causada por um erro de sistema que não impede a execução com sucesso dos comandos SQL seguintes.

      A system error occurred that prevented successful execution of the current SQL statement.
      However, the error does not prevent successful execution of further SQL statements.

      The error might occur if the length of the SQL statement is less than 0, or is greater than the DB2 maximum length for a statement.

      This SQLCODE might also occur when distributed commit processing encounters an error.
      In this case, all servers in the unit of work that support distributed two-phase commit backed out the unit of work.
      If a server that does not support distributed two-phase commit has updates in the unit of work, that server must be queried to determine if its updates were committed or backed out.

      Finally, this error might occur during commit if post-processing cannot be completed because of an update that changes the partition of a row.
      Resource unavailable problems can prevent the post-processing from completing.
      The existence of held cursors can prevent the post-processing from completing.
      Commit is failed. The transaction is aborted.
  • Ação do sistema
    • The statement cannot be executed.
      A X'04E' abend might be requested for the application.
      The application program can have a recovery routine to recover from such an abend and can retry SQL statements.
  • Resposta ao Desenvolvedor
    • If an abend occurred, notify the system programmer for analysis of the abend that caused this return code.
      Even if an abend occurred, an application program receiving this return code can retry and is not prohibited from executing further SQL statements.

      SQLSTATE: 58004
© Copyright IBM Corp.