Documentation 7.0
Aqua Data Studio 7.0
1. Installation
    1.1 Minimum Requirements
    1.2 Installing Aqua Data Studio in Windows OS
    1.3 Installing Aqua Data Studio in Linux OS
    1.4 Installing Aqua Data Studio in Mac OS
    1.5 First steps towards Configuring
    1.6 Character set and Internationalization
2. Server Registration
    2.1 Supported RDBMS Servers in ADS 7.0
    2.2 How to Register a Server in ADS 7.0
    2.3 How to Edit Server Properties
    2.4 How to Copy Server Configurations
    2.5 Troubleshoot Registrations
    2.6 Tips and Tricks
    2.6.1 How to Register a Server Clone
    2.6.2 Tab Coloring to Identify Servers
    2.6.3 Using Filter Options in Registration
    2.6.4 Using Advanced Properties
    2.6.5 Permissions in Server Registration
    2.6.6 Drag and Drop Features
    2.6.7 Navigating with Short cut Keys
    2.6.8 SQL Express 2005
    2.6.9 MSDE 2000
    2.6.10 PostgreSQL SSL
    2.7. JDBC Drivers and Server Registration
        2.7.1 Oracle 8i JDBC Drivers
        2.7.2 Oracle 9i JDBC Drivers
        2.7.3 Oracle 10g JDBC Drivers
        2.7.4 Oracle 11g JDBC Drivers
        2.7.5 DB2 iSeries JDBC Drivers
        2.7.6 DB2 7.2 JDBC Drivers
        2.7.7 DB2 UDB 8.1 and DB2 UDB 8.2
        2.7.8 DB2 UDB 9.0 and DB2 UDB 9.5
        2.7.9 SQL Server JDBC Drivers
        2.7.10 Sybase ASE JDBC Drivers
        2.7.11 Sybase Anywhere JDBC Drivers
        2.7.12 Sybase IQ JDBC Drivers
        2.7.13 Informix JDBC Drivers
        2.7.14 PostgreSQL JDBC Drivers
        2.7.15 MySQL JDBC Drivers
        2.7.16 Apache Derby JDBC Drivers
        2.7.17 SQLite JDBC Driver
        2.7.18 Firebird JDBC Driver
3. Connecting to a Server (CTRL + INSERT)
4. Disconnecting a Server (CTRL + DELETE)
5. Query Analyzer - SQL Tool in ADS 7.0
    5.1 Invoking the Query Analyzer (CTRL+Q)
    5.2 Using the Query Analyzer
    5.3 Query Analyzer and its Environment
    5.4 Using Advanced Properties
    5.5 Parameterized Scripts
    5.6 Displaying Results of Queries
    5.7 Saving Query Results
    5.8 Tips and Tricks
6. SQL History (CTRL+ ALT+H)
7. Automate your SQL scripts using ADS 7.0
    7.1.1 Adding Insert, Update, Delete and Select
    7.1.2 Introduce Columns and Value Stubs
    7.1.3 Comments and Morph to Delimited Text
    7.1.4 Formatting Statements
    7.2 Auto Completion
    7.3 Aqua Commands
8. Query Builder Tool in ADS 7.0
    8.1 Using the Query Builder
9. Charting Tool in ADS 7.0
    9.1 Invoking Charting Tools in ADS 7.0
    9.2 Working with Grids
    9.3 Working with Pivot Grids
    9.4 Advanced Features of Charting Tools
    9.5 Sample Charting Demo
10. SQL Query Tuning - Visual Explain Tools
    10.1 Invoking Execution Plans
    10.2 Using Explain Diagrams
    10.3 Sample Query Tuning Demo
11. GUI Tools for Creating Database Objects
    11.1.1 Creating Tables
    11.1.2 Creating Constraints
    11.1.3 Creating Indexes
    11.1.4 Creating Views and Triggers
    11.1.5 Creating Aliases and Synonyms
    11.1.6 Creating Storage Objects
    11.2 Multi Scripting Objects
12. Tools and Features available in ADS 7.0
    12.1 How to Import Data using ADS 7.0
    12.2 How to Export Data using ADS 7.0
    12.3 Generate SQL Scripts using ADS 7.0
    12.4 Table Data Editor
    12.5 Server Script Generator
    12.6 Using Object Search in ADS 7.0
    12.7 Comparing two Database Schemas
    12.8 Using Explain White Board
    12.9 Using Execution Monitor
    12.10 Generating ER Diagrams
13. Procedure Editor
    13.1 Sample Stored Procedure
14. Function Editor
    14.1 Sample User Defined Function
15. Package Editor
16. SQL Debugger
    16.1 Features of ADS 7.0 Debuggers
    16.1.1 Oracle Debugger
    16.1.2 DB2 Debugger
    16.1.3 MS SQL Debugger
    16.1.4 Sybase Debugger
17. ER Modeler in ADS 7.0
    17.1 Notation and Normalization
    17.2 Working with ER Modeler
    17.2.1 Creating Tables
    17.2.2 Creating Indexes
    17.2.3 Creating Constraints
    17.2.4 Creating Relationships
    17.2.5 Adding Notes and Regions
    17.2.6 Saving an ER Model
    17.3 Forward Engineering
    17.4 Reverse Engineering
    17.5 ER Modeler Demo
