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-2003	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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se