General Options

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.	Selected
	Max Editors in a Single Open Operation	Specifies the maximum number of editors allowable from a single Open operation.	5
	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.	1500

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