Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > CREATE TRIGGER ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 9030 of 9520
Post > Topic >>

CREATE TRIGGER ON INSERT

by Andrea MF <andrea@[EMAIL PROTECTED] > Jun 27, 2008 at 02:57 AM

Hi all,
i have a problem when creating a trigger on DB2 ver 7.2 on WINDOWS.

I have two tables MOVIMAG and BARCODE, the trigge when INSERT INTO
MOVIMAG
will be UPDATE a MOVIMAG field BARCODE taken the value from the table
BARCODE.

I have write this but doesnt work
==========================================
CREATE TRIGGER DB2ADMIN.TRG_I_BARCODE NO CASCADE BEFORE  INSERT  ON
DB2ADMIN.MOVIMAG  REFERENCING  NEW AS N  FOR EACH ROW  MODE DB2SQL
BEGIN ATOMIC
DECLARE iBARCODE varchar(12);
DECLARE iCODICE varchar(12);

SET iCODICE = (SELECT CODICE FROM N);

SET iBARCODE = (SELECT BARCODE FROM DB2ADMIN.BARCODE WHERE CODICE =
iCODICE);

UPDATE N SET BARCODE = iBARCODE;
END
============================================

ERROR:The db answer DB2ADMIN N undefined obj..

why?
tnx
 




 4 Posts in Topic:
CREATE TRIGGER ON INSERT
Andrea MF <andrea@[EMA  2008-06-27 02:57:11 
Re: CREATE TRIGGER ON INSERT
Serge Rielau <srielau@  2008-06-27 07:50:33 
Re: CREATE TRIGGER ON INSERT
Andrea MF <andrea@[EMA  2008-06-27 05:18:46 
Re: CREATE TRIGGER ON INSERT
"Dave Hughes" &  2008-06-27 07:53:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 20:40:03 CST 2008.