Re: trigger program: can I fool a program into reading some select fi elds from another file?

Have no experience with triggers, although I *thought* I remembered
seeing/hearing that newer OS/400 versions supported "read" triggers - I'll
leave that to more experienced listers.

However, I wonder why you don't just update the old customer master file
en masse, a one-time fix to replace the old customer master's address with
the one found in the new file, since this is basically what you're doing,
albeit one record at a time.  

GA

--- "Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx> wrote:
> I have 1000+ programs reading a customer master file (the old cust
> file).
> Can I add a trigger program which performs the following:
> 
> Whenever a program which reads a record from the old customer master
> file:
> 
> Read a different new customer file, get the customer's address from the
> new
> file, and place the new address field into the address field in the old
> customer record format.
> 
> Using this method, I could add a new file and not have to change any of
> the
> many programs using the old customer master file.
> 
> If not a trigger program, is there any other method to accomplish this
> on
> the Iseries?
> 
> I am aware of OVRDBF, but that will not allow me to grab select fields
> from
> another file.
> 
> Also I am familiar with OPNQRYF, but that would require CL changes and
> would
> limit the ease of implementation.  Also, OPNQRYF would not support any
> logic
> built into the record retrieval.
> 
> If I could use a trigger program, in theory, I could make a database
> change
> which would require no changes to programs using the customer file.
> 
> Thanks!

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com