-212   name IS SPECIFIED MORE THAN ONCE IN THE REFERENCING CLAUSE OF A TRIGGER DEFINITION

Explanation

The REFERENCING clause of a CREATE TRIGGER statement specified the same name for more than one of the OLD or NEW correlation names or the OLD_TABLE or NEW_TABLE identifiers. name is the name that was specified multiple times.

System action

The statement cannot be processed. The trigger was not created.

Programmer response

Change the statement to specify unique names for all transition variables and tables in the REFERENCING clause and resubmit the CREATE TRIGGER request.

SQLSTATE

42712