Support for Teradata
A few improvements to Object Compare:
- you can now Save and Open the options you set on this window
- there is now an option to ignore the schema names when comparing objects
For DB2 z/OS:
- improved the display of aliases
- improved compatibility with DB2 for z/OS v10
A few improvements to Export:
- the csv export can export LOBs as files. This is useful for generating an export file to be used as input to the Oracle SQL Loader.
- you can now specify whether, once the export has finished, you are prompted to view the export file.
A few improvements to the Data Loader:
- On the Mapping tab, an Auto button has been added. This will automatically match columns between the source and target if they have the same column names.
- A new option to Replace commas with fullstops for numeric columns. This is useful when the input data uses a comma as the decimal separator. This needs to be converted to a fullstop before it can be loaded into the database.
- There are new mapping functions before and after to extract the text before/after a given delimiter.
DB2 for LUW:
- now has a function to rebind all the dependent packages of a table
- now supports the use of Row IDs (RID function). These can be displayed with Options > Display Options > Show ROWID.
- you can now delete, rename or change the type of columns.
Other:
- The Query Builder has a new option as to whether column names are to be qualified when Table Ids are blank
- In the Data Compare window, you can now type the name of a table (as opposed to using the select button)
- There is now an Option for Date columns to be displayed as character. Previously the option Use Correct Data Types for Grid columns displayed all data types as character. With this new option, you can now do this for Date columns only.
- You can now open a particular Favorites file for your database. This can be handy if you have developed a favorites file which you wish to use with a number of similar databases.
- the Run Multiple SQL Statements window will now remember the widths of columns between sessions
- the Options window is now re-sizeable

Bug Fixes

the Database Explorer window
- did not display all DB2/UDB Roles
- copy from the Detail window did not function correctly
- didn't recognize a Sybase IQ v11 database (the external name for this had changed)
the Data Display window:
- View of a LOB file did not display the file contents
- View > Hide all Null columns was not working
- occasional error when View > Hide Columns was used
- when a saved display was opened, Null values were not displayed correctly
- allowed you to close the window while data was still being fetched
- Show Lengths of Varchar Cols was not working
- the time part of a timestamp value were not displayed when the hour and second part were zero
- didn't recognize SQL Server TEXT columns as LOBs
- Bit values were not displayed correctly in some circumstances
the Run SQL window:
- didn't remember which listbox tab it opened with
- Format SQL incorrectly removed comments if Options > Remove Comments was specified
- Format SQL placed a semicolon at the end of --aqt script statements
- allowed a Start Transaction to be done when auto-commit is de-selected
- sometimes erroneously gave the message your query has changed since you opened it
- customize shortcut keys (see the View menu) was not displaying
- syntax highlighting was confused when a string value ended in an escape character (back-slash)
- syntax highlighting did not cope with a string value spanning multiple lines
- auto-scroll of selected text sometimes did not work
- the Find dialog hanged when replacing a £ character
- the Find dialog now has an option Wrap around to govern whether the search wraps to the top once it hits the bottom of the file
the Data Loader:
- didn't open a saved load specification correctly
- didn't remember the load file names in the dropdown list
- in Load-Update or Update mode, it didn't cope with an special character in the name of a primary key column
- the Load zero-length values as Null option was incorrectly done when loading from a table.
- sometimes got an index out-of-bounds error
- hit errors loading Nulls into Oracle numeric columns
Export:
- for Export to Excel, AQT didn't remember the file type (xls, or xlsx)
- some Export options were not saved between exports, or retrieved correctly with File > Open Export options
- Export to Excel left all the cells in the Excel spreadsheet highlighted
- Export to Excel, using Native Export, failed when a Worksheet was not specified
- when data was exported from a grid, Date values were formatted as per Windows Regional settings, rather than AQT date-format options
the Query Builder window:
- did not successfully reverse-engineer some queries
- now has Export as a default button on the toolbar
- sometimes generated incorrect SQL when columns were generated in lower case and Options > Always Quote table and column names was specified
- creating a new Where clause failed for a MySQL Decimal column
- generated SQL with syntax such as select 'literal, * from table which is invalid on many databases. Changed to specify the full column list instead of *.
- when Options>Always Quote table and column names was specified, tables added to the query weren't always quoted.
- changing the Statement Type on the Options tab had no effect
some problems with DDL generation:
- the Generate DDL window now has buttons Select All and Select None on the options tab. Previously the menu-bar options were confusing as to what they applied to
- didn't deal with Filter or Include clauses on SQL Server Index DDL
- incorrectly included Statistics indexes on SQL Server table DDL
- didn't deal with the syntax varchar(max) on SQL Server table DDL
- DB2 for iSeries DDL didn't generate the Encoded Vector keyword correctly
Object Compare:
- View > Only Show Differences didn't always work
- on the Results tab, when an item in the bottom right click was clicked, the wrong information was displayed in the Compare Detail window
Data Compare:
- File > Open/View Compare Options didn't save the option Generate Batch Report correctly
- when using File > Open Compare Options, the columns were duplicated in the grids
- on the Columns tab, an error occurred when Refresh Cols then Insert Entry were clicked
- the Report File was missing the information about the tables being compared
other:
- Compare Results didn't show the correct name for a window after the window-tab had been renamed
- after doing a Commit in Transaction mode, AQT hadn't included some SQL statements (such as DDL) in the count of database updates
- the Search Table window did not have a vertical scrollbar for the column names
- on the System Monitor window, applying a Filter was slow
- Drop Package for DB2 z/OS didn't enclose the package Version in double-quotes when it contained a fullstop or colon (such as was a timestamp).
- Run Multiple SQL statements did not scroll with the Run SQL window as it processed the statements
- the Row Update window sometimes did not pick up a changed value if F5 was used to run the update.

