>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
The following should work :
create trigger n_test_one for test_one after insert execute (
if satzid > 0
then
update tst.test_one set
satzid = (select value (max(satzid), 0) + 1 from test_two),
erstdat = timestamp
where satzid = 1
ignore trigger;
)
Best Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
