what is cursor stability?
Answers were Sorted based on User's Feedback
Answer / sai prakash
It is a default isolation level. It puts a lock on the data that has been fetched, so that the retrieved data can be updated or deleted.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / siris
CURSOR STABILITY(CS):-
**it is row level locking...
**An Exclusive lick acquired on that row,the row to be
update....
**The lock is released on that row the control moves to the
next updatable row...
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of DELGEN in DB2? Can we Write the program with out using it?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
what is differnece between DROP TABLE & DELETE TABLE .
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
where will u check for sqlcode ?
What is a synonym ?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What DB2 Catalog column tell you when an index needs table reorganized ?
Where do you specify them?
B37 abend during spufi?
What is the function of buffer manager?
What does an outer join do?