New to AQT v9.0.8

New Features

There's a new option Set pwd when select dbs on the Signon Window . This specifies whether AQT is to retrieve the saved userid / password when a database is selected and you are in Show All mode.
Support for HP Nonstop SQL/MP
Support for EXASolution
New functions before and after to Generate Text
Export Data now has an option to Replace x'00' characters with spaces. We have also changed this window to be resizeable.
In the Chart window and Query Explorer window there is now an option to show the data values for a Chart:
- in the Chart window this is done with View > Show Data Values
- in the Query Explorer window, right-click the chart and select Show Data Values.
In the Query Builder window,:
- you can now build/edit Table Expressions in another Query Builder window
- you now have an option to rename a display tab
A few enhancement to Format SQL:
- this no longer removes comments that precede the statement
- for Access and SQL Server, [] delimiters will no longer be replaced with double-quotes
- will now format sub-select statement in columns and table-expressions
- when displaying the View Text in the Database Explorer window, you can right-click and select Format SQL
You now have more flexibility with the way in which the database Name is composed. This is specified on Options > General.
The grids in the Run SQL and Query Builder window now allow you to do Show Totals (right-click the grid to see this option).
A few enhancements to the display of XML data:
- you can display XML values using AQT's XML Viewer. In the Data Display window, double-click the XML value (to see the Detail of a Data Value window) then click on View > XML Viewer.
- the Database Explorer window will now show Oracle XML Tables
- the Database Explorer window will now show DB2/UDB XSR Objects
- AQT will now successfully display Oracle XMLData values
- in the Database Explorer window, when XML text is displayed in the right-grid, you can right-cick and select Show in XML Viewer.
You can now define a Schema (or other objects such as Tablespaces) as a Favorite. AQT will dynamically retrieve the list of objects when you click on the favorite Schema. This enhancement allows you to combine both the normal Favorites display and the Objects display on the Favorties display.
You can now specify the Query Timeout for queries.
When creating Charts in batch, you can now specify that the chart is to be exported as an image file.

Bug Fixes

The Database Explorer window:
- DB2 z/OS Package Statement text was truncated at 1000 bytes
- if the column display failed, it incorrectly retained the display from the previous table displayed
- the display of DB2 z/OS Triggers had duplicate entries
- for SQL/MX, the list of catalogs was not being retrieved
- Sybase IQ Procedure Text was not formatted correctly
- the Table Access Grid did not work as intended
The Data Loader:
- sometimes gave an Excel error when closing the window
The Data Display window
- DB2 XML values were sometimes not displayed
- The Detail of a Data Value window didn't correctly display values with x'00' characters
- when editing a table, Paste as New Rows was not working
- when editing a table, Edit Data > Delete Row removed two rows from the grid.
Data Compare
- Failed when running in batch and Difffile was specified
The Run SQL Window:
- Copy GridValues to SQL sometimes erroneously gave the message "Select some cells first"
- the outline markers were confused if a Case statement was contained within a Begin End
- the Create menu often wasn't set up correctly
- crashed when Generate Query Table DDL was selected and the query was blank
- error when parsing SQL (such as when F2 was hit) and SQL had LIKE '%'
- sometimes hit an error when Extended Edit was clicked
- using Intellisense in manual mode (Alt+T and Alt+C) did not work well
Run Multiple SQL Statements
- Got an error when View -> Show Statements that failed was selected while the script was running
The Query Builder window
- The Export button did not work
The Row Display/ Update window
- had the wrong number of rows in the status bar
- when updating a table, generated columns sometimes had (auto) rather than the column value
Manage Authorities
- for DB2 z/OS Databases incorrectly specified STOP rather than STOPDB
- did not work well when invoked from a User displayed in the right grid
A few problems with DDL generation:
- SQL Server Foreign Keys sometimes did not include all the foreign key columns
- DB2 z/OS Foreign Key definition did not include the ENFORCED clause
- Table DDL for Vertica was not correct
Other
- the Signon window sometimes opened with the wrong height when the Advanced panel was displayed
- Get Values did not retrieve SQL/MX timestamp values correctly
- the Admin system windows always used a semicolon as the statement delimiter when the Preview button was clicked. This has been changed to use the statement delimiter as per Options > Statement Delimiter.
- changing the date format in batch (with --aqt options,dateformat) did not work.
- the Alter Table window sometimes did not highlight the changed rows, and sometimes incorrectly allowed values to be modified
- when a DB2 z/OS update / delete affected zero rows, AQT incorrectly indicated that this was a failed execution

