Interested to Buy Any Domain ? << Click Here >> for more details...
What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 30096 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhisek
As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.
| Is This Answer Correct ? | 43 Yes | 2 No |
Post New Answer View All Answers
Define sqlca.
What is the difference between oracle and db2?
What is the use of commit in db2?
What kind of database is db2?
What is a bind card?
How do you select a row using indexes in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the purpose of rollback and commit?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Discuss about db2 bind?
Define db2.
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
If I have a view which is a join of two or more tables, can this view be updateable?
How do you pull up a query which was previously saved in qmf?
Are views updateable?
