Scripting - Tran function

The Tran function allows you to implement transaction control in batch.

--aqt tran,mode=on	Starts a transaction
--aqt tran,mode=off	Stops a transaction. Prior to doing this it is recommended that you do a commit or a rollback
commit;	Does a commit. Note than this is not an AQT scripting function but a normal SQL statement.
rollback	Does a rollback. Note than this is not an AQT scripting function but a normal SQL statement.

Example:

--aqt tran,mode=on

update Customer_Details set first_name = 'John' WHERE cust_code = '000005';

update Customer_Contact set contact_type= 'F' WHERE cust_code = '000005';

commit;

--aqt tran,mode=off