New to AQT v9.0.7

New Features

There is now a 64-bit version of AQT. On a 64-bit machine you can run AQT as either a 32-bit or 64-bit application (which you will use will depend on whether you are accessing a 32-bit or 64-bit database client).
In the Run SQL and Run Multiple Statement windows there are now a Remove Comments function. This will remove the line (--) comments from your SQL.
When reverse-engineering SQL into the Query Builder, comments preceding your SQL will no longer be removed This is useful if you are using queryparm or setparm to set some parameters for your query; these will now be retained.
On the Data Display window, when you are doing Group Calculations, you now have the option for the summary row to be displayed when the groups are collapsed.

Bug Fixes

A few fixes to the Database Explorer window:
- Stored Procedures weren't being run when they were double-clicked
- for DB2 z/OS, Package Statement and Plan Statement displays were showing some garbage characters at the end of the text
- did not work well for a 1010data database
- could not copy data from the right-grid popup window
- in some circumstances a Favorite could not be deleted
- Charts now have Delete and Rename options in the Admin toolbar
- The data for DB2 z/OS Synonyms could not be displayed. This has now been improved, though you will only be able to display synonyms within your own authid.
On the Data Display window:
- Group calculations were not being done correctly when multiple levels of grouping were being used
- when doing a group calculation of a Currency column, the calculated value was not formatted as a currency value
- Edit > Find gave an error when the data was grouped
- when Editing a single-line table, the row was sometimes not updated
- Exporting data from this window failed when the data contained LOBs
- hit an error when going into Edit Mode and the database was no longer connected
- the Detail of a Data Value window sometimes failed when moving between rows/columns and these were hidden
- Pivot sometimes got error Object Reference not set
The Row Display / Update window:
- got an error when changing from New to Update modes
- improved the behaviour when pasting into a cell
- the Select Date dialog did not work well for Time and Timestamp columns
A number of fixes for the Run SQL window:
- when you selected some SQL and clicked on the Run button, AQT would run the entire SQL not the highlighted SQL (this worked OK when F5 was used to run the SQL).
- when a piece of text was highlighted and a keyword or column was added to the SQL, the highlighted text would not be replaced
- Ctrl+B didn't show the no-listbox option
- in some circumstances, got an error opening / parsing / editing SQL text
- File > Edit Keywords did not work
- when using Export to Table, clicking on click here fails
- Intellisense showed the tables dropdown, even though this option was de-selected
- Intellisense tables dropdown crashed when there were a very large number of tables
- Intellisense - the value of Max Dropdown Items was sometimes corrupted
- Unformat Data had a limit of 10K characters
In the Run Multiple Statements window:
- the Ignore Errors on Drops option was not working if there was a comment before the DROP
Data Compare:
- behaved badly if Options > Show ROWID was used
- two-pass compare did not work successfully when the key value had leading spaces
A few changes to the Data Loader:
- the grids on the Mapping tab will now scroll in sync.
- there were problems loading from an xlsx file.
- when loading from an Excel file in batch, Excel was activated once the load had completed. AQT will now behave more sensibly - e.g. close the Excel file and Excel if they were not open when the load started.
Compare Objects:
- failed when comparing Informix indexes
- copying from the Results grids has been improved
The System Monitor window:
- displayed DB2 Hit Ratios (and other % values) incorrectly
- crashed if a numeric value was greater than 2147483647
- the Filter value was not re-applied after Refresh
Some improvements to DDL generation:
- for DB2/UDB, the MDC clause was added to table DDL
- for DB2/UDB, the FOR MIXED DATA clause has been added to column DDL
- for DB2 for z/OS, when Altering a Stored Procedure the Parameter Encoding was wrong
- for DB2 for z/OS, the DSSIZE clause for omitted for a Large tablespace
- for DB2 for z/OS, the Auxiliary Index DDL had PIECESIZE incorrect
- Sybase Foreign Key DDL was sometimes incorrect
Other fixes:
- The Signon window sometimes did not save the password
- The Query Builder window sometimes dropped columns from the Group-By list
- Running a DB2 Stored Procedure with a DATE or TIME parameter failed
- Auditing got an error if the Maximum Row Length was very high.
- a few improvements were made to the behaviour of the Manage Authorities window
- some aspects of the Edit Styles window did not work well
- Extended Get Values failed if the table name contained a blank or some other special character
- Safe Update mode can now handle DB2 mass-deletes, in which the number of rows deleted is reported as -1 (unknown).
- in the Schema Compare and Run Multiple Statements windows, highlighted rows in the grids were sometimes difficult to read

