Previous Topic

Next Topic

Book Contents

Book Index

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
Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.