|
|
|
Application Options - Aqua Data Studio has different configurable options,
which may be accessed through the Menu:File->Options command. The option dialog contiains 15 tabs: General, Table Editor,
SQL Editor, Text Editor, HTML Editor, XML Editor, Results, Query Analyzer, Scripts, 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.
|
|
| 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
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
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
Query Builder
Show Add Table Dialog at startup: Determines if the Add Dialog is display when a new Query Builder window is initially openned.
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 |  |
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.
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 |  |
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
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.
Syntax Coloring
Enabled: Determines whether Syntax Coloring is enabled
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 |  |
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
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 |  |
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
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 |  |
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
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
|
| 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.
Alternate row foreground: Alternate row foreground color.
Alternate row background: Alternate row background color.
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 |  |
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 |  |
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
|
| Results Format - Allows you to define how datatypes are formatted in the Text and
Grid results. |
|
| 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 |  |
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 |  |
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.
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.
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.
|
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.
|
|
| Registration Defaults |  |
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
|
|
