7.17.2 Example

This section explains an example of using the database structure modification utility (creating an audit trail table).

Organization of this subsection
(1) Creating an audit trail table

(1) Creating an audit trail table

This example creates the audit trail table SQL_AUDIT_TRAIL in the RDAREA RD00AUD.

Command to be executed

pdmod -a /usr/seifile/mofl01

Contents of the control statement file (/usr/seifile/mofl01)

create audit table SQL_AUDIT_TRAIL   ...............................1
                 in RD00AUD ;   ....................................2

Explanation
  1. Creates the audit trail table SQL_AUDIT_TRAIL.
  2. Creates the audit trail table in the RDAREA RD00AUD.