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 |
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What are column-name qualifiers used?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is SPUFI?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
max number of columns in a db2 table?
What will the DB2 optimizer do?
what is sql abend code -801,-802?
What is access path in db2?
How do you find the maximum value in a column in db2?
What is buffer pool in the db2 database?
What is usage pointer in cobol?