Application - Options
Aqua Data Studio has different configurable options which may be accessed through the Menu: File->Options command.
The option dialog contiains 16 tabs:
General, Table Editor, SQL Editor, Text Editor, HTML Editor, XML Editor, Compare, Results, Query Analyzer, Scripts, Results Format, Visual Explain, Formatter, Permissions, Key Mappings and Registration Defaults.
Note: All application options are stored in a file called datastudio.properties in the user home directory. This file may be modified manually or deleted to set all settings back to default.
|
Application Options
|
| General |
Application Options - General |
Appearance
Look and Feel: Look and Feel used by the application
Look and Feel Font: The font used by the application for the user interface components
Editor Font: The font used by the Editors, including in the Query Analyzer
Text Results Font:
The font used by the Text Results panel in the Query Analyzer
Grid Results Font: The font used by the Grid Results in the Query Analyzer
Display Splash Screen: Enable/Disable splash screen for the application start
Enable Ctrl-TAB: Document Cycling: Enables Ctrl-TAB for cycling through documents
General
Script Filters: File extensions which identify scripts to be displayed in the schema browser, script browser and file dialogs
Display Server Type: Display server type [Production/Development/Test] on server node
';' Statement separator:
In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature may cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
Save Passwords (Default): Save passwords when registering a server (Default)
Maximum # of lines in Text History:
Maximum # of lines in the Text History results
Maximum # of Message Lines: Maximum # of lines in the Messages results
Application Scope Maximum Results: The maximum results returned by Query Analyzer, Table Data Editor and Query Builder
regardless of the user specified settings. If the user specified maximum in the tool is greater then this option, then this option will be used. -1 indicates unlimited
Enable Server Directory Mount: This setting indicates whether the user can mount
remote server connection directories
SQL Server Quoted Identifier (Default): The default value for quoted identifier when registering a SQL Server server
Sybase Quoted Identifier (Default): The default value for quoted identifier when registering a Sybase server
Query Windows
Do not prompt to save for new scripts: Determines whether the application will prompt the user to save a modified query window when closing the window.
MultiTab Query Window: Determines whether the Query Window arranges the editor and results in
a split pane or multitab pane
Prompt for commit when auto-commit is OFF: Determines whether the application will prompt the user to commit if rows are modified and auto-commit is not enabled.
Changeable Oracle Schema: Determines whether the Query
Window allows the user to change the schema context of the connection in the toolbar for Oracle connections.
Changeable DB2 Schema: Determines whether the Query Window allows the user to change the schema context of the connection in the
toolbar for DB2 connections.
Permission Failure Message: This custom message is displayed if a query fails local permissions
Show File Name: Shows the filename in the tab
Scripting
Indentation: Number of space identations when generating DDL scripts
Statement Separator: Statement separator to use when generating DDL scripts
Script DROP on CREATE: Determines whether script CREATE will also contain a DROP
before the CREATE.
Script GRANT on CREATE: Determines whether script CREATE will include GRANT permissions after the CREATE.
Format SELECT script when scripting: Determines whether SELECT scripts are formatted with the SQL Formatter.
History
Maximum # Entries in SQL History: Maximum # of SQL statement executions stored for by SQL History
Maximum # Statements per Entry: Maximum # of SQL statements per History Entry
Enable SQL Archive: Enable or disable the SQL Archive feature
Specify Archive Directory: Determines where the SQL Archive is stored
Query Builder
Show Add Table Dialog at startup: Determines if the Add Dialog is display when a new Query Builder window is initially openned.
Shortcut Persistance:
Describe
Include Indexes: Includes indexes in the summary when describe is called.
Include Permissions: Includes permissions in the summary when describe is called.
Execution Monitor
Query Warning Time: Sets the time duration at which the user is warned for a running query, in seconds
Query Stop Time: Sets the time duration at which the running query is automatically stopped, in seconds
Query Snooze Time: Sets the default
time addition to snooze the stopping of a query, in seconds
Query Max Snooze Time: Sets the maximun amount of time a user can snooze a query, in seconds
Enable Execution Monitor for Table Data Editor: Enables the Execution Monitor for Table Data Editor query execution
Parameterized Scripts
DateTime Tag: Parameterized script macro tag for datetime
Date Tag: Parameterized script macro tag for date
Time Tag: Parameterized script macro tag for time
DateTime at Midnight Tag: Parameterized script macro tag for datetime
at midnight
Prompt for parameter values: Prompt for parameter values even when all default values are set
|
| Table Editor |
 Application Options - Table Data Editor |
