DBTRANSACTION

9.0, PLBCMP GUI or PLBLinux Only

The DBTRANSACTON instruction initiates and terminates a transaction. The instruction uses the following format:

Where:

label

Optional. A Program Execution Label.

dbfile

Required. A DBFILE variable defining the database associated with the connection.

transtype

Required. A keyword specifying the transaction type.

Flags Affected: none

Note the following:

1. The underlying database must support transactions.

2. {transtype} may be one the following keywords:

 

Keyword	Action
START	Starts a transaction
COMMIT	Commits the transaction to the database
ROLLBACK	Discards the transaction

See Also: Example Code, SQL Instructions