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 |
What is concurrency in db2?
What type of database is db2?
Which isolation level provides maximum concurrency?
Which component is used to execute the sql statements?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
if i made sme changes in sub pgm wht r the things to be done for this ?
What does a deadlock mean in DB2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Why cursor is used in db2?
What does DSNDB07 database do?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?