ODBC Transaction row lock
Posted on 2006-05-09
I have an IBM DB2 database, which is accesseded through ODBC. Because I am building a distributed system it is essential to use transactions in some cases. The problem is that if I do odbcConnection.BeginTransaction(), it locks the whole table when i issue a query which is very specific (for example: I query for row which has unique field ID).
Is there a way to lock just the affected rows and not the whole table with ODBC.
(I noticed something on that matter with OdbcCommand.transaction.IsolationLevel, but the property is read only)