Advanced Query Tool download

v10.0 [Sep 7, 2014]
What's New
New to AQT v10
Major New Features
The Database Explorer window has a Find Objects feature. This allows you to find all objects that contain a particular name (such as a column name).
There is a new window to Load all the tables in a schema. This is built on top of the Data Loader and allows you to load all the tables in a schema in a single operation.
There is a new window to Compare all the tables in a schema. This is built on top of the Data Compare and allows you to compare a tables across two schemas in a single operation.
You can now search multiple tables looking for a particular piece of text.
The Signon window has a new look, plus makes it easy to sign onto File DSN plus Access/Excel files
Compare Objects can now generate a script to resync the objects / schemas being compared.
Other New Features
The displays in the Database Explorer can now be cached to disk. This allows for a faster startup of AQT for databases which have a large number of objects.
Compare Objects can now be run in batch.
Data Compare has had a couple of improvements:
you can select which of updates / inserts / deletes are to be included in the resync script
there is now an option Generate Updates as Deletes/Inserts. When this option is selected, AQT will update a row by deleting it and inserting a new row, rather than using an update statement. This avoids the problem whereby some rows cannot be updated due to foreign key constraints.
AQT can now Auto-Reconnect to a database if it has detected that the database connection has been closed.
The Run SQL window:
can now highlight column and table names.
when running a script, you can now set the statement delimiter at the start of the script.
has a new function to Rewrite your SQL. This is the equialent of importing your SQL into the Query Builder and back again; the SQL will be rewritten as per the options in the Query Builder.
The Data Display window:
has an option View > Use column expressions as headers. This is useful for complex queries - the column header (title) will be taken from the column expression rather than the column name.
Miscellaneous:
The Window-list buttons now display a close button. This makes it a lot easier to close windows.
There is a new Scripting command Sleep. This will cause the script to sleep for a given number of seconds, or until a particular time of day. This can be used as a basic scheduler.
You can now specify any arguments that need to be passed when using an External Editor.
You can now specify that the display tabs in the Run SQL and Query Builder windows have a "Copy to Data Display window" button. This makes it easy to copy the results to their own Data Display window.
Changes in behaviour
AQT v10 licenses now need to be Activated. This registers the use of the license on our servers.
AQT now runs under .Net Framework v3.5. This is an inbuilt part of Windows 7. For Windows 8 you may have to install this. See Installing AQT under Windows 8 for details.
Bug Fixes
In the Run SQL window:
AQT didn't recognise that a query had been changed when the backspace or delete button were hit
the Window-List button for the SQL window was sometimes blank
sometimes it hit an error when running multiple --aqt commands
Data Compare:
did not correctly write to the resync script when Append mode was selected
did not work well when the Primary Key was numeric
For DB2 z/OS:
the wrong SQL was generated when displaying a table that contained XML columns.
Table DDL sometimes had "Generated By Default" when should have been "Generated Always"
A few fixes for DB2 for LUW:
for DB2/LUW v8, the Table Sizing display failed
when generating the DDL for a DB2/LUW Stored Procedure, the text <NULL> was erroneously replaced with <1>
the DDL was incorrect for Automatic Storage tablespaces.
DDL was generated corretly for Column Organized tables
DB2 for iSeries: AQT didn't include the Row Change Timestamp clause in table DDL
For SQL Server:
Table DDL was not working
Improved the handling of Column Comments
For Oracle:
support has been added for Trigger Columns
DDL for some tables had an invalid Storage clause
The Database Explorer displays did not work for some versions of Netezza.
The Data Display window did not save the Font when Save Layout was selected.
In the Row Display window, Goto Row sometimes went to the wrong row.

