Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


START


Starts a transaction build-up.



Usage

Embedded/Interactive/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-2011
Features outside core
Feature T241, "START TRANSACTION statement".

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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX