× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2005

Re: Downside to SQL Triggers?

I think there are some limitations when restoring in a new library.
You should read chapter 10 (10.9 e 10.10 are the ones) in 
"Stored Procedures, Triggers
and User Defined Functions
on DB2 Universal Database for iSeries"
SG24-6503-01

HTH
Marco

--- "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> wrote:

> Anyone know of a downside to creating triggers with SQL? I don't mean
> HLL triggers that have embedded SQL, I'm talking about creating triggers
> with the CREATE TRIGGER sql statement. 
>  
> For some things it might make sense to use HLLs for the trigger, but for
> many triggers -- especially those that update one file based on a change
> in another, the SQL triggers seem to be obvious candidates.
>  
> -Walden
>  



        
                
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.