The following rules apply to the use of BEGIN TRANSACTION in embedded SQL:
- BEGIN TRANSACTION is valid only when you specify the TRANSACT(BTET) or -tr(BTET) options to the preprocessor. Otherwise, an error is returned and the precompilation fails.
- BEGIN TRANSACTION cannot be performed as a dynamic SQL statement.