how to fetch multiple records without using cursor
Answer Posted / krishna reddy
we must know max no of records we want to fetch.
suppose max no record 50...
01 host-variable.
02 employee occurs 50 times.
05 eno pic 9(4).
05 ename pic A(20).
05 esal pic 9(5).
Declare cursor c1 for select eno,ename,esal from emp;
open c1.
fetch c1 into :host-variable.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do I import a csv file into db2?
What is meant by explain?
Define db2 and its databases?
What is buffer pool and list some of them?
Are views updateable?
Name the lockable units in DB2?
What is runstats and reorg in db2?
What is dclgen in db2?
What are the contents of dclgen?
What is null in db2?
What is a Foreign Key?
How is the value function used?
Which component is responsible for processing sql statements and selecting access paths?
What is check constraint in db2?
Explain packages.