In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ?
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 is the information associated with sysibm.syslinks table?
What is correlated subquery?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is declare cursor?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
what needs to be done if a table is in copy pending / check pending status?
How do we specify index to include or not during bind process.
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Where are plans stored?
what's the best lock size that you could use when you create a tablespace?
What is normalization and what are the five normal forms?
Define db2.