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.
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
Feature-rich relational database known for its high performance and excellent concurrency
