Display Tab

Use the Display tab to select preferences for displaying information.

personal options display tab, explained below

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.