Re: Trigger and recursion problem

I came up with a framework that handles database events by "forwarding"
them to a "pool" of "event handlers", using a generic trigger for all
database tables.

Multiple updates to the same database table are therefore handled by a pool
of separate "Jobs", rather than doing them via recursive program calls to
the same trigger program. It's a great architecture for handling situations
like this.

http://rd.radile.com/rdweb/info2/ibmiapp04.html



On Thu, Aug 13, 2020 at 3:26 AM gio.cot via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi all

I have this situation:

in the item master data file, i have a trigger ; now i would need add in
the
trigger program a change, that in some situation do some update to another
record always in the item master data file , which however fire again the
trigger causing recursive error. How could menage this situation (trigger
that updates another record of the same file that has fired the trigger) ?

i have read several post (some one say to use C, other says that i can use
CLP or also Ile with procedure.. and i'm very confused) in this moment i
have a master/mediator trigger program that call one o more program
(reading a file where i have strored the programs to call) that receive
this
two parameters



DbTrgDs

DbTrgLen



DbTrgDS DS

DbFil Like( StdNam )

DbLib Like( StdNam )

DbMbr Like( StdNam )

DbTrgAct Like( StdChr )

DbTrgTim Like( StdChr )

DbCmtLck Like( StdChr )

DbReserve1 3

DbCcsId Like( StdBin4)

DbReserve2 8

DbBfrOfs Like( StdBin4)

DbBfrLen Like( StdBin4)

DbBfrNulOf Like( StdBin4)

DbBfrNulLn Like( StdBin4)

DbAftOfs Like( StdBin4)

DbAftLen Like( StdBin4)

DbAftNulOf Like( StdBin4)

DbAftNulLn Like( StdBin4)

DbTrgBuf 1 32767A

DbTrgAry 1A OverLay( DbTrgBuf )

Dim( %Size ( DbTrgBuf ))



DbTrgAry 1 32767 Dim( 32767 )



DbTrgLen S Like( StdBin4 )



Any idea or suggestion ? (P.S. i'm running on V7R2)



Thanks in advance

Gio





--
Questa e-mail è stata controllata per individuare virus con Avast
antivirus.
https://www.avast.com/antivirus
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com