New to AQT v9.0.6

New Features

You can now set File Associations for AQT. This allows you to open a number of different file types in AQT from the Windows Explorer.
You can now open an Access 2007 file (*.accdb) in AQT.
You can now customize the shortcut keys used in the Menu bars of a number of AQT windows.
You can now Insert a row into a table without first having to display the table. This is done by right-clicking a table in the Database Explorer window and selecting Add New Row.
The Data Loader can use the Native Excel interface when loading data from Excel.
On the Run SQL window:
- you can Refresh the data on one of the display grid with right-click > Refresh.
- you can now specify the position of Tab Stops
- you can set Column Guides
- there is now a function right-click > Remove invalid characters. This is useful if you are pasting your SQL from an email or Word document; these can both include odd characters that can prevent the SQL from running.
- there is a new function right-click > Copy as RTF. This will allow you to copy/paste your SQL into a word processor (such as MS Word) retaining the text colors.
For DB2/UDB, we now display Schemas; Schemas can be created / dropped.
In the Query Builder window:
- you can run your SQL against another database (see Query > Run Against).
- you can Refresh the data on one of the display grid with right-click > Refresh.
On the Signon window, you can create a New connection when in Show Recent mode. Previously, you needed to be in Show all mode.
Generate DDL now allows you to generate the authorities for sub-objects
With Auditing, you can now include the include the user's OS Userid in the audit file name by including <osuser> as part of the file name

Changes to behaviour

If auditing is selected, AQT will not run your SQL if it cannot write to the Audit file. Previously, AQT continued without writing to the audit file.
When you get an error, AQT will now display a new message-box. This has extra diagnostic information that can be useful for helping us diagnose the problem.

Bug Fixes

