Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
Answer Posted / hitendra valluri
As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of db2?
What is page size in db2?
What is db2?
Who uses db2?
What is reorg and runstats in db2?
What are host variables in db2?
How can deadlocks be resolved?
Define db2.
What is clone table?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is host variable?
What is the difference between spufi and qmf?
What is sqlca?
What is view db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.