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 |
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
How would one remove old reorg information from the DB2 catalog?
What Utility is used to migrate DB2 from one release to the next?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How to define the data items to receive the fetch items for the SQL?
What is lock escalation in db2?
What is ALTER ?
what needs to be done if a table is in copy pending / check pending status?
can i code union in cobol-db2 pgm ?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?