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 is load replace in db2?
Can one database have multiple instances?
how to resolve -811 error. give clear explination
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is the function of the Data Manager?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is a precompiler?
What is the picture clause of the null indicator variable?
What type of database is db2?
What are common abends
How many sub queries can you combine together ?