Re: SQL Trigger Information

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.