Re: Migrate triggers from Oracle to Informix
The part between the BEGIN and END must be created as a stored procedure.
You would then create the Informix trigger as follows:
CREATE TRIGGER trg1 UPDATE OF tab1a FOR EACH ROW
EXECUTE PROCEDURE newproc(params);
<pablof.herrero@srrpa.es> wrote in message
news:822m1m$ufj$1@nnrp1.deja.com...
> Hi everybody:
> I want to migrate a trigger from Oracle to Informix and I don't find
> the right translation.
> CREATE TRIGGER TRG1> BEFORE INSERT OR UPDATE ON tabla FOR EACH ROW
> BEGIN
> :new.FEC := SUBSTR(:new.FECHA,1,4)||' - '||:new.NUM;
> IF (:new.NSP1 = '' or :new.NSP1 is null) and
> (:new.NIFSP1 = '' or :new.NIFS1 is null)
> THEN
> :new.NSP1 := :new.NREM;
> :new.NIFSP1 := :new.NIFREM;
> END IF;
> END;
> Thanks in advance
>
> --
> Pablo F Herrero Fernandez
> Gijon
> Asturias (Spain)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.