In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ?
- 2 Answers
- 7441 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lvr_rams
yes it can possible. Multibull cursor we can used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / truclu
yu can create multiple cursor but with hold...because if
you don't want to lose your row...
| Is This Answer Correct ? | 0 Yes | 1 No |
What are concurrency issues?
What is a synonym ?
What is the difference between TYPE 1 index & TYPE 2 index
What is copy book?
What does the sqlcode of -818 pertain to?
Explain in detail about buffer manager and its functionalities?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is the role of data manager in the db2 database?
Which one allows duplicate values Union or Union All ?
What is a view? Why use it?
What is the default page size of buffer pools?
COBOL 
