START TRANSACTION

The START TRANSACTION statement starts a new unit of work.

Invocation

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.

Syntax


   .-BEGIN WORK--------.   
>>-+-START TRANSACTION-+---------------------------------------><

Description

When you issue START TRANSACTION, DB2^® Everyplace^® treats subsequent statements as a new unit of work. If this statement is executed within a unit of work, an error is returned (SQLState 25501).

Rules

A START TRANSACTION statement cannot be executed within a unit of work.

Notes

This statement explicitly starts a new unit of work for a database connection that uses auto-commit mode.

Example

Start a new unit of work for a database connection that currently uses auto-commit mode.

START TRANSACTION