v9.1 [Jun 8, 2012]
-the Data Display window:
-now has extra options when you are have grouped your data by multiple columns. Collapse/Expand just collapse/expand the top row; there are now new options View > Expand All and Collapse All which will collapse/expand all the groups.
-you can now expand or collapse all of a group by double-clicking the column name in the group-by box
-the Run SQL and Row Update windows now handle Oracle Timestamp columns better; the Use TO_DATE option will now use the TO_TIMESTAMP function for Timestamp columns.
-the scripting statement -aqt options can now be used to set any AQT option
-the Data Loader now has an open to open an Excel file in read-only mode
-Data Export can now write to a password-protected worksheet
-now has support for Materialized Query Tables in DB2 for z/OS
-a few improvements to Intellisense in the Run SQL window:
-you now have an option to disable popup of keywords when a space is hit
-when the text is empty, and space is hit, you will get a dropdown list of the common SQL statements
-the background color of the Intellisense dropdown has been changed so that it is more obvious which item is selected
-when you rename a Database tab (in the Window-list bar), this will become the name of the database in a number of windows.
-In the Run SQL window:
-took a very long time to run a large (multi thousand-line) query
-Abort button was not active when running a large query.
-in some circumstances Intellisense > Show Column Values added an excessive number of quotes around a value
-showed the wrong Intellisense dropdown when the Tab key was hit
-when a numeric value was selected from the Values list, it sometimes erroneously had quotes around it
-Copy to Data Display window failed when the query had a duplicate column name
-hitting Ctrl Shift on the right side of the keyboard switched the text into the right-to-left mode. This will now only be done by clicking on Edit > Right-to-Left mode.
-Data Compare sometimes did not return the error message when there was there was an error running the query
-In the Database Explorer window:
-Copy sometimes did not copy selected text when text was displayed in the right pane
-the View Definition (formatted) display was incorrect if the column list had a comma inside a bracket
-when the right-pane was displaying text (such as a View definition), cells could not be copied from the object-list
-when there were a large number of objects in the object-list, and a filter was applied so that only a few were visible, a number of windows (such as Generate DDL) took a long time to load. We have now added an option to deal with this problem - see Options > Database Explorer > Only show filtered objects when invoke a sub-window.
-the display of DB2 for z/OS Package Dependencies did not take into account the package version
-sometimes did not display correctly for SQL/MX
-The Data Display window:
-hit errors when clicking on the SQL button after the SQL window was closed
-Export Results failed when called from a Pivot display
-Pivot failed when the Pivot Column contains blank values
-when a result-set was copied from the Run SQL window using Copy to Data Display window, drag-over selection of cells and moving of columns did not work
-Find was sometimes erroneously re-applied when a Refresh Data was done.
-When using Table Edit, Paste as new rows gave errors with numeric or date columns.
-the Data Layout window had incorrect values for column Type after columns where moved
-The Data Loader:
-when loading from Excel, values such as 1.5 were interpretted as a date (eg. either 5th Jan or 1st May)
-hit an error when running as a script and the Create Table option was specified
-failed when loading from an Excel spreadsheet with more than 32K rows
-will now remember the Excel file type (xls, xlsx) last selected
-when loading from Excel in batch, and end row/column were not specified, it loaded only a single row. In this circumstance it will now load the entire active area of the worksheet
-sometimes failed when loading into an Oracle table in batch
-failed when running in batch and the Native Excel interface option was specified
-Data Export
-failed when Start Text was specified and Native file export was used
-when exporting a table from the Database Explorer window, it sometimes ran without prompting
-failed when Start Text was specified with Excel Native file export
-the Show Nulls as option was ignored when exporting to HTML
-Generate DDL:
-for DB2 z/OS, didn't correctly handle CHAR FOR BIT DATA
-for DB2 z/OS, an encoding of Unicode wasn't generated correctly
-for SQL Server, Trigger text sometimes changed a 'C' to a 'CN' when option Unicode > Ensure Unicode strings are in N'xxxx' format was selected.
-A few fixes for Explain.
-Explain for DB2 for z/OS window showed nothing for users which use a comma as their decimal separator
-Explain for DB2 for z/OS had duplicate entries in the Queries dropdown box

v9.0 [Apr 19, 2010]
AQT allows you to define and use Favorite database objects
Allows you to group your objects by application, or some other useful grouping.
Objects of different types can be grouped in the same Favorites folder.
Queries, charts and saved-results can be defined as Favorites.
Can add your own description of the objects.