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


Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

620


What is cursor stability in db2?

796


What is db2 bind?

628


My sql statement select avg(salary) from emp yields inaccurate results. Why?

634


Is it possible using max on a char column?

593






What is coalesce in db2?

674


What are the full forms of spufi and dclgen and why are they used?

646


How would you find out the total number of rows in a db2 table?

567


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2262


What is collection in db2 bind?

565


How can you do the explain of a dynamic sql statement?

627


How connect db2 database to datastage?

751


What is cobol db2?

556


What happens in bind step in a db2 program?

557


What is difference between alias and synonym in db2?

633