Skip to main content
PRERELEASE CONTENT

NewTable (Trigger Keyword)

Specifies the name of the transition table that stores the new values of the row or statement affected by the event for this trigger.

Usage

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

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

Where newtable 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 value for the NewTable keyword is null.

See Also

Purpose of this instance: Draft documentation
DocReleaseID: SupplyChain2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/supply-chain/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/iris/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
Excluded items: PAGE_bi, PAGE_deployment, PAGE_interoperability, PAGE_release
FeedbackOpens in a new tab