
334 Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
Figure 10-9 Drop and create image tables and delete triggers script
The DBA can now freely modify the DDL script to include such details as
schema, table space, and also include any other DDL special clauses
needed. This method provides full control to the DBA so they know what
database objects are being created and where. This eventually results in
better database administration and maintenance.
An important factor here is that the delete triggers should be created only for
those tables for which the installation/business is interested in capturing
delete information in the corresponding Dat ...