CREATE TRIGGER with ERwin (CA)

  I'd like to create a Database using ERwin (3.5.2) everithing works fine, but when i try to execute the create trigger script a big error is generated.

  ERwin creates multiples triggers with a '!!' separator (double exclamation point),

  Ex:

create trigger MYTRIGGER after UPDATE on MYTABLE

    REFERENCING OLD AS OLD NEW AS NEW for each row mode db2sql    WHEN (((select count(*) from MYTABLE where new.FIELD1 = KMTECALI.FIELD2 and
 new.FIELD3 = KMTECALI.FIELD4) = 0)

     )
       SIGNAL SQLSTATE '42987' ('Cannot UPDATE KMTECFLU because

  Thanks to all.

  Gianoele Received on Wed Sep 18 2002 - 17:00:21 CEST