Message-ID:

:-) your own self. -- Larry Wall in <199709261754.KAA23761@wall.org>

computers / comp.sys.ibm.as400.misc / Re: RPGLE Trigger program giving unexpected results

RPGLE Trigger program giving unexpected results

<40ad6508-eb16-41cb-bfee-808cb15a778an@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=71&group=comp.sys.ibm.as400.misc#71

copy link Newsgroups: comp.sys.ibm.as400.misc

X-Received: by 2002:ad4:5909:0:b0:4c7:343d:2a60 with SMTP id ez9-20020ad45909000000b004c7343d2a60mr4372487qvb.42.1673346555548;
Tue, 10 Jan 2023 02:29:15 -0800 (PST)
X-Received: by 2002:aca:1209:0:b0:364:3bcb:9305 with SMTP id
9-20020aca1209000000b003643bcb9305mr662603ois.98.1673346555111; Tue, 10 Jan
2023 02:29:15 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border-2.nntp.ord.giganews.com!border-1.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Tue, 10 Jan 2023 02:29:14 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=64.238.150.148; posting-account=w1guXwoAAADA7eZgnoQOu32BFcEQTy_b
NNTP-Posting-Host: 64.238.150.148
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <40ad6508-eb16-41cb-bfee-808cb15a778an@googlegroups.com>
Subject: RPGLE Trigger program giving unexpected results
From: sharadkh...@gmail.com (Sharad Khare)
Injection-Date: Tue, 10 Jan 2023 10:29:15 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 12

by: Sharad Khare - Tue, 10 Jan 2023 10:29 UTC

I am getting unexpected results on trigger program runs insert *after, i read some article on IBM website says to use H THREAD(*SERIALIZE) so that, static memory will not be shared within triggers running on two different jobs. My issue, creating addition(unexpected) lines by trigger program for one in 13k records. any clue what i am missing? we dont user activation group otherwise i could use *caller. also issue occurs when multiple jobs using same trigger program.

H THREAD(*SERIALIZE) tried to keep program run serialized among jobs but still it created additional rows for different data.

Any clue is much appreciated!!

Re: RPGLE Trigger program giving unexpected results

<03339b7b-0974-481c-8e48-6291cbe8f8can@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=72&group=comp.sys.ibm.as400.misc#72

copy link Newsgroups: comp.sys.ibm.as400.misc

X-Received: by 2002:a05:620a:1421:b0:6ff:ccb0:95cd with SMTP id k1-20020a05620a142100b006ffccb095cdmr1572620qkj.36.1673352436650;
Tue, 10 Jan 2023 04:07:16 -0800 (PST)
X-Received: by 2002:a05:6870:562b:b0:151:8cb:72a5 with SMTP id
m43-20020a056870562b00b0015108cb72a5mr1528092oao.279.1673352436292; Tue, 10
Jan 2023 04:07:16 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!3.us.feeder.erje.net!1.us.feeder.erje.net!feeder.erje.net!border-1.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Tue, 10 Jan 2023 04:07:16 -0800 (PST)
In-Reply-To: <40ad6508-eb16-41cb-bfee-808cb15a778an@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=122.161.77.49; posting-account=w1guXwoAAADA7eZgnoQOu32BFcEQTy_b
NNTP-Posting-Host: 122.161.77.49
References: <40ad6508-eb16-41cb-bfee-808cb15a778an@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <03339b7b-0974-481c-8e48-6291cbe8f8can@googlegroups.com>
Subject: Re: RPGLE Trigger program giving unexpected results
From: sharadkh...@gmail.com (Sharad Khare)
Injection-Date: Tue, 10 Jan 2023 12:07:16 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 16

by: Sharad Khare - Tue, 10 Jan 2023 12:07 UTC

On Tuesday, 10 January 2023 at 15:59:16 UTC+5:30, Sharad Khare wrote:
> I am getting unexpected results on trigger program runs insert *after, i read some article on IBM website says to use H THREAD(*SERIALIZE) so that, static memory will not be shared within triggers running on two different jobs. My issue, creating addition(unexpected) lines by trigger program for one in 13k records. any clue what i am missing? we dont user activation group otherwise i could use *caller. also issue occurs when multiple jobs using same trigger program.
>
> H THREAD(*SERIALIZE) tried to keep program run serialized among jobs but still it created additional rows for different data.
>
> Any clue is much appreciated!!
This seems like Roll back issue: Parent file where trigger get fired had a roll back and trigger got executed and created more records than the Parent file. Can you please suggest how trigger can file also be rolled backed when Parent file gets rollback.

Subject	Author
RPGLE Trigger program giving unexpected results	Sharad Khare
Re: RPGLE Trigger program giving unexpected results	Sharad Khare