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 does reorg do in db2?

578


What is the use of predicate?

587


What language is db2 written in?

595


Discuss about db2 bind?

673


How and when does the db2 enforces the unique key?

615






Explain what are the various isolation levels possible?

610


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

625


What are the 2 sqlcodes that are returned?

643


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706


Is schema the same as database?

631


Explain about open switch business continuity software?

563


What are iseries servers?

568


What is page size in db2?

563


What is buffer pool?

613


What is bind plan?

613