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.

• 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

• 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.

• 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

• 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