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
How to create db2 table in mainframe?
Explain about dbrm.
Before you give the explain statement, what are the prerogatives?
What is consistency token in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is the latest version of ibm db2?
can all users have the privilage to use the sql statement select * (dml)?
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 ?
Explain how can you do the explain of a dynamic sql statement?
What is check constraint in db2?
Why do we need reorg in db2?
What is the use of db2 optimizer?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How do I import data from excel to db2?
What are the prerogatives?