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 |
How to resolve -917 sql code in DB2?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is null value in db2?
How does DB2 determine what lock-size to use?
How to find primary key of a table in db2?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
Is ibm db2 free?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is meant by dclgen?
What is database manager in db2?