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 InformixInformix? 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 InformixI 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.