Advanced Query Tool

SQL Editor

The main window for running SQL against your database.

  • type an SQL statement into the text box and click on Run (or F5)
  • build SQL with minimal amounts of typing. The bottom panes contain common SQL keywords, and the column names from your table - click them to add them to your SQL.
  • display the current values of a column by clicking on the Get Column Values button. In the example below these values are displayed in the right of the lower grids.

SQL Window functionality

This window is powerful with a lot of functionality. Use it to:
  • Save / retrieve queries
  • Single-click table and column analysis
  • Export your data
  • Chart your data
  • Summarize your data
  • Run SQL under transactional control
  • Syntax check of SQL
  • Explain Plan (for DB2/UDB, DB2 z/OS, Oracle, SQL Server, Sybase, MySQL)
  • Format your SQL


The SQL window can give you a popup list of
  • Schema and Table names (in Select, Update, Insert and Delete statements)
  • Column names (in column lists, Where clauses, Order By, Group By and Set clauses)
  • Column functions. You can get a popup list of these by typing a fullstop after the column name

These are shown in the following examples.

Show Results

You can display your query results either on a separate Data Display window, or on the SQL window.

SQL History

AQT maintains a history of the queries you have run.
  • This is saved (indefinitely) on disk between AQT sessions
  • Different history files can be used each day, week or month
  • History information includes response message plus elapsed time. This makes it easy to locate the SQL you are interested in

Run SQL Scripts

If your SQL contains multiple statements, AQT will show you the Run Multiple SQL Statements window.
  • Scripts can contain tens of thousands of SQL statements
  • Many options for the delimiter used in the SQL scripts
  • Scripts can be paused and restarted
  • Failing SQL can be corrected and rerun
  • Your SQL can display data; these can go to the same or different display windows
  Go Home Go to Top

Last reviewed on 18 May 2011   

Copyright 2002-2011 Cardett Associates Ltd. All rights reserved.