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



In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/..

Answer / lvr_rams

yes it can possible. Multibull cursor we can used.

Is This Answer Correct ?    0 Yes 0 No

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/..

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

Post New Answer

More DB2 Interview Questions

What is the information associated with sysibm.syslinks table?

0 Answers  


What is correlated subquery?

1 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


What is declare cursor?

0 Answers  


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


How do we specify index to include or not during bind process.

0 Answers   Satyam,


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?

1 Answers  


Where are plans stored?

2 Answers  


what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,


What is normalization and what are the five normal forms?

1 Answers  


Define db2.

0 Answers  


Categories