START

Starts a transaction build-up.

 

Usage

Embedded, Interactive, Module, Procedural.

Description

A new transaction is started, regardless of whether the transaction start mode is set to IMPLICIT or EXPLICIT, see the SET TRANSACTION statement.

The START BACKUP command starts a transaction in which the CREATE ONLINE BACKUP statements of an online backup sequence are executed, see the description of CREATE BACKUP for more information.

Restrictions

The START statement may not be executed from within a transaction.

The START statement may not be used in a result set procedure.

The START BACKUP command is not supported in procedural mode.

Example

exec sql SET TRANSACTION START EXPLICIT;

 

LOOP

  exec sql FETCH C1 INTO :var1,:var2,...,:varn;

  DISPLAY var1,var2,...,varn;

  PROMPT "Update row?";

  EXIT WHEN ANSWER = "yes";

END LOOP

 

exec sql START;

exec sql UPDATE table SET ...

         WHERE col1 = :var1,

               col2 = :var2, ...

exec sql COMMIT;

 

For more information, see the Mimer SQL Programmer's Manual, Transaction Handling and Database Security.

Standard Compliance