how to fetch multiple records without using cursor
Answer Posted / chakradhar patra
Yes its possible in NATURAL using MULTI-FETCH Option.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is meant by dclgen?
Describe major components of db2?
What is the use of with ur in db2?
What is a bind card?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What does sqlcabc has?
Why select is not preferred in embedded sql programs?
Why do we use cursor?
What is db2? Explain.
How would you find out the total number of rows in a db2 table?
What is difference between isnull and coalesce?
What is a collection in db2?
How connect db2 database to datastage?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?