Download IBM Optim: Optim Common Elements Manual

Single View
Select to disable the Join capability when the first item in the Table Editor is a view. Browsing and editing
is more efficient using single view mode because relationship information is bypassed. However, to
browse or edit related data, you must clear the check box.
Side Label Display
Select to show column names and values side by side for a single row. To show column names and
values for multiple rows (Columnar Display), clear this check box.
Warn on Cascade
Select to display a warning that rows in other tables may be deleted, or column values set to NULL,
when you delete rows in a table. The Delete Confirmation dialog displays the names of affected tables,
including tables that are not shown in the Table Editor. Column values may be set to NULL if the
relationship between the tables is using the SET NULL delete rule.
Note: Be certain you want to disable this feature before clearing this check box.
Display NULL as Insert Default
Select to specify NULL as the default value for nullable columns when you insert a new row. If you clear
this check box, Edit provides a value based on the column data type. Other than NULL, possible values
include blank, zero, current date, current time, and current timestamp. To specify the character for the
NULL value indicator, use the Display tab on the Personal Options dialog.
Note: Site management may set Product Options to restrict the use of this feature.
User Supplies Defaults
Select to require a user-supplied value for every column that cannot accept a default value. If you clear
this check box, Edit provides a value based on the column data type. Possible values include blank, zero,
current date, current time, or current timestamp.
Note: Site management may set Product Options to restrict use of this feature.
Prompt for Variables
Select to request a prompt for default values associated with substitution variables in an Access
Definition. You can use substitution variables in selection criteria to specify data to browse or edit.
Retain SelCrit for Self-Ref Rels
Select to apply selection criteria each time a table is self-referenced in the Table Editor. Clear the check
box to ignore selection criteria when a table is self-referenced. The default value can be changed on the
Specify Edit Preferences dialog.
Note: A table can be self-referenced only when the Table Editor is in Browse mode.
Auditing Active
Select to activate the Audit option for tracking database changes when you edit data. If you select this
option, click Audit Tables to specify the tables you want to audit. If you prefer not to use this option,
clear the check box.
Chapter 18. Personal Options
453