Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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, chapter 9, Transaction Handling and Database Security.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
MIMER EXTENSION
Support for the START statement is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX