From Newsgroup: comp.sys.ibm.as400.misc
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.
--- Synchronet 3.21d-Linux NewsLink 1.2