Re: Trigger programme without a trigger.

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