What are the various locking levels available?
Answers were Sorted based on User's Feedback
Answer / ram
Cursor Stability, Read Stability, Uncommited Read and Repeatable Read
Is This Answer Correct ? | 0 Yes | 2 No |
What is bind plan?
What is nvl in db2?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
how can u nderstand the sql stmts executed successfully or not ?
define clustering index.
On which levels locks can be applied?
What is the cascade rule and how does it relate to deletions made with a subselect?
What are common abends
How could one combine a set of incremental image copies into a single copy?
Explain about dbrm.
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Suppose if I need to update a column, how you do that using cursor?