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

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,


What is the use of runstats in db2?

0 Answers  


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  


What keyword does an SQL SELECT statement use for a string search?

2 Answers  






Where can you declare a cursor in a cobol-db2 program?

0 Answers  


What are foreign keys?

1 Answers  


What is db2 command?

0 Answers  


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


What types of tables are there in the db2 database?

0 Answers  


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


Categories