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 Data
• Run SQL under transactional control
• Syntax check of SQL
• Explain Plan (for DB2/UDB, DB2/390, Oracle, SQL Server, Sybase, MySQL)
• Format SQL
• Comment / uncomment lines
• Customise SQL colors, SQL keywords

• 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