How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
Answers were Sorted based on User's Feedback
Answer / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
| Is This Answer Correct ? | 4 Yes | 0 No |
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What do you mean by storage group (stogroup)?
Mention the different locking levels that are available in db2.
What is the syntax for FETCH in DB2 ?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What does db2 mean?
Is db2 relational database?
What is the role of the data page in the db2 database?
Which is faster delete or truncate?
What is copy pending and check pending in db2?
wht is d/f between union and joins ?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?