What is cursor stability?



What is cursor stability?..

Answer / s

The lock is held as long as the cursor is positioned on the
page or row. The lock is released once the cursor moves to
another page or row.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a DB2 catalog?

2 Answers  


1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


i want to delete 20th million record how ?

4 Answers   IBM,


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


Why do we bind in db2?

0 Answers  






What is cursor stability in db2?

0 Answers  


What is a system catalog table in db2?

0 Answers  


What are the levels of isolation available with DB2V4

2 Answers   IBM,


What is a DB2 bind?

3 Answers  


What is null in db2?

0 Answers  


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


What is a DBRM, PLAN ?

3 Answers  


Categories