Can some show me the syntax for a simple trigger on table? Sample: table1 and table2. If an update is made to field 'Fname' on Table1, the trigger is fire and update 'Fname' Table2. Thanks in advance...

creat trigger mytrigger after update of fname on table1 referencing old as o new as n defaults NULL for each row mode db2sql <what you want to do goes here>

You should read the SQL Reference Manual.

HTH

Andy