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 |
What is clone table?
Where could you look if you had a question about whether a column has been defined as an index?
How to find the maximum value in a column in the db2 database?
Is there any advantage to denormalizing DB2 tables?
How can we read records for specific member in CL? AND rpg?
how we will do null data selection in cobol-db2 program
How is the value function used?
What are the contents of dclgen?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is phantom read in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?