Re: FILE TRIGGER

["Crispin Bates" <cbates@xxxxxxxxxxx>]

Paul,

No worries, the confusion that filtered through to me was that this thread 
was suggesting that blocking could be the OP's "problem" with his trigger. 
It wasn't necessarily your details, more that yours was the one that 
triggered me to interject :)

Crispin.


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


> Hi Crispin,
>
> Sorry for any confusion - as per the end of my note, I was not
> commenting on the original posters question or whether or not RPG
> blocking was causing the problem (although I would be amazed if you
> could specify BLOCK(*YES) for a file with a trigger).
>
> I simply wanted to clarify that RPG has it's own blocking mechanism.
>
> Regards
>
> Paul Tuohy
> ComCon
> www.comconadvisor.com
> www.systemideveloper.com
>
>
>
>
>
> Crispin Bates wrote:
> > 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
> --
> 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.