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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is copy pending and check pending in db2?
What are the prerogatives?
How to find the number of rows in a db2 table?
What is the difference between nvl and coalesce?
What is a db2 table?
can we view the access paths created by dbrm ? how ? thx
Where can you declare a cursor in a cobol-db2 program?
What is reorg?
What db2 400?
What is reorg and runstats in db2?
What is the maximum size of varchar data type in db2?
What is scrollable cursor in db2?
What is a storage group (stogroup)?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?