Re: DB2 trigger. can it be restricted to a member?

I've never seen anything in the docs saying external program have more
overhead...

The trigger buffer is passed to both SQL or external triggers. It's just
not called "trigger buffer" in the SQL triggers; but that's exacting what
the REFERENCING clause is all about.

CREATE TRIGGER SAL_ADJ
AFTER UPDATE OF SALARY ON EMPLOYEE
REFERENCING OLD AS OLD_EMP
NEW AS NEW_EMP
FOR EACH ROW MODE DB2SQL
WHEN (NEW_EMP.SALARY > (OLD_EMP.SALARY *1.20))
BEGIN ATOMIC
SIGNAL SQLSTATE ’75001’(’Invalid Salary Increase - Exceeds 20%’);
END

Charles







On Mon, Oct 30, 2017 at 8:22 AM, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx

wrote:

thanks,
I have been doing some RTFM......
there are 2 types of trigger programs; SQL and External.
External program triggers have more overhead than SQL triggers, and part of
that overhead is
the "trigger buffer" which contains the file related data; one of the
columns within the trigger buffer is the member...

I didn't want to create an External trigger if I did not have to....





On Mon, Oct 30, 2017 at 8:20 AM, Dan <dan27649@xxxxxxxxx> wrote:

SQL doesn't work with members unless you first create an ALIAS on the
member and use that in your SQL.

- Dan

On Thu, Oct 26, 2017 at 1:00 PM, Gerald Magnuson <
gmagqcy.midrange@xxxxxxxxx

wrote:

Can I reference the member name if my trigger program is SQL? or do I

need

to have a RPGLE program to get to that field?

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD