Thanks but it's not it...

Keeps getting me SQL = -199 even with REC.field_name = 0;

Any suggestions?

Pedro Gonçalves


-----Mensagem original-----
De: Wilson Allan [Email address protected]
Enviada: quinta-feira, 20 de Maio de 2004 12:24
Para: LazyDBA Discussion
Assunto: RE: PROBLEMS IN A TRIGGER


Do you need WHERE REC.field_name = 0;

-----Original Message-----
From: Pedro Miguel Gonçalves [Email address protected]
Sent: Thursday, May 20, 2004 6:18 AM
To: LazyDBA Discussion
Subject: PROBLEMS IN A TRIGGER

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]


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]


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