Hi all, can anybody help me. Have some DB2 Trigger and want to use it in SAPDB but can�t find any important documentation about writing triggers in SAPDB.
DB2 Triggers: create trigger n_test_one no cascade before insert on test_one referencing new as new for each row mode db2sql set (satzid) = (select coalesce(max(satzid), 0) + 1 from test_two), status = '1', erstdat = current timestamp, aktdat = current timestamp create trigger n_test_one no cascade before insert on test_one referencing new as new for each row mode db2sql set new.erstdat = old.erstdat, new.aktdat = current timestamp Status, erstdat, aktdat, satzid(primary key)are columns. I�ve tried something like this: create trigger n_test_one for test_one after insert execute ( if satzid > 0 then update tst.test_one set (satzid) = (select coalesce(max(satzid), 0) + 1 from test_two), erstdat = date(now()) where satzid = 1 ignore trigger ;) - doesn�t work any suggestions or help Thank You uli _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
