Alter Table -- Fields and controls

Table page



Table page

Validate routine
Audit

Validate routine

Type a new name for the program that you want to be the validation exit routine for the table; for example, 

EMPLNEWE
The validation routine can inhibit a LOAD, INSERT, UPDATE, or DELETE operation on any row of the table. Before the operation takes place, the row is passed to the procedure. The values represented by any LOB columns in the table are not passed. After examining the row, the procedure returns a value that indicates whether the operation can proceed.

If you replace an existing program name, the new program is not used to validate existing table rows. It is used only to validate rows that are loaded, inserted, updated, or deleted after the table is altered.

If you no longer want to use a validation exit routine for this table, clear this field. Do not type NULL.

Audit

Use this box to specify the type of access to this table that causes auditing to be performed.

Auditing is usually part of your overall security plan for keeping your DB2 system secure. You can use auditing to determine if attempts are made to gain unauthorized access to the table and who accessed the table data.

The audit type can be one of:

NONE
No auditing is done when the table is accessed.
CHANGES
Auditing is done when the table is accessed during the first INSERT, UPDATE, or DELETE performed by each unit of work. However, the auditing is done only if the appropriate audit trace class is active.
ALL
Auditing is done when the table is accessed during the first operation of any kind performed by each unit of work of a utility or application process. However, the auditing is done only if the appropriate audit trace class is active and only if the access is not performed with COPY, RECOVER, REPAIR, or any stand-alone utility.