What happens to cursors when COMMIT happens in database.
The Associate cursor in DB2 is being used in Stored procedure. The purpose is while calling a Stored procedure from an another stored procedure this Associate acts as to hold result set.
Cursor WITH HOLD tricky rules on how it works when you use inDB2, IMS DB, CICS and IMS DC.
Tricky interview questions to read for interviews on DB2 cursors.