Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
- 1 Answers
- 6181 Views
- UST, I also Faced
- E-Mail Answers
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 view db2?
List out the data types available.
How would the varchar column remarks defined?
What is temporal table in db2?
what is a corelated subquerry?
What is lock escalation in db2?
What is the physical storage length of date data type?
What is the role of data manager in the db2 database?
What is db2? Explain.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the picture clause of null indicator variable?
What is db2 connect?
What are types of indexes?
Why select is not preferred in embedded sql programs?
When reorg is used?
