SQL_COMMIT_STMT¶
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.
Syntax
SQL_COMMIT_STMT
Example
SQL_START_TRANSACTION_STMT
SQL_SET_STMT to "UPDATE CUSTOMER SET STATUS = 'Inactive'"
SQL_PREPARE_STMT
SQL_EXECUTE_STMT
SQL_COMMIT_STMT