Forces a confirmation prompt for a Transaction object allowing a COMMIT or a ROLLBACK.
| No | No confirmation of the LUW is asked and the Commit command is automatically executed. This is the default value. |
| Yes | Forces a confirmation prompt at the LUW level or Transaction. This allows the user to confirm (COMMIT) or not (ROLLBACK) the changes made to the database during the LUW. |
Objects: Transaction
Generators: .NET, Java
It is valid only in Transactions with the Commit on Exit property = Yes and Commitment property = Enabled. Otherwise, the property Confirm Transactions = Yes will be ignored.
Confirmation property
Commit on Exit property
Commitment property
LUW