Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE TRIGGER statementUse the CREATE TRIGGER statement to define a trigger on a table. You can also use CREATE TRIGGER to define an INSTEAD OF trigger on a view.
Using Correlation Names in Triggered Actions

Using Correlation Names in Triggered Actions

These rules apply when you use correlation names in triggered actions:

You can use the correlation names as qualifiers for the old and new column values in SQL statements of the FOR EACH ROW triggered-action list and in the WHEN condition.
The WHEN conditions and FOR EACH ROW clauses of multiple triggers on the same table can use different correlated variables in the REFERENCING clauses of triggers and of trigger routines to reference values in the same column.
The old and new correlation names refer to all rows affected by the triggering statement.
You cannot use the correlation name to qualify a column name in the GROUP BY, the SET, or the COUNT DISTINCT clause.
The scope of reference of the correlation names is the entire trigger definition. This scope is statically determined, meaning that it is limited to the trigger definition; it does not encompass cascading triggers or columns that are qualified by a table name in a UDR that is a triggered action, except for trigger routines that are invoked in the FOR EACH ROW clause.

For additional information on using correlation names in trigger routines, see Rules for SPL Routines.