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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create db2 table in mainframe?

847


Explain about dbrm.

776


Before you give the explain statement, what are the prerogatives?

764


What is consistency token in db2?

857


What action db2 takes when a program aborts in the middle of a transaction?

869


What is the latest version of ibm db2?

952


can all users have the privilage to use the sql statement select * (dml)?

839


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2075


Explain how can you do the explain of a dynamic sql statement?

847


What is check constraint in db2?

804


Why do we need reorg in db2?

733


What is the use of db2 optimizer?

812


How do you simulate the explain of an embedded sql statement in spufi/qmf?

827


How do I import data from excel to db2?

812


What are the prerogatives?

800