commit-transaction

Issues with this documentation page? Report here.

Purpose:

Commits a database transaction.

Syntax:

commit-transaction [ @<database> ]

Description:

Database transaction started with begin-transaction is committed with commit-transaction.

Database

Optional <database> is specified in "@" clause and is the name of the database_config_file.

Examples:

begin-transaction @mydb
run-query @mydb="insert into employee (name, dateOfHire) values ('Terry', now())"
run-query @mydb="insert into payroll (name, salary) values ('Terry', 100000)"
commit-transaction @mydb