What is a cursor and what is its function?
Answers were Sorted based on User's Feedback
Answer / s
Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between group by and order by?
What kind of database is db2?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is concurrency in db2?
what is a collection?
How does DB2 use multiple table indexes?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
how to check the table is empty or not?
What is index in db2?
Explain about mirror activator disk mirroring?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?