RE: SQL Trigger Information

Date: Tue, 24 Mar 2015 16:58:39 -0400
Subject: Re: SQL Trigger Information
From: charles.wilt@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx

Sorry, didn't see you were on 6.1...

You'll have to use two separate triggers as the "INSERT OR UPDATE" isn't
available till 7.1 ...
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_61/db2/rbafzhctrigger.htm

But 6.1 does indeed support "AFTER UPDATE OF MYCOL1, MYCOL2"

Charles

On Tue, Mar 24, 2015 at 4:54 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

you can indeed do this with an SQL trigger

create trigger mytrg
after insert
or update
of mycol1, mycol2
on mytbl
...

Charles



On Tue, Mar 24, 2015 at 4:45 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

As far as I kow, there is nothing that says you can say this field changed
so fire a trigger. Triggers are by file and by record. Any changed fire
the
trigger.

On Tue, Mar 24, 2015 at 2:41 PM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

Alan,
Thanks, but I was looking for a way to create the trigger for specific
fields being changed in the file. I thought I had read something about
that some time ago, but can not find it.

Jeff Young
Sr. Programmer Analyst

On Tue, Mar 24, 2015 at 4:36 PM, Alan Campin <alan0307d@xxxxxxxxx>

wrote:

Would my trigger mediator be of help. Define the trigger to call for a
given table.www.think400.dk/downloads.htm under Trigger Mediator.


On Tue, Mar 24, 2015 at 2:30 PM, Jeff Young <jyoung0950@xxxxxxxxx>

wrote:

I have a file that I would like to setup a trigger for when selected

fields

are changed or a record is added and have it call an RPGLE program.

Can I do this with SQL?
If so, does anyone have an example to share?

System is at V6R1M1.

TIA


Jeff Young
Sr. Programmer Analyst
--
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.

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

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

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

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