A number of improvements to the behavior of the Manage Authorities window.
Auditing now has more complete functionality.
On the Database Explorer window:
- for DB2 z/OS, the display of Package Statements failed
- binary columns were not being displayed correctly
- the "Display Contents (first 30 rows)" display did not give an error message if the display failed.
- for DB2/UDB, when a Package was displayed in the right grid, none of the right-click > View displays worked
- the Header-line of the right-grid scrolled up and down, rather than being fixed at the top
- Delete From Favorites did not work for a Chart
Generate DDL:
- the text of the View or Stored Procedure was sometimes truncated
- Function Authorities was missing from the DDL for DB2/UDB Functions
For batch mode
- the Exit Code (Errorlevel) was not being set correctly when AQT terminated with errors
- when the script hit an error, the online-AQT window would be shown
The Manage Tables window
- didn't create the table columns in the correct order if the columns had been moved with the Move Up and Move Down buttons
- sometimes got an error when a data type was changed
The Data Display window:
- Show Totals sometimes gave an error
- Refresh didn't work successfully if you had a Union query and some columns had been moved or hidden
- Refresh didn't work successfully if you had an * clause as part of your column list and some columns had been moved or hidden
- Copy did not copy the correct column titles if some columns had been moved or hidden
- Refresh sometimes applied the wrong Style
- sometimes did not copy a cell if there was only a single cell in the grid
- sometimes failed going into Edit Mode after Pivot had been used.
- Pivot > Show Sample sometimes got error "entry not found"
- Pivot failed if the analysis column had Null values and Tabulation was being used
- PostreSQL OIDs were displayed as Null
- in Edit Mode, an error occurred when a character value was pasted into a numeric cell
A few problems with Data Display > Link to Related Tables:
- did not give an error message if the database had been closed
- did not work when the key-column was the last column in the display
- the query SQL incorrectly used "= Null" rather than "Is Null"
- a few problems when Copy to Another Window was used: Date and Null values were not displayed correctly, the window caption was sometimes incorrect
The Query Builder:
- generated incorrect SQL when the Show checkbox on the Columns tab was de-selected
- when a New Table Expression was added, it wasn't given a name or correlation-id
- the option Save Table Positions with Query was not working
- on the Where Clause window, the Select Date window was not working correctly
- the Where Clause window did not modify IN clauses correctly
For Data Export:
- when using Export as Inserts, AQT needed to use the TO_TIMESTAMP function with Oracle timestamp columns
The Data Loader
- sometimes gave error "Control Element 1 not found" when opening a saved load-script
- the Abort button was not active while a table was being created
- the option treat zero-length values as NULL was not working
- the Preview window didn't handle Nulls correctly
- gave an error when a row was successfully loaded, but the data truncated
For the Run SQL Window:
- spaces for non-proportional fonts had the wrong width, resulting in text not lining up correctly. This has now been fixed.
- when clicking on the Chart button, sometimes got the message "invalid string or buffer length"
- a cell could often not be copied from the grids, when it was the only cell in the grid
- when the user was given the query Open/Save/Cancel prompt, it treated Cancel the same as Yes
- when running a statement to insert a LOB value, the LOB was not inserted correctly
- didn't prompt to save a query when Ctrl+D was hit
- sometimes ran the query against the wrong database, if using SQLServer/ Sybase and a Reconnect to the database had been done
- could hang (CPU loop) when F2 had been hit to parse the SQL
- when closing the window, and prompted to Save the query, the window would close even if the Save failed
- --aqt layout statement didn't work
- --aqt renamebutt statement gave an error
The Run Multiple SQL Statements window:
- would be blank if multiple statements were selected / Run in the Run SQL window
- didn't correctly scroll to the active statement
The SQL History window
- The window closed when the grid header was double-clicked
- Edit > Find found the rows in the wrong order
The Row Display / Update window
- if a cell was being edited when you moved to another row, the value being edited would remain being displayed, rather than changing to the value in the new row.
- a value would sometimes not display after being selected from the drop-down list of values
- when in Insert mode, and the Keys button was hit, all columns except the key would be de-selected
In the Data Compare window:
- Copy (in the Results grid) only copied a single cell, not the selected range of cells
- Copy did not copy the graphic (Tick, Cross) correctly
The Select Table dialog (as used by the Query Builder and other places):
- sometimes returned a table name without the schema
- failed when there was no connection to the database
- sometimes did not refresh the table-list when a new database was selected from the drop-down list at the bottom
Options:
- Uncommitted Read was not being set correctly if it was changed during an AQT session
- some Profile Options did not work as expected when these are configured differently for different SQLServer/Sybase databases
- Profiles > Profile for your current database is was sometimes wrong
- Display Options > Show ROWID did not work
- Display Format > Show Nulls As was not saved when blank was selected
Other:
- AQT sometimes crashed on termination after being connected to Oracle
- AQT sometimes didn't do a Commit after an update when Safe Update Mode was being used
- Compare Objects - the All Tables in Schema function did not work for MySQL.
- Help > Check for Updates was not working correctly
- When Altering DB2/UDB Procedures, the parameters were shown in the wrong order
- the buttons in the Window-list bar were not created when AQT was started in batch mode with mode=online
- signon to Sybase failed when the user's PC had a very long Hostname
- the Simple Compare > Compare All Tables in Schema did not have the tables in the correct order for some databases (this is the collation-order problem). This was corrected.

New to AQT v 9.0.5

New Features

You can now Export to Excel using a Native Export, which will export directly to an Excel file. The previous method involved invoking Excel, then sending commands to it. This was slow, and could be unreliable depending on state of Excel. With the Native Export:
- you do not need to have Excel on your PC to export to an Excel file
- this export runs faster than the other Excel export methods
Grid Printing has been improved so you can specify portrait/landscape, and can specify the printer.
On the Database Explorer window, when you right-click an object you now have an option to Add to Favorites. This makes it a lot faster to add objects to favorites. When you right-click a favorite object, you now have an option to Delete from Favorites.
The Run SQL window now has an option View > Show special characters to see the blanks, tabs and line-feeds in your text.
You can now customize the background color of the text-editor in the Run SQL window.
Options > Diagnostics has now an option Show Errors. This will show you any errors that have occurred during your AQT session. This can be useful diagnostic information for Cardett Associates should an error occur.

