Re: FILE TRIGGER

["Crispin Bates" <cbates@xxxxxxxxxxx>]

Paul,

How does my RPG Program know which record(s) failed because a Trigger 
stopped them from being written, when a block of 100 [for the sake of the 
question] records is passed from the RPG Buffer to the DBMS?

How should I code to handle the individual records that failed, when the 
failure from the trigger does not happen until the block is written?

Am I completely missing something here? I thought the DBMS made the trigger 
calls, not the RPG runtime.

Thanks.

----- Original Message ----- 
From: "Paul Tuohy" <tuohyp@xxxxxxxxxxxxxxxxx>
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, December 03, 2010 12:09 PM
Subject: Re: FILE TRIGGER


> Duane,
>
> Ken is referring to blocking in RPG - and this is something RPG can do
> all by itself, especially if a file is open for output.
>
> i.e. RPG can block a number of records in a buffer before handing them
> over to the DBMS for processing.
>
> Check out the BLOCK keyword for F specs for details.
>
> BTW - not sure if this is the issue with the OPs trigger delay - just to
> clarify what Ken was referring to.
>
> Regards
>
> Paul Tuohy
> ComCon
> www.comconadvisor.com
> www.systemideveloper.com