Use the Display tab to select preferences
for displaying information.
NULL value indicator
Enter a character to represent
a NULL value. The question mark (?) is the default. Although you can
choose any character to represent a NULL value, an infrequently used
character is best.
Delimiter for variable length column
values
Enter a character to delimit variable
length column values that have trailing blanks. The semi-colon ( ;
) is the default. Although you can choose any character as a delimiter,
an infrequently used character that differs from the NULL value indicator
is best.
Maximum Fetch Rows
Specify the maximum number of rows
from a single table that can be displayed when you browse or edit
table data or use Point and Shoot. You can enter a number from 1 through
the site maximum, specified on the Product Options dialog
(see the Installation and Configuration Guide ). The default value is 500.
Maximum entries in History Lists
Specify
the maximum number of recently selected items (1 to 20) displayed
in a drop-down list. For example, the Extract File box in a request
editor, where you can click the down arrow to view a list of the most
recently used Extract Files.
Maximum entries in Menu File Lists
Specify
the maximum number of items (1 to 20) displayed below the File menu
commands in an editor. For example, a list of the most recently opened
definitions appears on the File menu in the Access
Definition Editor.
Action/Definition Menu Behavior
Click the down arrow to select the
default mode for opening the action or definition editors from the Actions or Definitions menu
in the main window.
- Open Last
- Opens the last edited request in the selected editor.
This is the default.
- Open New
- Opens a new, untitled request in the selected editor.
Appearance
Options
for displaying tooltips and toolbars on dialogs and editors in Optim™.
- Balloon Style Tooltips
- Controls the appearance of the tooltips. Select
the check box to choose balloon-style. Clear the check box to choose
flat-style (default).
- Flat Style Toolbars
- Controls the appearance of the toolbars. Select
the check box to choose flat-style. Clear the check box to choose
3D style (default).
Main Window
Options
for displaying the list of active dialogs and editors in the main
window. As you open each editor or dialog, the main window expands
to list the active editors and dialogs. To recall an active editor
or dialog, double-click the item in the list.
- Maximum visible components in list
- Specify
the maximum number of active editors or dialogs (5 to 99) displayed
in the main window. The default value is 10. If the number of active
editors and dialogs exceeds the maximum, you can scroll the list.
(If fewer editors or dialogs are in use, the bottom of the list is
blank.)
- Auto size Main Window to list
- Select
to automatically resize the main window as editors and dialogs are
added to the list. If you clear this check box, the main window is
sized to display the maximum number of editors and dialogs that can
be listed.
Large Object (LOB)
- Default Native LOB Mode
- Select
this check box to set the default for the Native LOB Mode check
box on the Columns tab of the Table
Specifications dialog, available through the Access
Definition Editor. You can use the check box on the Table
Specifications dialog when preparing an Access Definition
for use with Edit. When editing, the check box designates whether
to start the native application associated with an LOB, or to process
as a VarChar or VarBinary data type.
- Maximum Non‑Native LOB Length
- Specify the maximum length of data to retrieve from
a database for an LOB processed as a VarChar or VarBinary data type
when using the Table Editor in Edit. Select
a value from 1 KB through 32 KB.
Note: The setting of the Native
LOB Mode check box on the Columns tab
of the Table Specifications dialog (available
through the Access Definition Editor) determines
whether an LOB is processed as Native or Non-Native.
An LOB truncates when the size of the LOB exceeds the
Maximum Non-Native LOB Length setting, and appears in the Table
Editor as a protected cell with a cross-hatched pattern.
Reset Messages
Click Reset
Messages to reset system messages. Message dialogs provide
information or warnings. You can also choose not to
display the message again. Reset Messages resets
the option to display these message dialogs, when appropriate.