RE: URGENT Off-topic -> Triggers in Informix

[Bob Lofstrand]

Also check out www.informix.com/documentation to find the online docs.

Informix guide to SQL: Syntax will give you the complete run down.

-----Original Message-----
From: Bob Lofstrand
Sent: Wednesday, June 12, 2002 11:26 AM
To: '[EMAIL PROTECTED]'
Subject: RE: URGENT Off-topic -> Triggers in Informix

Informix? Your a ways from home. :)

 

If I remember correctly you just need some parentheses:

 

create trigger cmst_trig
UPDATE on cmst
for each row
( execute procedure sp_cmst_upd ( ) );

 

Surround your actions with parens and you must call your procedure with empty parens if there are no parameters to pass.

 

Check out http://www.iiug.org to find and sign up for the Informix listserv.

-----Original Message-----
From: Santosh Varma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 1:33 AM
To: Multiple recipients of list ORACLE-L
Subject: URGENT Off-topic -> Triggers in Informix

I wrote a trigger in Informix ->

 

create trigger cmst_trig
UPDATE on cmst
for each row
execute procedure sp_cmst_upd;

 

But this is giving Syntax Error...Any help is welcome...

Thanks and regards,

Santosh

The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.