Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
Just as the SQL_EXECUTE_STMT is used to execute the SQL statement in the block, this command is used to commit the transaction started by SQL_START_TRANSACTION_STMT. When this command is called, any preceding statements or procedures that are apart of the transaction will be committed. If one or more of these statements fail, then none of them will be successful, thus maintaining atomicity.
SQL_START_TRANSACTION_STMT SQL_SET_STMT to "UPDATE CUSTOMER SET STATUS = 'Inactive'" SQL_PREPARE_STMT SQL_EXECUTE_STMT SQL_COMMIT_STMT