3.5.25: FEATURE: Visual Editing for Storage:
DB2 8.1: Tablespaces, Containers
Oracle: Tablespaces, Datafiles, RedoLogs, Rollback Segments, Controlfiles, Archive Logs
MSSQL Server: Databases, Backups
Sybase: Caches, Dump Devices, Database Devices, Databases
Informix: Databases
MySQL: Databases
PostgreSQL: Databases
FIX: Reading of SQL Scripts in Unicode-16bit didn't work
FIX: DB2 Schema Browser: Stored Procedure & Functions are now sorted
FIX: MS SQL Server Import Tool: If User didn't have access to any database the tool would not work.
FIX: DB2 8.1 Schema Browser: Some fix pack versions of 8.1 return the schema with padded spaces.
FIX: Oracle XMLType: Added support for XMLType. Requires xdb.jar and xmlparserv2.jar
3.5.24: FEATURE: DB2 Sequence Support: Schema Browser, SQL Scripting and Visual Editing
FEATURE: Import Tool: Allows to add a new table while importing using the column info of the imported file
FEATURE: Edit Menu: Added Redo and Select All commands
FIX: OSX: Key mappings for Redo, Undo and Select All use the Apple Key instead of the CTRL key
3.5.23: FEATURE: Visual Editing for Sequences, Synonyms/Aliases, Defaults, Rules and Data Types
3.5.22: FEATURE: Visual Editing for Indexes, Stored Procedures, Functions, Views, Triggers, Packages and Package Bodies
FIX: Added "Double Precision" as a datatype for Sybase. Visual Table Editor and Result Formatting.
3.5.21: FEATURE: Visual Table Editor: Added more error validatation
FEATURE: Visual Table Editor: Added autocompletion to the combo boxes.
FIX: Table Data Editor would hold an open transaction after a "Save Refresh" until the window was closed. Fixed.
FIX: Informix: Script Table CREATE: Default Values for CURRENT on DATETIME/INTERVAL didn't have the extended date fractions
FIX: MySQL: Table Extraction now supports PRIMARY KEY constraints for Table Data Editor, Visual Table Editor and Table Scripting
3.5.20: FEATURE: Visual Table Editing: You may now CREATE, ALTER and DROP table from the popup menu on the schema browser
FEATURE: Postgresql: Added System Views and System Functions to separate user and system objects.
FEATURE: Syntax Coloring: Added more keywords support for all databases.
FEATURE: Scripting Table CREATE now supports Default Values
FEATURE: Scripting Table Columns are now supported {CREATE, ALTER and DROP}
FEATURE: Scripting Postgresql - Script CREATE OR REPLACE FUNCTION added
FEATURE: Scripting refined to support visual editing
FIX: Informix schema browser & extraction failed to extract "char(x) not null" datatypes
FIX: Informix queries on datatypes of "datetime hour to second" failed
FIX: Informix datatime variations: formatted correctly and allowed to edit on Table Data Editor
3.5.19: FEATURE: DBA SQL Scripting: Scripting on Storage, Security and Management Objects.
FEATURE: About Dialog: Adding 3 tabs: System, Fonts and Charsets.
3.5.18: FIX: Fixed CLOB results display support for all database types. Also enabled Table Editor support for CLOB datatype on appropriate datatypes.
FIX: Informix: Scripting Trigger would script the trigger body out of order.
FIX: Query Text Results panel would turn grey after Describing a table and then executing a query.
3.5.17: FEATURE: Import Tool: Added date format preview on Option Tab and added variety of formats
FEATURE: Import Tool: Added combo box of file column names in the Table Column table or the Format Tab
FEATURE: Encoding: Added new encoding support for scripts and results
"Big5 - (Big5, Traditional Chinese)",
"Big5_HKSCS - (Big5 with Hong Kong extensions, Traditional Chinese)",
"EUC_JP - (JISX 0201, 0208 and 0212, EUC encoding Japanese)",
"EUC_KR - (KS C 5601, EUC encoding, Korean)",
"GB18030 - (Simplified Chinese, PRC standard)",
"GBK - (GBK, Simplified Chinese)",
"ISO2022JP - (JIS X 0201, 0208, in ISO 2022 form, Japanese)",
"ISO2022KR - (ISO 2022 KR, Korean)",
"SJIS - (Shift-JIS, Japanese)",
"TIS620 - (TIS620, Thai)",
FIX: PostgreSQL 7.3+ - Scripting, Auto-Completion/Automation didn't work on certain tables which had columns/indexes removed from them.
FIX: PostgreSQL 7.3+ - Scripting CREATE of a Trigger Function would fail with new JDBC driver.
FIX: PostgreSQL 7.4+ - Schema Browser - Moved information_schema.<tables> to system table folder
3.5.16: FEATURE: Added 'Window' menu which allows to show and hide the server browser, grid results and query toolbar.
FEATURE: Import Tool: Added time/performance statistics to status tab.
CHANGE: Forced the 'Auto On All Schema' settings to OFF on all databases.
FIX: Import Tool: Made demlimiter editable so any delimiter can be specified.
FIX: If only grid resuls and execution plan is enabled, then the execution plan results were always selected after execution. Fixed
FIX: Auto-Completion on SELECT statement. If a column name that ended with "FROM" was in the SELECT statement, columns after that would auto-complete. Fixed
FIX: Query results for Oracle CLOBs didn't display correctly. Fixed
FIX: Table Editor didn't allow modifications of Oracle CLOBs. Fixed
3.5.15: FEATURE: Added Data Import Tool in Tools menu.
FEATURE: Sybase Schema Browser: Added Storage folder which contains Database Device, Dump Device and Cache browser folders.
CHANGE: Connection Dialog: Changed the "Sybase 12.5 - TDS 5.5" title to "Sybase 11.x-12.5 TDS 5.5"
CHANGE: Save Results Dialog: Changed "Double quote values" check box to a combo box to specify "Quote Identifier". Values will be quoted and characters in value matching the quote identifier will be escaped.
FIX: Auto-completion wasn't working when table name or alias ended with line feed. Fixed
3.5.14: FEATURE: New and Enhanced Look And Feels: Enhanced Default 'Aqua Data Studio' Look and Feel. Added 'Aqua Data Studio - 3D' and 'Aqua Data Studio - XP' Look and Feel. Look and Feel may be changed in Option->Appearance[Tab]
FEATURE: Visual Explain Diagram: On the tree-grid results of a explain plan you may right-click on the results for a menu that allows the user to bring up a new frame with a diagram representation of the explain plan.
FIX: Visual Explain Tree: Fixed color of tree and made tree expandable and collapsable.
3.5.13: FIX: Unclosed single and double quotes in server side comments caused parser to disregard statement separators. fixed.
FIX: Execute Current was not sending Server Side Comments to the server. Comments on Stored Procedures would be lost by Execute Current on creating a procedure.
FIX: Informix 7.3: 1) Schema Brower: Removed functions and datatypes which are not supported by 7.3.
2) Trimmed whitespaces returned on object names.
3) Fixed scripting of stored procedures which didn't work on 7.3, and polished scripting of tables, view and indexes
FIX: Postgresql: Added REPLACE, RETURNS and RENAME keywords to syntax highlighting.
FEATURE/FIX: Extended "Auto on all Schemas" to include table autocompletion. "Auto on all schemas" will autocomplete on all schemas for both tables and columns.
FIX: "Auto on all schemas" - Changed default to OFF instead of ON for all databases.
3.5.12: FEATURE: Added new connection type of "Informix 7.x-9.x - ODBC" to support Informix through an ODBC datasource. Also, renamed
"Informix Dynamic Server 9.3" connection type to "Informix 7.x-9.x"
FIX: Sybase: Script Table was not scripting the "NOT NULL" section of a column correctly. Fixed.
3.5.11: FEATURE: Options -> Added support for enabling whether the schema browser displays the Server Type on the browser {Production/Test/Debug}
Option->General Tab includes a check box to enable this feature. The default value is disabled
FEATURE: Options -> Added Optional support for ";" statement separators.
Option->General Tab includes a check box to enable this feature. The default value is disabled.
3.5.10: FEATURE: SQL Server Named Instances - When registering an SQL Server you may specify in the Hostname text the name of the
SQL Server and the Instance name in the format \\ServerName\InstanceName without a port to enable an Instance connection.
NOTE: This requires the latest jTDS JDBC Driver from http://www.aquafold.com/download or jtds.sourceforge.net
FIX: Grid Formatting of Nulls - Nulls on the grid were not displaying according the the set format
FIX: Saving Results - Formats of grid results are now saved in the same manner as displayed
FIX: Sybase 11.0.x-11.4 - Fixed Schema Browser for Indexes, Constraints, Processes, which didn't display the objects.
FIX: Sybase 11.0.x-11.4 - Fixed Scripting of Tables, Indexes and Contraints - This version of Sybase doesn't support CASE statements in SQL or index_colorder() built-in function.
3.5.9: FIX: Oracle 8.0.6 doesn't support the SYS_CONTEXT() method to get sessionid, which was causing ADS to fail on results. Fixed by using GUID instead of sessionid
3.5.8: FEATURE: Results Formatting. Option dialog has formatting tab to specify the formatting of numbers and dates
FEATURE: Schema Browser Filters: Filters for Schemas/Databases and Database Objects
FIX: Changed "Sybase ASE 12.5 - TDS 4.5" text in connection dialog to "Sybase ASE 11.x-12.5 - TDS 4.5"
FIX: Infrequently the text results panel becomes grayed out and unusable, mades some changes to hopefully prevent this.
3.5.7: FIX: DB2 Visual Explain - Fixed query that retreived DB2 explain data, which was causing incorrect visual explain.
FIX: DB2 Visual Explain - Fixed retreiving of explain data resultset bug which occured in DB2 8.1 Fix Pack 2
3.5.6: FIX: Execute Explain now defaults results to the explain plan
FIX: Schema Browser Table Columns - Data type precision and scale in the schema browser columns and column autocompletion window now are formatted correctly according to CREATE TABLE syntax.
FIX: DB2 Explain Plan - fixed tree display which was not displaying the tree correctly.
FIX: Explain Plan - Added a subtree and node cost column, with the cost column including the percentage of the total cost.
FIX: Explain Plan - Prioritized columns in order of importance.
3.5.5: FIX: Fixed Visual Explain for "MS SQL Server - ODBC" connections which didn't work.
FIX: Visual Explain for Oracle - moved columns Cost, Cardinality and Bytes to beginning
FIX: Fixed "Execute Explain" for MS SQL Server which didn't work.
FIX: If there are any errors while processing Explain information, the errors are displayed in the text/message results
FIX: OSX - CTRL-Click would not open popup window as right click, but CMD-click would. Changed so CTRL-Click opens popup and CMD-Click doesn't
3.5.4: FEATURE: Support for Visual Execution/Explain Plans (with Tree-Grid results) for Oracle, DB2 and MS SQL Server
FIX: DB2 8.1 Registration: Chaned the default port text to 446 instead of 50000, which is the port the JDBC driver attempts to connect to if a port is not included.
FIX: Changed the layout manager of the Multi-Grid query results to have a better look.
FIX: Removed Unicode JDBC parameter from MySQL Connections
3.5.3: FEATURE: DB2 8.1 Schema Browser - Added "Containers" node to the tablespace node to display containers of a tablespace. Added "Management"
node to top level which contains detailed information on Connection and Lock information.
FEATURE: Added support to script objects to Current Window, New Window and Save As to a file.
FIX: MySQL Connections : Added unicode support by passing unicode and UTF-8 parameters to JDBC connection
FIX: Table Editor did not work when editing on a SELECT * FROM SCHEMA.TABLENAME. It would contruct the table name incorrectly in the UPDATE, INSERT and DELETE statements
FIX: Server Registration: Server Type and Script mount was not being saved when Registering a new server or server cloned.
FIX: Server Registration: You may now register a server even if you are not able to connect to the server. ADS will prompt the user with the message ... "A connection to this server has failed. Do you wish to register anyway?"
FIX: Informix connections do not set the username and password on connection if they are blank, to support trusted connections.
3.5.2: FEATURE: Register Server - Now able to define whether a Server is of type [Develop, Test and Production/Live], which will provide
the appropriate icon for the server in the schema browser and query windows.
FEATURE: Register Server - Ability to mount a scripts folder that can be browsed in the schema browser under the registered server,
so that scripts can be accessed easier, and associated to a specific server.
FIX: Auto-Completion now supports ansi-join syntax "table1 join table2".
FIX: Auto-Completion now supports Quoted Identifiers
3.5.1: FEATURE: Added cancel granularity in the prepare text of a query. Cancelling a query while preparing text will cancel immediately.
FIX: The Table Editor now uses the quoted identifiers and schema when generating SQL for changes, when appropriate.
FIX: MySQL table editor - Enabled ability to edit columns with the TEXT, TINYTEXT, MEDIUMTEXT and LONGTEXT datatypes
FIX: MS SQL Server table editor - Enabled ability to edit columns with the NTEXT datatypes
FIX: Introduce Value Stub values for dates and time are now the current date and time.
3.5: CHANGE: Changed Version 3.0.29 to 3.5 for Release