Advanced Query Tool




What's New

New to AQT v9.1.3

New Features

  • support has been added for SQLite
  • when running an Export to Excel, AQT now allows you to run a macro after the export has completed. This can be used (for instance) to format the data in the exported worksheet.
  • there is now an option so that the title of the Run SQL window is the name of your table or query (as per the Data Display window).
  • The Data Loader now has an option to specified the encoding of a file being loaded.
  • AQT now has support for Unsigned integers which are used by some databases. By default this is not active. It can be enabled with Options > Technical > Support Unsigned Integers.
  • Search Table now has an option to control whether you get the "Get Values" buttons which appear when you click on a cell. Some users found they were clicking on these by mistake.

Bug Fixes

  • Database Explorer
    • The size of the panels was sometimes not saved correctly between sessions.
    • For SQLServer, uniqueidentifier columns were displayed as having a length of 0.
    • View as Query incorrectly included a bracket to the end of the last column name.
    • File > Print Right Grid did not work when the right panel was displaying text (such as View or Procedure text).
    • DB2/UDB Nicknames were given the incorrect icon.
  • Data Loader
    • When Create New Table and Drop Table before creating were specified, the table was dropped if the source table didn't exist. This could cause you to inadvertedly lose data.
    • When using Create New Table with Oracle, AQT incorrectly used a data type of DOUBLE. This should be DOUBLE PRECISION.
    • Create New Table would sometimes create VARCHAR columns with too small a length.
    • Copy cells would get an error if the right-most columns was hidden.
    • Could get error You are not connected to database when using Options > General > "Show user name as part of database name".
    • When loading a savedspec, the First Row has Column Names option would not be set.
  • The Data Display window:
    • would sometimes get an error when closing if a Row Detail window was still open.
    • Ctrl+M (with the Get More Rows feature) would give an error in some circumstances
    • would get an error if the View as File Viewer program did not exist
    • Export to Excel after you have opened a Saved Result did not format nuermic values as numbers.
    • Export was incorrectly not allowed if your connection to the database had been closed.
  • The Run SQL Window:
    • Ctrl + Shift was disabled, preventing Ctrl + Shift + arrow from working.
    • AQT would sometimes lose focus after the Find window was closed.
    • Replace All did not replace all text when Find text was selected.
    • When a line was selected, it would be de-selected when Shift was hit
    • When dragging and dropping text, it would sometimes be dropped in the wrong place.
    • can get an error in ShowContextTable when Options > "Show Column Values" has been selected.
    • in some rare circumstances, AQT would crash when retrieving the table list for a schema.
    • when text was copied into Notepad, the text had no linebreaks
    • Format SQL failed when the database had been disconnected
    • after running an --aqt load script statement, the Abort button remained active.
    • when --aqt queryparm was used, the value did not default to the previous value entered
    • History > Show Saved Results did not work.
    • would save a file, even though the user responded No to the Overwrite prompt. The Query Builder also had this problem.
  • A few problems with the Manage Table window:
    • when altering a table, the columns up/down buttons were active when they should not have been.
    • when creating a table, on the Primary Key or Index tabs the Modify button would sometimes not be active.
    • for Oracle, the Views tab was incorrectly labelled Synonyms.
  • Other:
    • AQT would always start maximized. The maximized / non-maximized state is now saved correctly between sessions.
    • The Row Detail window now sizes the Column column to fit the size of the column names.
    • Some functions (such as Export) would not release their lock on a file.
    • The Save dialog had duplicate entries for the recent-directory dropdown list.
    • Export would sometimes remove trailing spaces from a value, even though Options > Remove trailing spaces was de-selected
    • when an Oracle Stored Procedure or Trigger is created, the location of the error was sometimes incorrectly shown.
    • in the Create Trigger window the column names in the column list were modifiable when they should not have been. Also columns were not added to the text when double-clicked.
    • For European countries, Data Compare generated a resync script which used a comma as the decimal separator. A period should have been used.
    • when you save a query in the Query Builder you now get a message in the status bar (at the bottom).
    • windows could be positioned out of sight when you have multiple monitors and the primary monitor is on the right.
    • DDL for MySQL Procedures was not correct.
    • Abort did not work on the Search Tables window.

New to AQT v9.1.2

