Re: Re: Can I use a trigger to...

[Charles Wilt <charles.wilt@xxxxxxxxx>]

The Stored Procedures, triggers, and UDF Redbook says:

"If the trigger determines that invalid data is being inserted, the
insert operation has to be
rejected. We can achieve this by sending an escape message to the call
stack entry where
QDBPUT is running. For this purpose, use the QMHSNDPM API to signal an escape
message to QDBPUT. You may choose to send a user-defined message back to the
application that fired the trigger."

Assuming your trigger is RPG..

If SQL, you'll want to make use of the SIGNAL SQLSTATE VALUE .... statement.

HTH,
Charles


On Fri, Oct 1, 2010 at 3:17 PM,  <GKern@xxxxxxxxxxxxxxxx> wrote:
> "All your trigger needs to do to prevent an update is throw an exception
> message up the stack."
>
> Is that like using SNDPGMMSG or something similar?
>
> My thought was to (in the trigger program when they're doing maintenance
> when they shouldn't be) was to send a break message and inform them of
> their misdeed. And then end their job (or call a pc program to give the a
> BSOD ;)
>
> Thanks!
>
> Regards, Jerry
>
> Gerald Kern - Information Technology
> Programming Supervisor
> IBM Certified RPG IV Developer
> Lotus Notes/Domino 8.0.1 Administrator
> The Toledo Clinic, Inc.
> 4235 Secor Road
> Toledo, OH 43623
> Phone 419-479-5535
> gkern@xxxxxxxxxxxxxxxx
>
>
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please inform the
> sender by reply e-mail and destroy this and all copies of this message.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.