CREATE TRIGGER with ERwin (CA)

From: Gianoele <gianoele_at_netscape.net>
Date: 18 Sep 2002 08:00:21 -0700
Message-ID: <69dad29a.0209180700.ff4bdb1@posting.google.com>

Hi,

  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

KMTECALI does not exist.')
 !!

  What can i do to have a semicolumn as terminator?

  Thanks to all.

  Gianoele Received on Wed Sep 18 2002 - 10:00:21 CDT