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 is db2 bind?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How and when does the db2 enforces the unique key?
What is a db2 collection?
Can one database have multiple instances?
What is the difference between db2 and oracle?
What is the physical storage length of time data type?
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
what is the sqlcode -501
Define declaration generator (dclgen).
What is db2?
What's The Percentage Free Space ?
What is difference between alias and synonym in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Which component is responsible for processing sql statements and selecting access paths?