Hello,
I am porting an application from DB2 where I use some triggers to generate
unique ids (max previous id + 1). I do not want to use an autoid column in
Derby because I already have some data that I need to migrate.
This trigger works in DB2, up to version 8:
CREATE TRIGGER Tests.AutoCategoryID
NO CASCADE BEFORE INSERT ON Tests.Categories
REFERENCING NEW AS n
FOR EACH ROW MODE DB2SQL
SET (n.categoryid) = (SELECT value(MAX(categoryid),0) + 1 FROM
Test.Categories);
However, when I run it in Derby, I get the following error:
ERROR 42X01: Syntax error: Encountered "SET" at line 5, column 4.
Any ideas?
--
View this message in context: http://www.nabble.com/Problems-porting-trigger-from-DB2-tp17584753p17584753.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
|