Table Data Editor
Transactions Required for Table Data Editor: Determines whether the Table Data Editor requires transactions. NOTE: If this is set to false, the Table Data Editor can't guarantee single row modifications for row updates.
Allow Primary Key definition changes
on Table Data Editor: Determines whether the Table Data Editor allows Primary Key definition changes in the Table Data Editor.
Transform "null" Strings into Null: enables or disables Transform.
Save SQL History: queries generated in Table Data Editor are saved to SQL History after being executed and commited. With the Full (default) transaction type all of the queries are saved as one entry, otherwise queries are saved by batches being commited. If a query or a batch fails, including the case when a user cancels it, further queries are not executed and not saved.
Transaction
Transaction Type: Determines the transaction method applied to executed statements.
Batch Size: Determines number of statements per transaction. [Transaction Type: Batch]
Threshold: Determines time limit threshold per transaction, milliseconds.
[Transaction Type: Threshold]
Wait Time: Determines the amount of time to wait between transactions, milliseconds. [-1 = Disabled]
Transaction Log Monitor [Sybase ASE]
Log Used Threshold: Determines the % of the Transaction Log used that will trigger a transaction wait time period. [-1 = Disabled]
Log Used Wait Time: Determines wait time between transaction log used checks when log used is over threshold, milliseconds.
|
| SQL Editor |
SQL Editor Options |
General
Highlight matching brace: Determines whether matching brace is auto-highlighted
Highlight caret row: Highlight row where the insertion point is
Highlight caret row color: Highlight caret row color
Status Bar Visible: Determines if the
status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window.
Display Text Limit Line: Determines if the text limit line is displayed
Text Limit Character Count: Determines the character count after which the text
limit line is displayed.
Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
Editor Background Color: The background color for the Query Editor and results
Highlighted text foreground: Highlighted text
foreground
Highlighted text backgroud: Highlighted text backgroud
Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
Insertion Point: Insertion Point Style
Overwrite Caret: Style of caret when in overwrite mode
Force Write EOL: Forces a specific EOL (End of Line)
Auto Completion
Auto Popup: Code completion window automatically appears when appropriate.
Auto Popup Delay: How long to wait (in milliseconds) before automatically popping up the completion window.
Instant Substitution: Code completion performs instant substitution, if
the search result contains only one item.
Pane Maximum Size: The maximum size of the completion pane window.
Pane Minimum Size: The minimum size of the completion pane window.
Global Cache: Enables the Global Autocompletion Cache
Syntax Coloring
Enabled: Determines whether Syntax Coloring is enabled
Enable Bold :Enables bolding of text
SQL 92/99 Keywords: The color used for standard SQL 92 and 99 keywords
Vendor Keywords: The color used for vendor specific keywords
Numerics: The color used for numbers
Data Types:
The color used for database specific data types
System Functions: The color used for database specific system functions
System Tables: The color used for database system tables
Quoted Strings: The color used for single quoted
strings
Comments: The color used for commented text
Aqua Commands: The color used for aqua commands
Tabs
Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
Number of spaces per tab: Number of spaces to expand in a TAB if Expand Tab is enabled
Tab size: The display size in characters of a TAB
|
| Text Editor |
Applicaton Options - Text Editor |
General
Highlight matching bracket: Highlight bracket that matches the bracket before the insertion point
Highlight caret row: Highlight row where the insertion point is
Highlight caret row color: Highlight caret row color
Status
Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window.
Display Text Limit Line: Determines if the text limit line is displayed
Text Limit Character Count: Determines the character
count after which the text limit line is displayed.
Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
Editor Background Color: The background color for the Query Editor and results
Highlighted
text foreground: Highlighted text foreground
Highlighted text backgroud: Highlighted text backgroud
Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
Insertion Point: Insertion Point Style
Overwrite Caret: Style of caret
when in overwrite mode
Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type.
Tabs
Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
Number of spaces per tab: Number of spaces to expand in a TAB if Expand Tab is enabled
Tab size: The display size in characters of a TAB
|
| HTML Editor |
Application Options - HTML Editor |
General
Highlight matching bracket: Highlight bracket that matches the bracket before the insertion point
Highlight caret row: Highlight row where the insertion point is
Highlight caret row color: Highlight caret row color
Status Bar Visible: Determines if
the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window.
Display Text Limit Line: Determines if the text limit line is displayed
Text Limit Character Count: Determines the character count after which the text limit line
is displayed.
Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
Editor Background Color: The background color for the Query Editor and results
Highlighted text foreground: Highlighted text
foreground
Highlighted text backgroud: Highlighted text backgroud
Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
Insertion Point: Insertion Point Style
Overwrite Caret: Style of caret when in overwrite mode
Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type.
Tabs
Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
Number of spaces per tab: Number of spaces to expand in a TAB if Expand Tab is enabled
Tab size: The display size in characters of a TAB
|
| XML Editor |
Application Options - XML Editor |
General
Highlight matching bracket: Highlight bracket that matches the bracket before the insertion point
Highlight caret row: Highlight row where the insertion point is
Highlight caret row color: Highlight caret row color
Status Bar Visible: Determines if the status
bar (showing insert mode, line number, and so on) is displayed at the bottom of the window.
Display Text Limit Line: Determines if the text limit line is displayed
Text Limit Character Count: Determines the character count after which the text limit
line is displayed.
Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
Editor Background Color: The background color for the Query Editor and results
Highlighted text foreground: Highlighted text
foreground
Highlighted text backgroud: Highlighted text backgroud
Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
Insertion Point: Insertion Point Style
Overwrite Caret: Style of caret when in overwrite mode
Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type.
Tabs
Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
Number of spaces per tab: Number of spaces to expand in a TAB if Expand Tab is enabled
Tab size: The display size in characters of a TAB
|
| Compare |
Application Options - Compare |
Directory Compare
Compare File Contents during Directory Compare: Enables comparison
Ignore
Ignore Leading Spaces: Enable ignore leading spaces
Ignore Trailing Spaces: Enable ignore trailing spaces
Ignore Embedded Spaces: Enable ignore embedded spaces
Ignore Case:Enable ignore case
Ignore Blank Lines: Enable ignore blank lines
|
| Results |
Application Options - Results |
Script Execution
Stop on error: Stop executing statements after a failed query.
Data Retrieval
Convert binary to hex: Convert binary data results to hex.
Maximum BLOB Blocks: Maximum number of 8k blocks to retrieve from BLOB values
Maximum CLOB Lines: Maximum number of lines to retrieve from CLOB values
Right trim spaces on 'char'
and 'nchar' datatypes: Enables the trimming of spaces from the right on 'char' and 'nchar' datatypes.
Text Results
Maximum column length: Maximum length of characters to display per column
Display SQL Statement: Determines whether the SQL statements are displayed for each query.
Display query statistics: Determines whether the statistics are displayed for
each query. (ALT-SHIFT-R)
Display warning headers: Determines whether the warning headers are displayed along with the warning messages.
Always display 'records affected' count: The 'records affected' is always displayed on queries even if 'Display query statistics' are off.
Message Results
Clear message results before execute: Determines whether to clear the message results tab before executing a statement or script.
Grid Results
Alternate row colors: Alternate the row colors of the grid results.
Clipboard Copy as default format: Determines whether
Copy to clipboard will copy numeric values as the full value in the default format.
Syntax Color
Enabled: Determines whether Syntax Coloring is enabled.
SQL Statements: The color used for SQL Statements.
SQL Errors: The color used for SQL error messages.
Status Panel Color
Enabled: Determines whether Message Panel Coloring is enabled.
Status Panel Errors: Background: The background color used for SQL error messages on the message panel.
Status Panel Errors: Foreground: The foreground color used for SQL error
messages on the message panel.
Status Panel Warnings: Background: The background color used for SQL warning messages on the message panel.
Status Panel Warnings: Foreground: The foreground color used for SQL warning messages on the message panel.
|
| Query Analyzer |
Application Options - Query Analyzer |
Oracle 9i/10g
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Oracle 8i
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
DB2 7.x
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto On
All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
DB2 8.x/9.x
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
SQL Server 2000/5
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto On
All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
SQL Server 7
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Sybase ASE
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Sybase Anywhere
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Sybase IQ
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Informix
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
PostgreSQL
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
MySQL
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
Generic JDBC/ODBC
Auto Completion: Default Auto Completion setting for Query Analzyer.
Auto Commit: Default Auto Commit setting for Query Analzyer.
Max Results: Default Maximum results returned in query for Query Analzyer.
Auto On All Schemas: Default for Auto
On All Schemas for Query Analyzer.
Parameterized Script: Default for Parameterized Script for Query Analyzer.
|
| Scripts |
Application Options - Scripts |
Oracle 9i/10g
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Oracle 8i
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
DB2 7.x
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
DB2 8.x/9.x
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
SQL Server 2000/5
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
SQL Server 7
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Sybase ASE
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Sybase Anywhere
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Sybase IQ
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Informix
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
PostgreSQL
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
MySQL
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
Generic JDBC/ODBC
Server Side Comment: /* */: Enable Server Side Comments for block comments.
Server Side Comment: //: Enable Server Side Comments for slash comments.
Server Side Comment: --: Enable Server Side Comments for dash comments
Quote Identifier: Specifies the
quote identifier for objects.
Qualify Object w/ Schema: Enable the qualifing of object name with schema name.
Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
Quote Identifier for Table Completion: indicates the quote identifier for table completion
Quote Identifier for Column Completion: indicates the quote identifier for Column completion
|
| Results Format - Allows you to define how datatypes are formatted in the Text and
Grid results. |
 Application Options - Results Format
