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



How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)..

Answer / a.roselin

CURSOR WITH HOLD Option

Is This Answer Correct ?    4 Yes 0 No

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)..

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

Post New Answer

More DB2 Interview Questions

What is load replace in db2?

0 Answers  


Can one database have multiple instances?

0 Answers  


how to resolve -811 error. give clear explination

4 Answers   IBM,


what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  


What is the function of the Data Manager?

2 Answers  






If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  


how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,


What is a precompiler?

2 Answers  


What is the picture clause of the null indicator variable?

6 Answers  


What type of database is db2?

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


How many sub queries can you combine together ?

4 Answers   IBM,


Categories