Re: Read Trigger

first, it can only be an *after read
second, it can only be a program trigger, you can't use declarative triggers
on a read operation (not yet anyway)
third, allow repeated change yes is permitted during the addpftrg command,
so, the buffer is changable
you can alter the record, blank out fields, flush the buffer

or send an escape message and terminate the read operation.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If you pick up a starving dog and make him prosperous,
  he will not bite you. This is the principal difference
  between a dog and a man."

    - Mark Twain

----- Original Message -----
From: "Raul A Jager" <raul@abc.com.py>
To: <rpg400-l@midrange.com>
Sent: Thursday, October 03, 2002 3:49 PM
Subject: Read Trigger


> I understand that this topic is more related to the DB2 than the RPG
> program that uses it.
>
> I wander if a RPG trigger at *READ event can chage the buffer so the
> program receives a modified data.
>
> Also if the trigger can forbid an user from reading certain records, and
> allow others to read it.
>
> I'm sure that is in some manual, but all I cloud find is INSERT, UPDATE
> and DELETE.
>
> TIA.
> Raul
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>