Use the Display tab to select preferences
for displaying information.
NULL value indicator
Enter a character to represent
a NULL value. A 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. A 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. Specify
a number from 1 through the site maximum that is 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 - 20) displayed in a selection 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 - 20) displayed for 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,
which is the default value.
- 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 - 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 you prepare an Access Definition
for use with Edit. When editing, the check
box designates whether to start the native application that is associated
with a 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 a LOB processed as a VarChar or VarBinary data
type when you use 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 a LOB is processed as Native or Non-Native.
A 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 also can choose not to
display the message again. Reset Messages resets
the option to display these message dialogs, when appropriate.