wht happens if we close cursor with cursor with hold option?
- 3 Answers
- 11398 Views
- Valtech, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
A held cursor can be closed when
1.CLOSE cursor is issued.
2.ROLLBACK is issued.
3.Application terminates.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the 2 sqlcodes that are returned?
What is meant by dclgen?
What is db2 purescale?
What is a system catalog table in db2?
What are db2 tables?
Can we delete records from view?
Highlight all the advantages that are attached to a package.
What is the difference between cursor stability and repeatable read isolation levels?
Which is faster delete or truncate?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How does a cursor work?
How do you stop a db2 database in linux?
What is the difference between plan and package in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What does db2 plan contain?
