Audit file Was: Add flattened subfields after likeds

John,

First of all, for tracking all of the updates of a master file I would use
a journal. No code modification necessary. Records user, job, date,
time, program, etc all automatically.

But if that doesn't trip your trigger then you may want to use DDL instead
of DDS and try something like:
CREATE TABLE ROB/MASTAUD as (select MAST.*,
cast (user as char (10)) as auduser,
cast (current timestamp as timestamp) as audtimestm
from mast ) with no data
Fancy that up by figuring out how to add
CONSTRAINT MAST_TO_MASTAUD FOREIGN KEY (MYPRIMARYKEY) REFERENCES
ROB/MAST (MYPRIMARYKEY) ON DELETE NO ACTION ON UPDATE NO ACTION)
and that foreign key constraint will definitely tie those two databases
together. Add a trigger on MAST to write a row to MASTAUD every time MAST
is updated and you're done.

Not much of an RPG question though.

Rob Berendt