db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joachim G Stumpf <joachim.stu...@de.ibm.com>
Subject Derby and Triggers
Date Wed, 31 Aug 2005 08:48:42 GMT
Hi,
i have to convert SQL Syntax to DERBY from Interbase.
I use Derby 10 and customer uses 10.1 . So i downloaded Alpha version of 
reference Doku.

Now i have to define a trigger

Original
CREATE TRIGGER "ATV_tr1" FOR "tab1"
ACTIVE BEFORE INSERT POSITION 0
as
declare variable bId integer;
begin
        select id_      from tab2 where bez_ = user into :bId;
        if ( bId IS NULL ) then bId = 0;
        new.xn_b_id_ = bId;
        new.xad_b_id_ = bId;
        new.neu_date_    = 'now';
        new.aend_date_   = 'now';
end
 ;

I found db2 syntax which is similar to Derby.

create trigger atv_basis
  no cascade before
  insert on ADM_TR_VORGABE_BASIS
  referencing new as new
  for each row mode db2sql
  begin atomic
        set new.neu_datum_    = CURRENT_DATE;
        set new.aend_datum_   = CURRENT_DATE;

end;

This isn't working too.
Can somebody help me out?


mfg 
Joachim Stumpf   DB2 Technical presales support
Tel.: (+49) -7034-15-3276     Fax:   (+49)-7034-15-3400
 Internet: stumpfj@de.ibm.com    Mobil: (+49)-172-733 9453

Developersite: http://www.ibm.com/software/data/developer
Forum: 
http://www-106.ibm.com/developerworks/forums/dw_forum.jsp?forum=492&cat=19
Mime
View raw message