Using Triggers in DB2 v8
Posted: Mon Jul 26, 2010 8:21 pm
Hi all,
Can anyone help me to define a new Insert,Update & Delete trigger?
For example:
TBL-A is the main table. 200 columns and 800,000 rows.
TBL-B is a copy of the A table.
Anytime a row is Inserted, Updated or Deleted from TBL-A, I would like it occur on TBL-B also.
I have been reading on this, but cannot seem to find a good example.
Thank you.
Mike
Can anyone help me to define a new Insert,Update & Delete trigger?
For example:
TBL-A is the main table. 200 columns and 800,000 rows.
TBL-B is a copy of the A table.
Anytime a row is Inserted, Updated or Deleted from TBL-A, I would like it occur on TBL-B also.
I have been reading on this, but cannot seem to find a good example.
Thank you.
Mike