What is transaction isolation?
what do u mean by serializable, read commited, read numcommitted?
What is array size and transaction size
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Tue Mar 01, 2005 5:14 am
read uncommitted:- you can read an uncommitted transaction that might get rolled back later.
serializable:- prevents other users from updating or inserting rows into the data set until the transaction is complete.
read commited:- It does not ensure that the data will not be changed at the end of the transaction. Since it will not read uncommited data.
serializable:- prevents other users from updating or inserting rows into the data set until the transaction is complete.
read commited:- It does not ensure that the data will not be changed at the end of the transaction. Since it will not read uncommited data.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Transaction isolation level is a concept originally introduced as part of the ODBC standard, by Microsoft. The ultimate reference, therefore, is the ODBC 3.0 API Programmer's Reference and SDK, from Microsoft Press.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 2
- Joined: Mon Jun 20, 2005 2:50 am