18. Version Control in ADS 7.0
    18.1 Using Subversion Repository
    18.2 Using CVS Repository
    18.3 Tips and Tricks
19. DBA Corner
    19.1 ORACLE DBA Tools
    19.1.1 Server Statistics
     19.1.2 Rollback Manager
     19.1.3 Log Manager
     19.1.4 Session Manager
     19.1.5 Instance Manager
     19.1.6 Storage Manager
     19.1.7 Security Manager
     19.1.8 SGA Manager
    19.2 SQL SERVER DBA Tools
    19.2.1 Instance Manager
    19.2.2 Session Manager
    19.2.3 Security Manager
    19.2.4 Storage Manager
    19.2.5 SQL Agent Manager
    19.3 SYBASE DBA Tools
    19.3.1 Instance Manager
    19.3.2 Session Manager
    19.3.3 Security Manager
    19.3.4 Storage Manager
    19.4 MySQL DBA Tools
    19.4.1 Instance Manager
    19.4.2 Session Manager
    19.4.3 Storage Manager
    19.4.4 Security Manager
    19.5 DB2 for LUW DBA Tools
    19.5.1 Instance Manager
    19.5.2 Session Manager
    19.5.3 Storage Manager
    19.5.4 Security Manager
20. Compare Tools in ADS 7.0
    20.1 File Compare
    20.2 Results Compare
    20.3 Directory Compare
    20.4 Tab Compare
    20.5 Schema Compare
    20.6 Copy History Compare
21. Editors available in ADS 7.0
    21.1.1 SQL Editor
    21.1.2 HTML Editor
    21.1.3 XML Editor
    21.1.4 Text Editor
    21.1.5 Regular Expressions
    21.2 Image Viewer
22. Application Workspace and Options
    22.1 Menus and Toolbar
    22.2 Shorcuts
    22.3 Schema and Script Browser
    22.4 Details View
23. Aqua Data Studio 7.0 OPTIONS
    23.1 General Options
    23.2 Editor Options
    23.3 Compare and Results Options
    23.4 Query Analyzer Options
    23.5 Scripts and Results Options
    23.6 Visual Explain Options
    23.7 Formatter Options
    23.8 Permissions and Registration Options
    23.9 Key Mapping Options and Key Assist Tool
    23.10 Settings: Find the application settings
24. Aqua Data Studio Technical Support
    24.1 Error Logging

23.2 Editor 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.

  • Modification Logs

    Enabled: Enables or disables the Modification Logs.
    Logs Location: Indicates the directory where the logs will be stored.
    Maximum Modification Logs: Total number of modification log files kept before the oldest log is deleted.

SQL Editor

  • Abbreviations

    Abbreviaton: The combination of characters used to trigger autocompletion of the Expanded Text
    Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
    Description: User-defined description of the Abbreviation’s functionality within the code.
    Expand on: Determines the key combination that expands the abbreviation.

  • 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 Foreground Color: The foreground color for the Query Editor and results
    Editor Background Color: The background color for the Query Editor and results
    Highlighted Text Foreground: Highlighted text foreground color
    Highlighted Text Backgroud: Highlighted text backgroud color
    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
    Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
    Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
    Force Write EOL: Forces a specific EOL (End of Line)
    Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository

  • 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

  • Abbreviations

    Abbreviaton: The combination of characters used to trigger autocompletion of the Expanded Text
    Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
    Description: User-defined description of the Abbreviation’s functionality within the code.
    Expand on: Determines the key combination that expands the abbreviation.

  • 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 Foreground Color: The foreground color for the Text Editor
    Editor Background Color: The background color for the Text Editor
    Highlighted Text Foreground: Highlighted text foreground color
    Highlighted Text Backgroud: Highlighted text backgroud color
    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
    Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
    Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
    Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
    Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository

  • 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

 

  • Abbreviations

    Abbreviaton: The combination of characters used to trigger autocompletion of the Expanded Text
    Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
    Description: User-defined description of the Abbreviation’s functionality within the code.
    Expand on: Determines the key combination that expands the abbreviation.

  • 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 Foreground Color: The background color for the HTML Editor
    Editor Background Color: The background color for the HTML Editor
    Highlighted text foreground: Highlighted text foreground color
    Highlighted text backgroud: Highlighted text backgroud color
    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
    Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
    Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
    Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
    Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository

  • 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

  • Abbreviations

    Abbreviaton: The combination of characters used to trigger autocompletion of the Expanded Text
    Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
    Description: User-defined description of the Abbreviation’s functionality within the code.
    Expand on: Determines the key combination that expands the abbreviation.

  • 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 Foreground Color: The foreground color for the XML Editor
    Editor Background Color: The background color for the XML Editor
    Highlighted text foreground: Highlighted text foreground color
    Highlighted text backgroud: Highlighted text backgroud color
    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
    Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
    Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
    Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
    Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository

  • 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