Interested to Buy Any Domain ? << Click Here >> for more details...
What do you do to keep the cursor from closing after a
commit?
- 1 Answers
- 6841 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
You add the keyword "WITHHOLD" to the declare statement of
the cursor
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How does a cursor work?
What is db2 bind process?
What is db2 optimizer?
What is database reorganization?
How do I copy a table in db2?
What are db2 tables?
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?
What are the various isolation levels possible?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Why do we need reorg in db2?
is it compulsory commitment control in journal?
How can you do the explain of a dynamic sql statement?
What is bind plan?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
