Creating triggers for custom tables

A trigger creates an entry in the STAGLOG table which identifies database record changes. You can modify the settings of the existing triggers to new tables if the tables contain the same data scope and key characteristics.

If you have not created any new tables, you do not need to perform this step. If you have created new tables:

  1. Identify your customized table scope (site data, merchant data, or site and merchant data).
  2. Create the trigger for your database table using the corresponding trigger examples based on your table's scope and index type.
  3. Insert the customized tables into the STGSITETAB, STGMERTAB, and STGMRSTTAB tables.
    1. For site tables, insert only into STGSITETAB.
    2. For merchant tables, insert only into STGMERTAB.
    3. For tables which contain both site and merchant data, insert into STGSITETAB, STGMERTAB, and STGMRSTTAB.

Note: You must ensure that all the parent tables have been inserted properly and that the TABNBR column of the parent tables is less than that of the child table. If your customized table is the parent table of a WebSphere Commerce table, you also need to ensure that your table's TABNBR column is less than that of the child tables.

Feedback