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
What does db2 mean?
What are the 2 sqlcodes that are returned?
What are iseries servers?
What is the default page size of buffer pools?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the max length of sqlca?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Who uses db2?
What are the contents of dclgen?
What is lock escalation in db2?
What is the difference between using bind () and rebind () methods of naming class?
Why do we use cursor?
What is with ur in db2?
What is load replace in db2?