Answer Posted / guest
Cursors are used for providing multiple rows to process in
host language by fetching one row at a time.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain various types of locks in db2?
Why select is not preferred in embedded sql programs?
What is a Foreign Key?
What is role in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
If I have a view which is a join of two or more tables, can this view be updateable?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
can we view the access paths created by dbrm ? how ? thx
How does coalesce work?
Can there be more than one cursor open for any program?
What is meant by union and union all?
What is dbrm in db2 database?
Define sqlca.
What does db2 plan contain?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well