DB2 FOR LUW / DB2FORLUW / 820 - DB2

In a CLI application several actions can be chained together. 
When one of these actions fail, the ending 
SQLSetStmtAttrW(SQL_ATTR_CHAINING_END) should not return with a 
SQL_SUCCESS (return status=0). 
 
For example, consider the following scenario: 
A SQLExecute() fails with SQL0911 deadlock and the server rolls 
back the the transaction. Since this is never reported back, the 
application continues the current transaction. This way, we can 
end up with a partially written transaction, leading to data 
loss and/or logical data inconsistency. 
 
In addition, the SQLRowCount() will report a wrong value after a 
partially committed transaction.

USERS AFFECTED: 
All 
 
PROBLEM DESCRIPTION: 
See ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
See ERROR DESCRIPTION

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.11.2009
19.04.2010
19.04.2010