New Features

  • A number of enhancements for Oracle:
    • the Database Explorer now has support for Oracle Jobs; it will display both "old" Jobs, plus Scheduler Jobs, Programs and Schedules. These objects can be created and altered.
    • the System Monitor window will display running jobs, plus full Run and Job Logs.
    • there is now an option for AQT to use the DBA views in the Database Explorer window for Oracle (by default AQT uses the ALL views). The DBA views will display all objects irrespective of whether or not you have access to them. The DBA views are generally not publically available, so this option should only be used by people with authority to use them.
    • added support for Oracle Procedure Authorities.
    • the System Monitor now has an option to display sessions across all Instances (across multiple RAC nodes).
  • There are a few new Options:
    • in the Run SQL window, comments at the start of the SQL were removed, even when the "retain comments" option was selected. You can now choose to retain these - this can be useful for databases which allow optimizer hints preceding the SQL. See Options > Run SQL
    • you can now choose to get a popup message when a query fails in the Run SQL window. See Options > Run SQL.
    • you can now specify how much SQL is written to the History records. By default SQL statements were truncated at 20K bytes (to prevent the History file from getting too large). You can now specify this maximum SQL length.
    • you can now specify the directory to be used to hold Layout Files. By default, a layout will be held in the same directory as the query; this change allows you to hold all the layout files in a particular directory.
    • you can now specify the directory to be used to hold Report Styles - these are used by the Generate Report function of the Data Display window. This is useful if you wish to amend or add styles as the default directory (sub-directory ReportStyles of the AQT program directory) cannot be modified in recent versions of Windows.
  • Miscellaneous minor enhancements:
    • when the Enter Parameters window is resized, the Parameter Value field is now resized.
    • when you right-click a grid in the Run SQL window, you now have an option to Hide the column.
    • Selective Close now has an option to close "All Data Display windows except this".
    • the grid in the Row Display/Update window can now be sorted, though you need to enable this with with Edit > Enable Sorting.

Change to Behaviour

  • The Database Explorer display for Oracle now has Tables, Views, Synonyms as a single item in the Object Tree rather than multiple items. This makes Oracle consistent with the display for other databases.
  • There is a new Check for Updates window

Bug Fixes

  • Data Compare
    • did not correctly find the Primary Key columns for Informix tables
    • did not find the Primary Key columns when the table name was entered with a trailing blank
    • the option ignore difference in timestamp scale did not work
    • had a "function sequence error" when doing a two-pass compare of two tables in the same SQL Server database
    • failed when comparing a query which had two columns of the same name
    • the wrong number of differences was reported when two-pass compare was used
    • did not compare correctly when the primary key was a timestamp, and the compare was across databases of different types
  • Generate DDL
    • for DB2 z/OS didn't generate the ROW CHANGE TIMESTAMP or HIDDEN clauses for a column
    • for DB2 z/OS erroneously specified WITH DEFAULT CURRENT DATE when should be just WITH DEFAULT. Same for TIME and TIMESTAMP.
    • for DB2 z/OS, didn't generate INCLUDE columns for indexes.
    • for DB2 z/OS, support for Column Masks and Row Permissions has been added
    • for DB2/UDB, support for View Columns has been added
    • for DB2/UDB, Tablespace DDL sometimes had Prefetch=-1, which was invalid
    • for DB2/UDB, support has been added for ROW CHANGE TIMESTAMP columns
    • Function Text was truncated at 10,000 bytes
    • portions of Function Text inside curly brackets {} was omitted
    • the DDL window sometimes didn't remember which items had been selected
  • Export
    • didn't treat a long varbinary column the same as a BLOB. Now, varbinary columns of 1000 bytes or more will be treated as a BLOB.
    • didn't give an error message if the export failed while fetching the data.
    • in some circumstances the export window got an error when being opened.
    • several problems with Export to Excel when start/end row/col specified a smaller area than the worksheet active area.
  • Data Loader
    • when loading from Excel, some numeric values were interpretted as a date. AQT v9.1.1 had a fix for this but it did not deal with all numeric values.
    • when the TO_DATE option is used for Oracle, AQT will now also use TO_TIMESTAMP for timestamp columns.
    • the setting of "Use Native Excel interface" was not remembered between sessions.
    • in some circumstances it didn't correctly load the time part of an Oracle Date column.
    • failed when the Excel start/end row/column were blank or zeros.
    • in some circumstances, AQT would not close the query that reads the source table. For most databases this did not lead to a problem, however this can cause a SQLServer connection to be unuseable until the connection is closed.
  • The Run SQL window:
    • failed to get the column list for a SQL Server table that had multiple spaces in the table name
    • sometimes failed to get the column list for an Oracle PUBLIC synonym
    • showed keyword popup when the Tab hit and cursor was on the first column, even though Options > Show Keywords was not selected.
    • the text sometimes scrolled unexpectedly when a portion of text was selected and Run.
    • customization of the Keyword colors did not work
    • when an SQL statement failed, the elapsed time was not given
    • in some circumstances there would be an error when the window was activated
    • the window would sometimes maximize when not intended
    • Format SQL would not format a CASE statement if it was inside brackets
    • row numbers were not displayed on the grid even though Options > Show Row Numbers was specified.
    • could not right-click the grid if there were no rows displayed.
    • when an option was selected after right-clicking a column, it could be applied to a different column.
  • The Data Display window:
    • crashed if you Hide all columns
    • corrected many minor problems with Edit Data
    • could not right-click the grid if there were no rows displayed.
    • columns were displayed in the wrong order if you had more than one column of the same name and did a Refresh
    • Edit > Select Rows/Columns did not work as intended when multiple cells were selected
  • The Query Builder:
    • sometimes generated the Order By or Group By clauses incorrectly.
    • the Where Clause window sometimes didn't put quotes around character values
    • Get Values on the Where Clause window didn't clear the values list first
  • Other
    • Run Procedure sometimes got an "invalid scale" error when running a procedure with decimal parameters.
    • In the Create Procedure window, the Parameters grid would sometimes be blank.
    • The Signon window showed only a few databases if Filter Database had a blank in it
    • When re-connected to an Oracle database, the NLS_DATE_FORMAT was not set. This resulted in miscellaneous problems.
    • A number of windows opened in the wrong position when multiple monitors were being used.
    • The Enter Parameters window behaved badly when there was an error retrieving values for the dropdown list.
    • The Row Display / Update window sometimes didn't resize correctly when there was a large amount of text in the status bar.
    • Improved the resizing behaviour of the Run Procedure window.
    • In some circumstances there was an error running a DB2 z/OS Stored Procedure with a Timestamp column.

