Multiple events in a single trigger

Thanks Al,

 

Another major confusion I've had with triggers is the difference between
ADDPFTRG and the 'create trigger' statement in SQL.

 

Are they essentially the same? 

 

The examples I've been using have created an SQL trigger that invokes an
SQL procedure that provides the interface to the HLL program (a CL), and
the ADDPFTRG was used to add the SQL trigger. Sounds confusing doesn't
it?

 

I was always dubious about it because the ADDPFTRG seemed to require the
same parameters as the SQL trigger.

 

 

 

 


*********************************************************************************************************
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

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