Display tab

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.