Re: Trigger / 5250 / .Net

[Charles Wilt <charles.wilt@xxxxxxxxx>]

They also fire.

Commitment control doesn't make a difference.

You do need to consider it however, especially if the change to the base
table is sometimes made with CC and sometimes not.

Charles

On Thu, Jun 6, 2024 at 4:54 PM Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
wrote:

> Interesting.  I thought a trigger program would always go off.
>
> Do they only work with commitment control ?
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net
> Email: richard@xxxxxxxxxxxxxxxxx
>
> message: 4
> date: Thu, 6 Jun 2024 17:20:03 -0500
> from: Kirk Yates <kirk.yates@xxxxxxx>
> subject: Trigger / 5250 / .Net
>
> I have a trigger program that writes a single id field to another file if
> an insert or update is made.  Running a simple sql update statement from a
> 5250 strsql interface and everything works great.
>
> If the same sql command is run from a .net interface, the data in the file
> is updated, but the trigger program doesn't catch that a change was made.
>
> Library is defined as TEST if that makes any difference.  Looked at the
> data in the file and the record was updated.
>
> What else should I be checking?
>
> Thank you for your help.
>
> --
> Kirk Yates
>
> ------------------------------
>
> message: 5
> date: Thu, 06 Jun 2024 22:37:05 +0000
> from: craig@xxxxxxxxxx
> subject: RE: Trigger / 5250 / .Net
>
> Check the database driver you're using (ODBC, OLE DB or .NET) for the
> commitment control setting. Try setting it both ways, see if that makes a
> difference.
>
> Craig Pelkie
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Kirk Yates
> Sent: Thursday, June 6, 2024 17:20
> To: Midrange-L List <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Trigger / 5250 / .Net
>
> I have a trigger program that writes a single id field to another file if
> an insert or update is made.  Running a simple sql update statement from a
> 5250 strsql interface and everything works great.
>
> If the same sql command is run from a .net interface, the data in the file
> is updated, but the trigger program doesn't catch that a change was made.
>
> Library is defined as TEST if that makes any difference.  Looked at the
> data in the file and the record was updated.
>
> What else should I be checking?
>
> Thank you for your help.
>
> --
> Kirk Yates
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
>
>
>
>
> ------------------------------
>
> message: 6
> date: Thu, 6 Jun 2024 18:37:28 -0400
> from: Glenn Gundermann <glenn.gundermann@xxxxxxxxx>
> subject: Re: Trigger / 5250 / .Net
>
> There should be an error message in the server job.
>
> Yours truly,
>
> Glenn Gundermann
> Email: glenn.gundermann@xxxxxxxxx
> Cell: (416) 317-3144
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.