Re: Trigger programme without a trigger.

[Booth Martin <booth@xxxxxxxxxxxx>]

A general question:

Some nagging message coming out of my brain says that there is a 
difference between the regular triggers and an SQL trigger.  Further, 
something makes me believe that those differences probably address some 
of the concerns that his boss has, and if properly presented to him, 
will convince  him that an SQL trigger makes sense in this case.

Please understand!  I have no idea  what I am talking about.   *cough 
cough*  still.


Bob P. Roche wrote:
> I don't think you are going to solve your bosses problem. You want to have 
> a trigger and call it something else. you still want  it to fire off like 
> a trigger and run programs. so it will act like what you have on your 
> current master file. 
>
> Are you sure your boss wanted no triggers but call it something else and 
> that's OK? or not even anything that acts like one? It sounds like you 
> want the trigger and are trying to call it something else to make your 
> boss let you use it.
>
> As for firing off during development. We only keep triggers in our test 
> libraries if we are testing and need the trigger as part of our test. 
> Triggers are live on production files and we don't develop over production 
> data.
>
>
>
>
>
> David FOXWELL <David.FOXWELL@xxxxxxxxx> 
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 06/03/2008 10:14 AM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> RE: Trigger programme without a trigger.
>
>
>
>
>
>
> That's exactly what I asked! : a Trigger programme without a trigger.
>
> I hear there are occasional problems when a trigger program is involved, 
> although I don't have a lot of experience with these. I've just created a 
> new transaction file and the boss says no trigger. The trigger on the 
> master file already fires off all over the place and can be a pain in the 
> neck while developping.
>
> I must add, I agree with you all, if it were me I'd use a trigger.
>
> -----Message d'origine-----
> De : rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] 
> De la part de J.Beckeringh@xxxxxxxxxxxxxxxxxxxxxxxxxx
> Envoyé : mardi 3 juin 2008 15:27
> À : RPG programming on the AS400 / iSeries
> Objet : Re: Trigger programme without a trigger.
>
> That's a bit like asking to automatically playing a sound when somebody 
> pushes a button next to my door, without installing a doorbell.
>
> Joep Beckeringh
>
>
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 03-06-2008 14:41:04:
>
>   
> > Don't ask me why I want to do this!
> >
> > Is there anyway of invoking a procedure automatically each time a
> > write/update is done on the file in the module without putting a
> > trigger on the file ?
> >
> > Thanks
> >     
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list 
> To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, 
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at 
> http://archive.midrange.com/rpg400-l.
>
>   
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM
>