Bug Fixes

The Run SQL window:
- occasionally crashed while scrolling or moving the cursor. This may be due to a bug in the text-editor component we use. We have upgraded to the latest release of this component; hopefully this will resolve this problem.
- when running a very large script, it took a long time for the Run Multiple Statements window to open
- when using Format Data on selection range of text, some text was sometimes removed
- Export to > SQL Window failed
- the edit toolbar sometimes overlayed the text box
- when your SQL used unqualified table names, the column-list for a table was sometimes wrong
- sometimes copied the wrong object when Ctrl+C was hit
- sometimes prompted the user to save a query when it had not been changed
- Export to Table didn't handle a query which had user-defined parameters
- did not handle multiple <file> statements
The Database Explorer window:
- sometimes had problems Reconnecting to a database
- the Filter window had the wrong caption
- there was sometimes an error when a key was hit to move to an entry in the middle grid
- DB2 z/OS Package Statement text was unreadable (was not converted from Ebcdic to Ascii)
- you can now view the detail of large text cells by double-clicking the cell
The Data Display window:
- File > Generate Report failed with an error
- the wrong Layout File was used when displaying a query
- Link to Related table did not work well for a table whose key values were binary
- Find Rows > Standard failed if some columns had been hidden
- when the Get More Rows feature was used, the query SQL could not be returned to the SQL window
- did not always display binary values in the format specified in Options > Display Format
- in inline-edit mode, Ctrl+V didn't paste the data into the cell
- in inline-edit mode, did not behave well when there was an error updating a row
The Data Loader
- got message "Old format or invalid type library" when loading from an Excel file
- loading from an Excel file in batch failed with message "Object reference not set"
- when deleting the contents of a DB2/UDB table, it erroneously displayed the message "Unable to delete contents as delete command will affect entire table"
Data Compare
- gave you an error when you clicked on "Find non-matching row"
- gave you an error message when it was run in batch
Export
- some some German/ Scandinavian national characters were not exported correctly when Unicode mode was not selected
Run Procedures
- purge History appeared to be doing nothing
- could not view a DB2 XML parameter
- when the Copy to SQL Window option was used, the length of a parameter was sometimes set incorrectly
- the display of large parameter values has been improved
A few issues with the Admin Component:
- for DB2 z/OS Tablespaces, clicking on the DDL button showed you the Alter Tablespace window
- for DB2 z/OS Tablespaces, "DDL for all Databases" only showed you the tablespaces in the current database
- error altering the pagesize of a DB2/UDB Tablespace
- error doing a Preview from the Create Stored Procedure window
- did not generate Foreign Key DDL correctly for DB2/UDB
- errors starting the Create Table window for SQL Server
- some admin windows didn't allow you to add rows to the grid
- the Rename Table function incorrectly showed the Rename File dialog
- in the Alter Procedure window, the Abort button was not active when the Edit in External Editor function was used
The Query Builder:
- sometimes positioned new tables out of sight behind existing tables
- when there were multiple Where clauses, the order of these clauses was sometimes incorrect
- on the Where Clause window, Get Values sometimes retrieved the values for the wrong column when the "Only show cols which are in the query" option was used
the Options window:
- did not allow a Display Format of HH:mm:ss
- had an error when changing the read-only mode setting
Misc
- AQT behaved more sensibly for a user for which the AQT install had not been run, and for a non-admin user
- Get Values did not work when the table name had spaces, minus signs or other special characters
- Compare all tables in schema did not show you the compare-columns window when you clicked on a table
- a few improvements to the behaviour of the Search Table window
- when running in batch, AQT erroneously gave a message that a trial version of AQT v9 was being used

New to AQT v9.0.4

New Features

in the Run SQL window
- there is now an option (View > Display Multiple Grids) to specify whether you want multiple Data Grids displayed.
- there is now a function View > Clear all grids to clear all the existing display grids.
- you can now rename a grid-tab
- you can right click a display grid and select Revert to this SQL. This will change your SQL back to the SQL that was run to display the data in this grid.
- there is now a shortcut key for Format and Unformat (Alt-F and Alt-U)
there is now a script statement for setting the Max Rows Displayed
the bottom part of the History window is now sizeable
there is now an option for AQT to run a commit after every statement. This is useful in some environments in which AQT doesn't fully release locks.

Bug Fixes

