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
- 6075 Views
- UST, I also Faced
- E-Mail Answers
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 |
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is read-only cursor?
what is a trigger and types of triggers
How do you define a correlated name?
What is the reason behind not using select * in embedded sql programs?
What is meant by dclgen?
What is dpf in db2?
What is IMAGECOPY ?
how to fetch multiple records without using cursor
What is view db2?
Before you give the explain statement, what are the prerogatives?
What happens to the PLAN if index used by it is dropped?
COBOL 
