Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
Answers were Sorted based on User's Feedback
No. In cobol-db2 program, the result of single select should be only one row.
For multi row fetch we must use cursor, else program will abend with -811 sql code.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / satheesh reddi
no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table
Is This Answer Correct ? | 0 Yes | 0 No |
How does the processing of a correlated subquery differ from a non correlated subquery?
What is declare cursor?
how can i pull up a query which was previously stored in qmf
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What does DSNDB07 database do?
what are the SQL codes u freequently got?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is bind plan?
How to create backup table in db2?
i want to delete 20th million record how ?
What are the isolation levels possible ?
My SQL is not performing well. Describe how will you fine tune it?