The Database Explorer window
- was slow to load as it retrieved the list-of-schemas twice
- sometimes didn't display column information for Sybase tables
- didn't display DB2 package information
- didn't display columns for a DB2 for iSeries SQL Procedure
- when you right-clicked an object in the right-grid, Next and Prev sometimes did not work
- the Filter box now gets (slightly) larger as the screen is resized
- Help > Database Details sometimes got error "Form that is already visible cannot be displayed as a modal dialog box"
In the Run SQL window:
- there was sometimes a severe error while scrolling to the end of the SQL
- Format SQL and UnFormat SQL failed when there was no connection to the database
- sometimes the status-bar became too high if it was displaying a large message
- sometimes got an error while running a large script
- AQT failed when running SQL containing unicode characters and Options > Unicode > Use Unistr option was selected
- a lot of CPU was used when editing a large amount of text
- Get Columns for Table (F2) did not always work when a table name was unqualified
- files with German characters were not saved or retrieved correctly
- Intellisense popup of table-list did not work for DB2 for iSeries
- output from the Sybase / SQL Server Print statement was not being displayed
- sometimes got an error when activating the Run SQL window from the Query Builder
- a query could not be aborted prior to it retrieving 1000 rows
- the Open/Save window sometimes did not set the directory box to the name of the directory being displayed
On the Run Multiple Statements window:
- the grid did not have line numbers
- the SQL was not displayed well when it contained blank lines or comments
On the Data Display window:
- Inline Edit sometimes did not update a row if only the current cell was changed
- Only show rows with this value did not work for Oracle Synonyms
- German characters were only displayed correctly when Unicode mode was selected
- Compare To Saved Results did not always work correctly
- when copying a date value from the grid, the copied value would have a different date format
- error selecting multiple cells or selecting a column when the data was grouped
- there were a few problems with creating new user defined relationships
- the Abort button was disabled if doing a Refresh and the Linked Table panel was shown
On the Row Update window:
- DB2 Time values were not displayed correctly
- Extended Edit incorrectly retained the list of values from the last time the form was displayed
Export
- when this was run from the Data Display window, it didn't work well if the columns were moved or hidden
- PCs defined with a non-english locale got error "Old format or invalid type library"
For batch scripts:
- when mode=online specified, AQT terminated as soon as it started
- failed to run SQL statements which were spanned over multiple lines
With the Data Loader
- saving a load spec failed with invalid file name
- opening a load spec sometimes failed
- failed to load an Oracle date value when Insert Using Inserts was specified
- failed to load columns which had a REAL data type
The Run Procedure window:
- failed when a Parameter was a CLOB or BLOB data type
- Retrieve from History was not working
A few fixes to Options:
- Always Quote Table and Column names was not working
- Display multiple result-sets in the same window was not working
- change to the Date Format did not have any effect
Other
- sometimes scroll-bars were displayed, which disappeared once they were clicked
- there was a problem whereby multiple clicks were needed on the AQT window-list bar to activate a window. This was due to the tooltip sitting on top of the button. This is a known (Windows) problem with the way this tooltip is positioned. We have circumvented this by not showing tooltips when the window-list bar is positioned at the bottom of the AQT window.
- after adding a new column to a table, AQT sometimes showed the old column list for the table. This is due to AQT's table cache, which is needed to avoid repeatedly getting column information for the tables. This problem can be avoided by using a new function Tools > Reset table/index cache (from the Database Explorer window) which will reset this cache.
- the Create Table window sometimes did not convert data types correctly when copying the table definition from a different database type
- when generating DDL for DB2 z/OS indexes, an error message was given and the index columns were omitted
- the Query Builder didn't enclose table or column names in quotes when this was required
- the History file name did not replace ww with the week number
- History was not written from the Row Update and some other windows
- On the Signon window, Prompted Signon failed
- the System Monitor sometimes got an error displaying SQL text in the lower panel

New to AQT v9

AQT v9 is a significant redevelopment of AQT in the .Net environment. This gives AQT a modern platform; this provides a number of benefits plus will allow AQT to progress into the future.

Some of the new features of this release are described at AQT v9.

As part of this change, we have implemented:

a new grid component. This has a number of differences in behaviour, which are outlined in the following section.
a new text-editing component. This provides a number of extra features, principally the ability to show a drop-down list of table names, column names, column functions or keywords when you are building a query in the Run SQL window.

Changes to Behaviour

The new grid component behaves differently than the grid used by AQT v8. For an description on how to use the grid, see Grid usability concepts. Differences with the v8 grid are:

