AQT is a fast and powerful multi-database query tool. The present version has a new function to rewrite your SQL queries. 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.
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.
Feature-rich relational database known for its high performance and excellent concurrency
