RE: Trigger programme without a trigger.

From a home grown application stand point, no; as long as you can ensure that some Windows programmer
doesn't write an application later that writes to the DB directly.

However, what about "quick fixes" of the data using SQL, DBU, WRKDBF, ect.

Depending on what you need to do with you "not a trigger" trigger, you may be ok with not firing for
such quick fixes.

On the other hand, if this is for audit purposes, an auditor would be happier with a trigger (actually
journaling would be the best choice)

HTH,

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of David FOXWELL
Sent: Wednesday, June 04, 2008 8:06 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Trigger programme without a trigger.

Ok. Got a response as to why no trigger.

Recently I asked for advice while creating a unique module for a new PF,
which I took and I now have a module that does all the business logic and
input/output on that new file.

So now the reasoning is, since all input to the file has to pass by this
module, the use of a trigger is superfluous. We just call the procedure at
each modification of the file. The future looks bleak for trigger
programs.

Anyone still find a hole to pick with the idea?...
--
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.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.