Selection. Cells can no longer be selected by dragging the mouse over cells. Instead you must click a cell, hold down Shift then select a second cell. All the cells between the two clicked-on cells will be selected.
Hiding Columns. In the Data Display window, columns can no longer be hidden by dragging them "away". Instead, you must right-click the column and select Hide Column.
Ungrouping Columns. In the Data Display window, you can group by a column by dragging the column to the group-by area at the top of the grid. This works the same as with AQT v8. To remove a column from the group-by area, drag it to somewhere outside the group-by area. The column will have a cross, which may indicate that you are dragging it somewhere invalid; however once you drop the column it will be removed from the grouping.
Moving Rows. The grid doesn't have any in-built ability to move rows. In places where you need to do this, there will be buttons Move Up and Move Down.
Filtering. Filtering is used when you use the filter box, or in the Data Display window when you use Edit > Find. Filtering is slow, so should be used with caution when you have a large amount of data.

New features of the new grid component are:

Styles. You have flexibility of the style used for displaying your data. You can select between a number of in-built styles, or create your own.
Column Totals. On the Data Display window, you can now get totals for numeric columns by clicking on View > Totals (Ctrl+T) or the Totals toolbar button.
Printing. The grid has two different ways of printing the data - Print Data plus Generate Report. Print Data is a a basic print of the grid. The data Display window also has Generate Report, which gives more flexibility and styles of the printed data.

New Features

New Appearance. Some of the windows have a slightly new appearance. The Database Explorer window, in particular, has had a number of changes to improve readability and functionality. This is described at Customizing the appearance.
When you right-click an object in the middle grid, the dropdown now gives a more comprehensive set of options. You can go back to the v8 style of dropdown with View > Simple dropdown menus
Charting. This is a major new feature, which allows you to create charts of your data. Once a chart has been created, it can easily be saved and reapplied to your data at a later time.
Summarizing. There is a new window to make it easier to develop Summary queries on your data.
New Text Editor component. We have implemented a new Text Editor, which is used by the Run SQL window, and the Manage Procedures and Manage View window.
- this is component has Intellisense, which is the ability for AQT to display a dropdown list of tables, columns or function names as you type.
- when writing Stored Procedures, Begin / End blocks are marked and can be collapsed
Multiple Results on Run SQL and Query Builder Windows. Both these windows will now show multiple query results in a tabbed display at the bottom of the window.
Pause Query. When AQT is displaying the result of a large queries, you can Pause and Resume the display. This is an alternative to the Get More Rows feature.
Where Clause window. This window has a number of enhancements:
- it is simpler and easier to use
- it can now build sub-selects, including correlated sub-selects
- it can now build an IN clause
- it can be invoked from the Run SQL window with Ctrl+W

Options

We have made a lot of changes to the way Options are stored. This provides a number of benefits:

Options can be exported and imported. This allows Options to be saved and moved between machines
you can have different options for different databases and database types
it is now much easier for system administrators to set a fixed option which cannot be changed by the end user

As a result of these changes, most options are now held in a different part of the registry than the v8 options:

when you run AQT v9 for the first time, the v8 options will be migrated to the new v9 options
after this point in time the two sets of options are separate. If you change an option in AQT v8, it will not be reflected in AQT v9 (and vica-versa).

Minor Enhancements

External Editor. You can now use an external editor other than Notepad. The editor to use is specified in Options > General.
Note that, in the Run SQL window, the Edit SQL using Editor function now works slightly differently. In the past it waited until the editor program ended. Now, you click on the Abort button for AQT to get the updated-SQL back from the editor.
Query Builder. This now allows you to specify (simple) Where clauses on the Columns tab.
As with the Run SQL window, you can now display query results on this window. This feature is turned on/off with View > DIsplay query results on this window.

You can revert back to an earlier form of your query by right-clicking one of the query-results and selecting Revert to this query. This provides a basic undo capability for the Query Builder.

Some Technical Things

AQT now has:

Improved multi-threading. AQT can now run more than one query at once, plus has improved ability to cancel queries. The AQT Cancel Queries task is no longer required.
Note that AQT can only run a single query from each database connection. Most ODBC Drivers do not allow a single connection to run more than one query simultaneously.
64-bit support. AQT will have the ability to run as either a 32-bit application or as a 64-bit application. There will be separate AQT executables for each of these. This is important if you have 64-bit database clients. For more on this see Installing AQT on a 64-bit version of Windows.
Note: the 64-bit version of AQT hasn't yet been completed.
Full unicode support. Previously, there were some items (such as window captions and status bars) which were unable to display Unicode characters.

Last reviewed on 31 October 2011