Hi guys,

I'm working with DB2 v.7 for OS/390.

What's the problem with this trigger I want to create?

CREATE TRIGGER trigger_name
NO CASCADE BEFORE INSERT ON table_name
REFERENCING NEW AS REC
FOR EACH ROW MODE DB2SQL
UPDATE table_name
SET REC.field_name = NULL
WHERE field_name = 0;

Keeps telling that I should switch some keyword or end-of-statment for some tokken that DB2 doesn´t give me.


HELP.


Pedro Gonçalves. [Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page