8. SQL Statements : COMMIT : Embedded Usage
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.