Embedded Usage
In addition to terminating the current transaction, an embedded COMMIT statement:
• Closes all open cursors.
• Discards all statements prepared (with the PREPARE statement) during the current transaction.
When a program issues the DISCONNECT statement, an implicit COMMIT is also issued. Any pending updates are submitted. To roll back pending updates before terminating the program, issue a ROLLBACK statement.