Sui Changelog
What's new in Sui 0.71C
Jan 3, 2015- Changes:
- Lob query - The Blob Query introduced in Sui 0.71B is renamed to Lob Query. The function is extended to also support CLOB’s (Character Large objects).
New in Sui 0.67E (Jun 25, 2013)
- New Features:
- Four different type of code completion is available
- Introduced possibility for Shorthand completion (F1) (Including SQL Keywords)
- Introduced possibility for Schema completion(F2)
- Introduced possibility for table completion(F3)
- Introduced possibility for column completion(F4)
- Added profiles for connection parameters (right click in Connection pane).
- Save data to Apache Derby (Makes it possible to a save A result-set direct to an Apache Derby database) (Requires Derby to be installed).
- Append Query result-set to an existing tables
- Create standard DDL for creating a table based on a result set
- Minor changes and bug-fixes:
- Excel import now allows for import of insert statement to file (or as before to clip board)
- Removed limit of 200 columns for Transpose on value
- Limited field length in report window to avoid overflow for very large columns
- Moved sui data path and look and feel settings to Misc. settings
- Added a file chooser with an icon to the data path selection
- Changed font to COURIER for Excel spreadsheet
- Added Auto-size for Excel spreadsheet
- Added direct jump to Query-box-viewer by right-clicking the Query-box
- Cleaned up some of the start-up messages.
- Changed the way pass-words are remembered within a session.
- Added a property to make it possible to load all drivers at startup
- Fixed some issues with decimal values with large number of decimals
- Fixed a bug in query-box viewer search, The search function didn't handle the first character correctly
- For users connecting to DB2 using the IBM's universal JDBC driver, SQL-errors now have a fuller error description
New in Sui 0.65D (Nov 3, 2010)
- Sheets introduced to the query window. To make it easier to manage multiple set of queries sheets has been introduced to the query window. Each sheet can contain a separate set of queries that can be executed and managed individually
- Adding URL’s from “Manage JDBC resources” now prompts the user for connection properties.
- Other enhancements:
- Changed so that MaxRows is ignored when Maxrows is set to 0
- Added possibility to disable / Enable syntax highlighting
- Substitution variables are now kept between sessions
- Increased size of the preference panel
- Re-structuring of content in preference panel
- Added possibility to re-execute a query from the Show SQL panel in the report panel.
- The show sql and query log now shows the sql after symbolic resolution.
- Increased the maximum number of entries in the query monitor from 20 to 100
- Preference "Connection vars for each sheet" makes it possible to save connection info for
- each sheeet.
- Function to import a specific Excel sheet for Excel Import added
- Uid / Pw is not supplied at login if uid and pw is an empty string
- Variable substitution not active when BATCH=YES specified (Exec->Insert Stmts)
- Removed blank line when exporting to CSV
- Highlight automatically disabled opened query text > 2000 bytes.
- Bugs fixed:
- Fixed a bug relating to copy and paste from the query context menu
- Fixed a couple of minor bugs related to connection management
- Fixed a bug in the application concept
- Fixed a data type mapping to handle smallint correctly for stored procedures
- Fixed a bug so that the querybox now is consistently populated