|
| Visual Explain | 
Application Options - Visual Explain |
Oracle Visual Explain
Create explain table: Create explain table if it does not exist prior to executing query
Drop explain table: Drop explain table after executing query
Use dynamic explain table: Determines whether to use a dynamic explain table name (AQUA_EXPLAIN_[SESSIONID]) or
a user defined table
Explain schema: The schema name of the explain table to use if a user defined explain table is selected
Explain table: The table name of the explain table to use if a user defined explain table is selected
Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. 'Full Table Scan' and 'Cartesian Join')
Display commit warning: Display commit warning when auto-commit is disabled and CREATE/DROP is enabled
DB2 Visual Explain
Create explain tables: Create explain tables if they do not exist before executing query
Drop explain tables: Drop explain tables after executing query
Color critical path: Determines on whether to color code the path to the highest code path in an
explain plan
Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
Color critical operations: Determines on whether to color code the highest cost operations in an explain plan (i.e. 'Full Table Scan' and 'Cartesian Join')
MS SQL Server Visual Explain
Color critical path: Color critical path
Color critical nodes: Determines on whether to color code the highest cost nodes in an explain plan
Color critical operations: Determines on whether to color code the highest cost operations in an explain
plan (i.e. 'Full Table Scan' and 'Cartesian Join')
Critical Path Colors
Background: Background color of the nodes in the critical path
Foreground: Foreground color of the nodes in the critical path
Critical Node Colors
Background of 1st critical node: Background color of the highest cost node
Foreground of 1st critical node: Foreground color of the highest cost node
Background of 2nd critical node: Background color of the 2nd highest cost node
Foreground of 2nd
critical node: Foreground color of the 2nd highest cost node
Background of 3rd critical node: Background color of the 3rd highest cost node
Foreground of 3rd critical node: Foreground color of the 3rd highest cost node
Critical Operation Colors
Background of 1st critical operation: Background color of 1st level critical operation
Foreground of 1st critical operation: Foreground color of 1st level critical operation
Background of 2nd critical operation: Background color of 2nd level critical
operation
Foreground of 2nd critical operation: Foreground color of 2nd level critical operation
Background of 3rd critical operation: Background color of 3rd level critical operation
Foreground of 3rd critical operation: Foreground color of 3rd level critical operation
|
| Formatter | 
Application Options - Formatter |
General
Show Options Dialog: Whether the Options Dialog will be shown before formatting
Line Break
Before Comma: Adds a line break before the comma
After Comma: Adds a line break after the comma
Before Logical Operators: Adds a line break before logical operators (e.g. AND, OR)
After Logical Operators: Adds a line break before logical
operators (e.g. AND, OR)
After SQL Keywords: Adds a line break after SQL keywords (e.g. SELECT, FROM, WHERE)
Break for CASE Keywords: Adds line breaks for CASE keywords (i.e. CASE, WHEN, THEN, ELSE, END)
Break for Brackets: Adds line breaks for
brackets in AND, OR and WHEN
Wrap Line: Wraps line automatically
Line Wrap Column: The maximum column before line wraps
Uppercase
SQL Keywords: Turns SQL keywords uppercase
Full SQL: Turns the full SQL statement uppercase
Indentation
Number of spaces per Tab: Number of spaces to expand in a TAB if Tabs are used for indentation
Use Tabs for Indentation: Determines whether a real TAB is used or whether a TAB is expanded to spaces
Alignment on Operators: Alignment on =, <, > and
AS
Alignment on JOIN: Alignment on table joins
|
| Permissions | 
Application Options - Permissions |
Default Production Server Permissions
Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for Production servers.
Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query
Analyzer window for Production servers.
Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for Production servers.
Query Analyzer: Allows DELETE Statements: Determines whether DELETE
statements may be executed in the Query Analyzer window for Production servers.
Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for Production servers.
Query Analyzer: Allows DDL
Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for Production servers.
Query Analyzer: Allows All Other SQL Statements: Determines whether SQL statements other then SELECT, INSERT, UPDATE, DELETE,
TRUNCATE, CREATE, ALTER or DROP may be executed in the Query Analyzer window for Production servers.
Visual Editing: Allows CREATEs: Determines whether CREATEs are allowed for objects for Production servers.
Visual Editing: Allows ALTERs: Determines whether
ALTERs are allowed for objects for Production servers.
Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for Production servers.
Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed
for Production servers.
Table Data Editor: Allow Open Window: Determines whether opening Table Data Window is allowed for this server connection
Table Data Editor: Allow INSERTs: Determines whether INSERTs are allowed for objects for Production servers
Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for objects for Production servers
Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for objects for Production servers
Table Data Editor: Allow Primary Key definition changes: Determines whether Primary Key definitions can be changed for servers.
Default Development Server Permissions
Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for Development servers.
Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query
Analyzer window for Development servers.
Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for Development servers.
Query Analyzer: Allows DELETE Statements: Determines whether DELETE
statements may be executed in the Query Analyzer window for Development servers.
Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for Development servers.
Query Analyzer: Allows DDL
Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for Development servers.
Query Analyzer: Allows All Other SQL Statements: Determines whether SQL statements other then SELECT, INSERT, UPDATE, DELETE,
TRUNCATE, CREATE, ALTER or DROP may be executed in the Query Analyzer window for Development servers.
Visual Editing: Allows CREATEs: Determines whether CREATEs are allowed for objects for Development servers.
Visual Editing: Allows ALTERs: Determines whether
ALTERs are allowed for objects for Development servers.
Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for Development servers.
Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed
for Development servers.
Table Data Editor: Allow Open Window: Determines whether opening Table Data Window is allowed for this server connection
Table Data Editor: Allow INSERTs: Determines whether INSERTs are allowed for objects for Development servers
Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for objects for Development servers
Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for objects for Development servers
Table Data Editor: Allow Primary Key definition changes: Determines whether Primary Key definitions can be changed for servers
Default Test Server Permissions
Query Analyzer: Allows SELECT Statements: Determines whether SELECT statements may be executed in the Query Analyzer window for Test servers.
Query Analyzer: Allows INSERT Statements: Determines whether INSERT statements may be executed in the Query
Analyzer window for Test servers.
Query Analyzer: Allows UPDATE Statements: Determines whether UPDATE statements may be executed in the Query Analyzer window for Test servers.
Query Analyzer: Allows DELETE Statements: Determines whether DELETE statements
may be executed in the Query Analyzer window for Test servers.
Query Analyzer: Allows TRUNCATE Statements: Determines whether TRUNCATE statements may be executed in the Query Analyzer window for Test servers.
Query Analyzer: Allows DDL
Statements: Determines whether DDL (CREATE/ALTER/DROP) statements may be executed in the Query Analyzer window for Test servers.
Query Analyzer: Allows All Other SQL Statements: Determines whether SQL statements other then SELECT, INSERT, UPDATE, DELETE,
TRUNCATE, CREATE, ALTER or DROP may be executed in the Query Analyzer window for Test servers.
Visual Editing: Allows CREATEs: Determines whether CREATEs are allowed for objects for Test servers.
Visual Editing: Allows ALTERs: Determines whether
ALTERs are allowed for objects for Test servers.
Visual Editing: Allows DROPs: Determines whether DROPs are allowed for objects for Test servers.
Visual Editing: Allows View Properties: Determines whether Viewing Properties for objects is allowed for Test servers.
Table Data Editor: Allow Open Window: Determines whether opening Table Data Window is allowed for this server connection
Table Data Editor: Allow INSERTs: Determines whether INSERTs are allowed for objects for Test servers
Table Data Editor: Allow UPDATEs: Determines whether UPDATEs are allowed for objects for Test servers
Table Data Editor: Allow DELETEs: Determines whether DELETEs are allowed for objects for Test servers
Table Data Editor: Allow Primary Key definition changes: Determines whether Primary Key definitions can be changed for servers
|
Key Mappings - The Key Mapping section allows you to configure new key mapping profiles with new key bindings. This allows you to configure any keystroke to any action.
Here is a list of all of the default Key Map. |
Application Options - Keymapping |
| Registration Defaults | 
Application Options - Registration |
Oracle 9i/10g
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Oracle 8i
Driver Parameter: Defines Default Driver Parameter String for Server Registration
DB2 7.x
Driver Parameter: Defines Default Driver Parameter String for Server Registration
DB2 8.x/9.x
Driver Parameter: Defines Default Driver Parameter String for Server Registration
SQL Server 2000/5
Driver Parameter: Defines Default Driver Parameter String for Server Registration
SQL Server 7
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Sybase ASE
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Sybase Anywhere
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Sybase IQ
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Informix
Driver Parameter: Defines Default Driver Parameter String for Server Registration
PostgreSQL
Driver Parameter: Defines Default Driver Parameter String for Server Registration
MySQL
Driver Parameter: Defines Default Driver Parameter String for Server Registration
Generic JDBC/ODBC
Driver Parameter: Defines Default Driver Parameter String for Server Registration
|
