How Do You Leave The Cursor Open After Issuing A Commit? ( For Db2 2.

1.	How Do You Leave The Cursor Open After Issuing A Commit? ( For Db2 2.3 Or Above Only )
Answer» USE WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs. Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.

How Do You Leave The Cursor Open After Issuing A Commit? ( For Db2 2.3 Or Above Only )

Answer»

USE WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.

Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.