START

Starts a transaction build-up.

start.png

 

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 COMMIT 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

Standard

Compliance

Comments

SQL-2016

Features outside core

Feature T241, “START TRANSACTION statement”.

 

Mimer SQL extension

The use of the keywords BACKUP and WORK is a Mimer SQL extension.