how to fetch multiple records without using cursor
Answer Posted / ram g
if u r talking about host language app pgm its not
posssible dats d reason we are hving cursor logic...
in select stmt its quite possible by having condtn in whr
clause such a way it can fetch multiple record..
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What are concurrency issues?
What is cursor stability in db2?
What is db2 bind?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Is it possible using max on a char column?
What is coalesce in db2?
What are the full forms of spufi and dclgen and why are they used?
How would you find out the total number of rows in a db2 table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is collection in db2 bind?
How can you do the explain of a dynamic sql statement?
How connect db2 database to datastage?
What is cobol db2?
What happens in bind step in a db2 program?
What is difference between alias and synonym in db2?