What are the Isolation levels possible ?
Answers were Sorted based on User's Feedback
Answer / rafee s
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
NC -- No Commit (smiler to UR)
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / narayana reddy
CS-cursor stability
RR-repeatable read
UR-uncommited read
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishnan
CS-cursor stability
RR-repeatable read
UR-uncommited read
CR-Cursor Readabiliy
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / viratarya
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen87ginjupalli
CS-CURSOR STABILITY
RR-REPEATABLE READ
| Is This Answer Correct ? | 0 Yes | 4 No |
How do you filter out the rows retrieved from a Db2 table ?
Where are plans stored?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is a DB2 catalog?
What is query for your birthday date should be in hours,minute and seconds format?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is the picture clause of null indicator variable?
How to get Top 10 Salaries from a Table
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Which components manage deadlocks in db2?
What is null indicator in cobol db2?