7.36 TSTART

Introduces a new transaction level, incrementing $TLEVEL, provided the optional postcondition evaluates to true or is omitted. Any database operations encountered when $TLEVEL is greater than zero will not be committed to the database until TCOMMIT is encountered.

If a transaction is restartable, variables in the variables-list will be restored to their original values on a restart of the transaction.

Syntax

TSTART[:postcondition] <variables-list>:<transaction-parameters>

<variables-list> can be:

()

Do not save off any local variables. Makes the transaction non-restartable.

*

Save off all local variables. Makes the transaction restartable.

variableName

Saves off only one local variable, variableName. Makes the transaction restartable.

(variableName1,...,variableNameN)

Saves off all local variables listed. Makes the transaction restartable.

<transaction-parameters> can be:

S[ERIAL]

Forces ACID properties on the transaction. When SERIAL is not selected, transactions occur in batch mode, and no attempt is made to guarantee ACID properties.

T[RANSACTIONID]=transaction-id

Sets the ID of the transaction to transaction-id

If you are using more than one transaction parameter, surround all of them in parentheses and separate them with commas, e.g.:

TSTART (FOO,BAR):(SERIAL,TRANSACTIONID="FOO")

This document was generated on November 11, 2022 using texi2html 5.0.