What are the levels of isolation available with DB2V4
Answers were Sorted based on User's Feedback
Answer / nag(igate)
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
NC no commit-similar to UR
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
Is This Answer Correct ? | 0 Yes | 1 No |
What are host variables in db2?
When Can you be sure that a query will return only one row?
difference between group clause and order clause
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What does an outer join do?
What are foreign keys in db2?
What is the difference between using bind () and rebind () methods of naming class?
Why use RUNSTAT Utility?
How do I add a column in db2?
What is the function of buffer manager?
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 the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?