Example

This section explains an example of using the database structure modification utility (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 c:\hirdb\pdmod\mofl01

Contents of the control statement file (c:\hirdb\pdmod\mofl01)

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

Explanation