New to AQT v9.1.1

New Features

  • 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.

Bug Fixes

  • 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
    • Explain for DB2 for LUW sometimes did not show any data for the Stream query when the Display CLOBs as files option was selected
  • Other:
    • The System Monitor sometimes took a long time to load
    • Alter Table sometimes generated incorrect SQL when multiple columns were changed.
    • Alter Table for SQLBase generated the incorrect NULLS specification when a column was altered
    • Generate Text did not save the specification to the selected file
    • Run Procedure did not correctly handle FLOAT data types
    • Items were not retrieved from Run Procedure History
    • The Window-List Dropdown button on the Window-List bar did not work
    • Database Explorer window not displayed correctly for some versions of SQL/MX
    • Generate DDL was incorrect for Oracle timestamp columns
    • DB2 for iSeries did not convert Ebcdic text to Ascii in Binary columns
    • Schema Compare failed when running in batch
    • On Options > User Rights, Lock this did not work
    • when Customize Shortcut Keys was used, some menus lost their shortcut keys

New to AQT v9.1.0

New Features

  • A number of changes to the Data Display window:
    • you can now select cells by dragging-over the cells. This is similar to the behaviour of Excel and AQT v8. You can enable / disable this feature with Options > Grid Appearance > Enable drag-select.
    • you can now select the color of selected cells. See Options > Grid Appearance > Selection Color.
    • you can now select a row by clicking on the row number.
    • the grid now has a fixed-column splitter, which makes it easy to fix columns.
    • you can now specify the background colour of fixed columns. See Options > Grid Appearance.
    • you can right-click the row number to get a drop-down menu of operations you can do with rows.
    • you can now highlight rows. Any number of rows can be highlighted. This makes it easier to read rows you are currently working with.
    • you can hide rows. This is useful for removing rows from the grid which you are not interested in.
    • there is a new Menu option Grid. This contains some common operations you can do with grid columns / rows. Some functions have been moved from View into Grid.
    • Options for the Data Display window have been moved around a bit. There is now section Options > Grid Apperarance which has the options for the appearance of the grid in the Data Display window.
    • the Font used for this window is now specified in View > Amend Layout rather than Edit > Set Font.
    • Copy Cells now has options to Replace x'00' characters with spaces and to Transpose values. Transpose will copy the data with rows as columns and vica-versa.
    • Find Rows (Hide Rows that do not Match) now runs considerably faster for large tables
  • The Data Loader has new functions for making it easier to load date / time and timestamp values between databases.
  • In the Run SQL window:
    • there is now an Intellisense function for showing a dropdown list of column values. This is triggered when you type an equals sign or hit Alt+V. This should only be used when you are dealing with tables with a small amount of data. By default, this option is not active. It can be enabled with Options > Intellisense > Show Column Values.
    • there is now an option to use Right-to-Left mode for the editor.
  • Some other miscellaneous enhancements:
    • The Compare Objects window can now save and retrieve options (such which parameters of an object to compare).
    • Selective Tile and Selective Close now have an option to Tile / Close all windows for a selected database.
    • When doing a Direct Connect Signon, the file select button can be used for Excel, Dbase and Text datasources.
    • A number of improvements to the Build IN Clause window.
    • For DB2 for z/OS, AQT will detect whether New Function Mode is enabled, and use different catalog queries accordingly.
    • In the DB2 for z/OS Redefine Stored Procedure window, AQT will save the value of a number of parameters, and will restore them the next time the procedure is opened in this window.
    • AQT can now compare DB2 for z/OS databases
    • Added support for EXASolution v4.0.
    • Added support for Sybase Functions.
    • For DB2/UDB, AQT will now display information on LBACs (Label-Based Access Control).
    • Charting now allows you to specify the interval between tick points when the x-axis uses scaling. This is done with "Tick Every" on the Axes tab.

