wht happens if we close cursor with cursor with hold option?
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
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the difference between db2 and oracle?
What is the reason behind not using select * in embedded sql programs?
Explain about rct in db2?
Define declaration generator (dclgen).
How connect db2 database to datastage?
How can you count the number of rows from a table tab?
Explain about mirror activator disk mirroring?
Give a brief description of db2 isolation levels?
Which command is used to remove all rows from a table?
What is query_cache_limit?
Explain the function done by data manager?
Why db2 is called db2?
What do you mean by storage group (stogroup)?