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 / 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 |
What is the result of open cursor statement?
When Can you be sure that a query will return only one row?
What is a db2 table?
Explain what a plan is?
How do I add a column in db2?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
difference between group clause and order clause
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
if i made sme changes in sub pgm wht r the things to be done for this ?
Comment whether the cursor is closed during commit or not.
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What are leaf pages?