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 |
Name the various locking levels available?
What is a clustering index ?
How is the value function used?
can all users have the privilage to use the sql statement select * (dml)?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is Call attach facility? How does it work?
List out the buffer pools in db2
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
what is static sql? what is dynamic sql? Give me details
What is the advantage in De-normalizing tables in DB2?
What is a page?
how to unload different table data into different gdg files/ vsam files.