Bug Fixes

  • The Database Explorer window:
    • gave an error message when you right-click a chart and select "View in Chart window"
    • the display of DB2/UDB Range Partitions sometimes had duplicate rows
    • the display of Oracle Tablespace Sizing omitted some tablespaces
    • in Windows 7, the object icons in the grids disappeared as you moused-over a row
    • the Query Explorer sometimes showed queries in random order
    • the position of the dividers were sometimes not remembered
    • the Check Constraint query did work for Sybase IQ v15.2
    • Filter Objects was very slow when a large number of objects were displayed
    • some windows (such as Data Loader, Data Compare and Generate DDL) could not activate if already open and were in the background or minimized.
  • Export Data:
    • export to Excel sometimes failed when exporting a blank value
    • export to Excel, using Native Export, produced an empty/corrupted file when exporting a very large number of rows. We have also made changes which will increase the speed and reduce the memory consumption of this export.
    • export to Excel, using Native Export, sometimes gave incorrect numeric values for systems where the decimal separator is a period.
    • sometimes didn't export SQL Server TEXT columns to files.
  • The Data Display window
    • when there were multiple columns of the same name, AQT added a number so the column names were unique. This caused confusion to some users. AQT will now show the correct column name, even if it can be non-unique in some circumstances.
    • crashed when you refreshed a query that had parameter markers
    • failed to display some (very large) Oracle numeric values. To prevent this problem we have added a new option Display Numeric Columns as Double. When this is selected, numeric columns will be defined to the grid as the Double data type.
    • the list of Related Tables (as used by Link to Related Tables) was sometimes not refreshed when the user-defined-relationships file was changed.
    • Link to Related Tables sometimes failed when linking on a Date column, and the display format was other than yyyy-MM-dd.
    • when a column is null, Pivot columns gave the column name as "NULL 0" rather than "NULL"
  • In the Run SQL window
    • when Ctrl+Shift was hit on the right side of the keyboard, the editor switched into right-to-left mode, which made the text unreadable. AQT had to be restarted to return the window to its normal state. This was a bug in the Editor component with the new right-to-left feature. Now, Ctrl+Shift on the right side of the keybaord will still put the Editor into right-to-left mode, however Ctrl+Shift on the left side of the keyboard will return it to left-to-right mode. In addition there is an Edit menu item for changing this mode.
    • when a grid-tab was closed, focus was switched to the first tab. This has been changed so that the focus goes to the tab prior to the one which was closed.
    • Intellisense > Complete Keyword did not work.
    • When Intellisense was manually activated (by the Intellisense menu option), it was very slow the first time it was invoked.
    • Intellisense table dropdown didn't work for the second inner join in the SQL
    • Intellisense column dropdown didn't work for the second and subsequent columns in an Order By and Group By clause.
    • Intellisense had not been implemented for Teradata
    • Crashed when a Column Guide was set to 0 to 1.
    • Run as DB2 Command ran the entire SQL, not the selected text.
    • when columns were reordered or hidden, invalid SQL was created if the column delimiters were [].
    • F4 (to select the current statement) sometimes did not select the entire statement text.
    • the Build Where Clause button did not add the Where Clause to the SQL.
    • The Remove Invalid Characters function will now remove the character. MS Word will sometimes add this as a control character to indicate an "optional hyphen".
  • Explain
    • did not work for Sybase.
    • the SQL Text sometimes didn't display for DB2 for z/OS v10
    • changes to cope with the new format PLAN_TABLE for DB2 for z/OS
    • stopped with an error when SQLState 20520 was hit when running against DB2 for z/OS v10. This code will now not cause the Explain to stop.
  • The Data Loader
    • when loading from Excel, Date values came through in timestamp format (such as 2012-03-22 00:00:00). This was changed to date format (such as 2012-03-22), which is compatible with the way these values were processed by AQT v8.
    • couldn't have two [colon] statements in a load spec
    • the Date function could not handle a date of 0001-01-01. This was a limitation of the way the Date function worked. To resolve this we have introduced a new function Date2 - this processes dates differently and can handle a date value of 0001-01-01.
    • didn't correctly load Oracle columns defined as NUMERIC (without a precision or scale). These are a problem for the Oracle ODBC Driver and AQT as the precision and scale are unknown and are returned as zero. The columns can now be loaded except that the decimal digits are truncated - this appears to be a limitation of the ODBC Driver. Using the option Load using Insert statements will load the data correctly.
  • The Query Builder:
    • didn't correctly interpret a query that had a square bracket as part of a column display-name.
    • when selecting a table in another SQL Server database, the list-of-tables was blank
    • didn't handle a FETCH FIRST, OPTIMIZE FOR, WITH UR, LIMIT, TOP or SAMPLE clause in the SQL.
    • the Add Table to Query dialog did not work correctly when a different SQL Server database was selected.
    • when option always qualify table names was specified, table names were not correct for tables in a different SQL Server database.
    • changing the statement type to a Create View (on the Options tab > Statement Type) didn't work.
    • the Columns grid did not have a horizontal scrollbar.
  • The Run Procedure window:
    • did not show the procedure parameters when the DB2 for iSeries *SYS naming convention was used.
    • sometimes didn't correctly retrieve Procedure History
  • Data Compare
    • sometimes had problems comparing numeric values when a column was defined as numeric in one table and character in the other table. To deal with this we have added an option Numeric compare option to be able to specify in more detail how numeric columns are to be compared.
    • sometimes got error "Couldn't find columns for (query)" when comparing Queries.
  • The System Monitor:
    • didn't highlight warning and critical values in yellow / red as required
    • didn't indicate newly-added rows with blue text
    • Customize Display did not save changes to the display query
    • the right grid had the fields in the wrong order for some displays
  • Other:
    • some parts of AQT did not work when Windows Regional Settings were set to Turkish.
    • the Simple DDL Generator did not work when the Database Explorer was displaying Favorites.
    • generate DDL for a Stored Procedure or view truncated the text if it contained the string "ddl".
    • the Create Table dialog ignored the last column if it was still being edited when Run was hit
    • the Create/Alter Procedure/Trigger window sometimes showed a blank dropdown box as you entered text
    • in the Help file, the Find didn't work and when using Index, topics were identified as Untitled.
    • when Options>Technical>Use Parameters was de-selected, parameters were still used on the Primary Key and Foreign Key queries
    • the Abort button was not active when Get Values was clicked
    • Change View Descriptions for SQL Server did not work
    • the Search Table window sometimes got into an odd state when it was maximized.
    • Search Table > Select Date sometimes didn't format the date value correctly.
    • for some users, Save Password did not work. This was due to some character conversion functions not working correctly when non-english languages were used. To circumvent this we now have a new option Use Alternate Password Encryption; when this is selected a different method will be used to save encrypted passwords (which should work OK on non-English languages).
    • on the Chart window, Exclude data values could not be entered.
    • Extended Get Values didn't allow the user to select a table in another database.
    • Compare all Oracle Users failed with message "No List Query Defined".
    • in the Open/Save Query dialog, when you clicked the Delete File button, the file was deleted even though No was selected from the prompt.
    • didn't handle the DB2 data type CHAR FOR BIT DATA well.
    • for DB2, the Rebind Dependent Packages function didn't work when the Always Quote Table Names option was selected.
    • some users experienced a crash when opening the Options window. This was due to a component missing from their Windows install. We have hopefully circumvented this problem.
    • the config entries were not upgraded correctly for DB2 for iSeries users who upgraded from AQT v8. This resulted in errors displaying the information in the Database Explorer window.

New to AQT v9.0.9

New Features

  • 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.

  Go Home Go to Top

Last reviewed on 19 September 2013   

Copyright 2002-2013 Cardett Associates Ltd. All rights reserved.