Was this helpful?
Open Cursors and Transaction Processing
OpenSQL treats a multi‑query transaction as a single statement (logically). Cursors cannot remain open across transactions. The commit statement closes all open cursors, even if a close cursor statement was not issued.
If an error occurs while a cursor is open, the Enterprise Access product or DBMS may roll back the entire transaction and close the cursor.
Last modified date: 12/14/2023