Re: Trigger program

[Charles Wilt <charles.wilt@xxxxxxxxx>]

It depends on the behavior you want...

With STRCMTCTL LCKLVL(*CHG) having COMMIT on the input only files
makes no difference...

With LCKLVL(*CS),  a record read will be locked until the next record
is read or the tansaction is committed/rolled back...

With LCKLVL(*ALL), all records read are locked till the transaction is
committed/rolled back

Take a look here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzakj/rzakjlocklevel.htm

This is known as "transaction isolation", it's usually thought of as
an SQL thing but it does apply to RPG RLA...
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstisol.htm

(note: *CHG = *UR, *ALL = *RS, *CS = *CS)


The data for the deleted record will be in ORrecord.

HTH,
Charles


On Wed, Jun 29, 2011 at 9:22 AM,  <sjones@xxxxxxxxxxxxxx> wrote:
> I posted this on Midrange-L yesterday, but have not had a response so
> thought I may get more from this side of things.
> We have used the trigger program below to do some very simple trigger
> stuff. Now I need to make it a bit more complicated & have some questions
> before I screw it up. I have one ancillary file in the program currently
> & I now need to have a few more. Do I define the other files with the
> Commit(RunCommit)? They will only be used for input if that makes any
> difference. I also need to track deletes, so will the information on the
> record being deleted be stored in the ORrecord or the NWrecord?
>
> Thanks in advance.
>
>
> http://archive.midrange.com/midrange-l/201105/msg00276.html
>
> Steve Jones
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.