Re: Multiple events in a single trigger

The trigger program is passed a lot of information about the event, which
indicates if it's an insert, an update or a delete.  So you can code for it
appropriately.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com



                                                                           
             "Mike                                                         
             Pantzopoulos -                                                
             \(H/O\)"                                                   To 
             <mpantzopoulos@ei         <midrange-l@xxxxxxxxxxxx>           
             gansvar.com.au>                                            cc 
             Sent by:                                                      
             midrange-l-bounce                                     Subject 
             s@xxxxxxxxxxxx            Multiple events in a single trigger 
                                                                           
                                                                           
             11/26/2006 07:04                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Does anyone know if iSeries DB2 allows a trigger to be created which
fires when more than one event occurs?



I want to fire a trigger after any INSERT, DELETE or UPDATE on a
particular file.



I'm trying to avoid having to create three separate triggers.



I tried using the Ops Navigator wizard and it only allows one event to
be selected at a time.



Thanks.




*********************************************************************************************************

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any use, disclosure or copying of
this message is unauthorised. If you have received this message in error,
please reply using the sender's email address.

This footnote confirms that this email message has been scanned for
computer viruses. EIG-Ansvar Limited does not accept liability for any loss
or damage, whether caused by our own negligence or not, that results from a
computer virus or defect in the transmission of this email or any attached
file.

EIG-Ansvar Limited - Australia (A.B.N. 21 007 216 506)
Email : insure@xxxxxxxxxxxxxxxx

Eig-Ansvar Limited - New Zealand
Email : insure@xxxxxxxxxxxxxxxx

*********************************************************************************************************

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.