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 is db2 bind?

636


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624


How and when does the db2 enforces the unique key?

613


What is a db2 collection?

605


Can one database have multiple instances?

581






What is the difference between db2 and oracle?

677


What is the physical storage length of time data type?

673


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

749


what is the sqlcode -501

11299


Define declaration generator (dclgen).

665


What is db2?

741


What's The Percentage Free Space ?

768


What is difference between alias and synonym in db2?

643


What is the syntax for seeing the columns and data types of a table in the db2 database?

577


Which component is responsible for processing sql statements and selecting access paths?

667