Contents

 
Expand About this Guide
Expand A quick start to AQT
Expand Introduction to AQT
Expand Getting help
Expand Shortcut keys
Expand Signing on to a Database
Expand Configuring a Database Connection
Expand Displaying information about your database
Expand Displaying Data
Expand Finding Data in a Table
Expand Query Builder
Collapse Running SQL
    SQL window layout
    Displaying Query Results on the Run SQL window
    Using Intellisense
    Running your SQL
    Saving and opening a query
    Other options in the Run SQL window
    Using Transactions
   Expand Using ODBC Parameters in your query
   Expand Using User-Defined Parameters in your query
    Where Clause Syntax
    SQL history
    Analysing your table
    Analyse data by grouping columns
   Expand Running multiple statements
    Including comments in your SQL
   Collapse Explain Plan
      Collapse Visual Explain
          Understanding the Visual Explain Diagram
          Navigating around the Visual Explain diagram
         Collapse Showing the query SQL
            Expand Displaying DB2/LUW Explained Packages
    Run from File
    Multiple SQL Windows
    Running a DB2 Command
   Expand Running a Stored Procedure
    Running Oracle PL/SQL or SQL Server/Sybase Transact-SQL
    Display Oracle DBMS_OUTPUT
Expand Running AQT as an unattended batch job
Expand Amending Data
Expand Exporting Data
Expand Charting
 Summarizing your Data
 Merge Table
Expand Loading Data
Expand Comparing Data
Expand Administration Component
Expand System Monitor
Expand Save Sessions
Expand Options
 Technical Notes on Options
Expand AQT scripting
Expand Technical information
Expand FAQs
Expand Troubleshooting
 Index