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


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 -751
   
 
  • Causa
    • object-type object-name (SPECIFIC NAME specific name) ATTEMPTED TO EXECUTE AN SQL STATEMENT statement THAT IS NOT ALLOWED

      A stored procedure or user-defined function attempted to execute an SQL statement that is not allowed.

      Stored procedure
      A stored procedure issued an SQL statement that forced the DB2 thread to roll back the unit of work.
      The SQL statement that caused the thread to be placed in the MUST_ROLLBACK state is one of the following:

      • COMMIT
      • ROLLBACK

      All further SQL statements are rejected until the SQL application that issued the SQL CALL statement rolls back the unit of work.
      When control returns to the SQL application that issued the SQL CALL statement, the SQL application must roll back the unit of work.
      This can be done by issuing an SQL ROLLBACK statement or the equivalent IMS or CICS operation.

      User-defined function
      External function object-name issued one of the following SQL statements:

      • COMMIT
      • ROLLBACK
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Remove the unsupported statement from your stored procedure or user-defined function.

      SQLSTATE: 38003
© Copyright IBM Corp.