Use the Edit tab to select audit preferences for editing data and specify other site options for using default values.

Activate auditing to record rows that you edit and store images of unedited rows in an Optim™ Directory table. You can browse these rows, establish the period for which the system stores rows, and limit the number of rows retained. When rows of audit information expire, they are automatically deleted. When the maximum number of rows is exceeded, the oldest rows are deleted to make space for new rows.
This option enables the auditing feature in Personal Options (see Auditing Active). Users can select additional tables to audit, but cannot disable auditing for tables audited on a site basis.
Choose whether to require user-supplied values in columns that cannot accept default values. This option applies to new rows that a user inserts while editing a database table.
Choose whether to use the NULL character as the default value for nullable columns. This option applies to new rows that a user inserts while editing a database table.
Select this check box to force all new and existing Edit Definitions to be in Browse Only mode. When you select this check box, edit options on the Edit tab in Personal Options and the Edit Preferences on the Table Editor are unavailable. (For example, the option for Undo Levels is unavailable, because Undo entries are not created in Browse Only mode.)
If you select Active or Active/User on the Edit tab of the Product Options dialog, click Audit Tables to display the Audit Tables dialog. Specify default parameters that apply to all processed tables and a list of tables for which one or more defaults are overridden.

Specify the Optim Directory for which audit parameters are defined. If your site has more than one Optim Directory, click the down arrow to select from a list.
Audit results are stored in the PSTAUDIT2 or PSTAUDIT3 table, in the Optim Directory. If authorized, you can browse or edit the PSTAUDIT2 or PSTAUDIT3 table in the same way you browse or edit any other database table. However, Auditing Status in Product Options must be set to Active or Active/User and you must have database SELECT authority for the PSTAUDIT2 or PSTAUDIT3 table.
Specify the defaults for the auditing option at your site:
Tables for which table-specific audit parameters apply. If you select the Active/User option for auditing database tables, the Product Options list supersedes any list users can specify in Personal Options.
If a table is listed in both Personal Options and Product Options, the status in Personal Options is Superseded by Product List. The user cannot change the auditing status for that table. Users can modify the table name, however, or remove it from the list.
Default specifications are propagated to new entries in the list of tables and can be useful when building the list. For example, your database includes 100 tables. You want to retain audit information for 50 tables for 90 days, information for 30 tables for one year, and information for five tables indefinitely. You do not want to audit processes on the remaining 15 tables. To retain audit information for the tables, build the list of audit instructions in the following way:
When you select Add Tables or Replace Table from the shortcut menu, the Select Table to be audited dialog is displayed. This dialog is also displayed when you use the Join command from the Table Editor.

The Select Table to be audited dialog provides a list of tables for the selected database.
Use a pattern to limit the list of objects in the Select Table to be audited dialog. After you specify a pattern, click Refresh to display again the list based on your criteria.
During an Edit Process, Optim audits tables according to the following parameters:
If the table is not on the list, and the Enabled check box under Auditing Defaults in Product Options is selected, the table is audited.
Check the Edit tab in the Personal Options dialog to determine if the Auditing Active check box is selected. If it is, check for the table name on the Personal Options list in the Audit Tables dialog:
If the table is not on either list, and the Enabled check box under Auditing Defaults in Product Options is selected, the table is audited.