RE: Trigger programme without a trigger. -- RPG400-L

Ding, Ding, Ding....

To your corners gentlemen...

Joe, it is possible to write a faulty trigger program just like anything else. Perhaps it was simply
a missed business rule, the trigger should have caught the problem but the specs were incomplete
<grin>

Regardless, the CFO says fix it, and Mr. QSECOFR does just that with DFU or SQL. With the trigger any
business rules, except obviously the one that was missed, would still be enforced. With an I/O
module, they wouldn't.

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 rob@xxxxxxxxx
Sent: Friday, June 06, 2008 10:29 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Trigger programme without a trigger.

I guess I have to use a line from a thread long ago... Get the key out of
your ear and listen. :-)

There were NO triggers on the data. The only integrity was done via the
I/O module, or so you said "forget the I/O module", from the data entry
program. And, again, the programmer who set up the I/O module, data entry
program, etc, is out of the office. And the person filling in...

So now, ONCE YOU GET THE DATA CLEANED UP, you add the triggers,
constraints, etc. Now, if they forgo the I/O module or other method of
programmatically protecting the data, it becomes more obvious if they
attempt to RMVPFTRG, RMVPFCST or whatever that the items are there for
integrity and not just to be a PITA as might have been erroneously assumed
by the file being secured from them.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/06/2008 10:06 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.

rob@xxxxxxxxx wrote:

<snip>
But here's my question: if this were a trigger type of system, how did
the error get there in the first place?
</snip>
The point is, it wasn't a trigger type of system. It was an I/O modul e

type of system. How did the bad data get in on an I/O module type of
system?

Rob, FORGET THE I/O MODULES.

You say you want to implement triggers to make it easy to update data
errors without making more data errors. I ask you: if you had triggers,
how did you get data errors? If the triggers allowed the data errors in
the first place, then they will allow more! So why do you have the
triggers?

Joe
--
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 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.