You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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!!
Sharad Khare
unread,
Jan 10, 2023, 7:07:17 AM1/10/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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.