General Options

From DBArtisan
Jump to: navigation, search

Go Up to Configuring Feature Options

The General tab of the Options Editor lets you specify general application options.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.

The table below describes the options and functionality on the General tab:

Tab Option Description Default

Main tab

Confirm on Exit

Ensures that a prompt is issued confirming the operation before exiting the application.


Max Editors in a Single Open Operation

Specifies the maximum number of editors allowable from a single Open operation.


Max Entries in Output Window

Specifies the maximum number of messages that can appear in the Output Window before the contents are flushed. This option conserves memory resources. You can clear the Output window or raise the maximum number allowed at any time.


The General tab also offers the following DBMS-specific aub-tabs:

Oracle sub-tab

Option Description Default

Data Dictionary View Usage

Lets you synchronize use of the Oracle Data Dictionary DBA and ALL/USER views with the privileges associated with the role used in creating and using the datasource.
Role-based Views - Views based on the user’s role will be used. That is, users with DBA privileges will use DBA views.
DBA Views - DBA views are always used.
All Views - ALL views are always used.
Use Datasource Configuration for Views - lets you set up Data Dictionary usage on a view-by-view basis when editing or registering a datasource.
For more information, see Registering Datasources.

Preserve Case in Object Identifiers

Preserves case of the database object.

Not selected

Sybase and SQL Server sub-tabs

Option Description Default

Rename action style

Lets you specify whether user-defined objects or datatypes are renamed using an extended ALTER or using the sp_rename procedure.

extended alter