Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

OldTable

Specifies the name of the transition table that stores the old values of the row or statement affected by the event.

Usage

To specify the name of the transition table that stores the old values, use the following syntax:

Trigger name [ Event = sqlevent, OldTable = oldtable, NewTable = newtable ]
{
   //implementation
}

Where oldtable is the name of an SQL table in this namespace.

Details

Each trigger has access to the old and new values of the row or statement affected by the event, by means of transition tables (specified by the OldTable and NewTable keywords).

Default

The default is an empty string.

See Also