Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
No Answer is Posted For this Question
Be the First to Post Answer
what is the input to PLAN? what is the input to DBRM?
What are the two types of logging in the db2 database? Explain them.
What is the purpose of rollback and commit?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Explain about open switch business continuity software?
What is copy pending and check pending in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
max number of columns in a db2 table?
The only place of VSAM KSDS in DB2 is?
Why do we use cursor?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?