|
How do you leave the cursor open after issuing a COMMIT?
DB2 ( IBM Database 2 ) Interview Questions
(Continued from previous question...)
How do you leave the cursor open after issuing a COMMIT?
Q: How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only )?
AN:
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.
(Continued on next question...)
Other Interview Questions
| 