May 9, 2008 - version 3.5.9 available. Release Notes

General Notes:

The latest available Java Version is 1.6.0_04. Windows users must download the product to get the latest Java. The latest Library Version is 3.1.5.

Version: 3.5.0 - Released: 12-18-07 - Enhancements and Fixes.

Enhancements:

• Layouts - Add ability to remove individual field visibility in Filter.
• Layouts - Add ability to restrict individual field visibility
• Layouts - Add ability to restrict individual field visibility in Filter
• Layouts - Add ability to restrict individual field editablity
• Layouts - Add ability to Duplicate a layout.
• Layouts - Add Ability to specify specific Duplicate Layout authorities.
• Layouts - Modify Layout - Add Select All Deselect All to check box columns
• Recent Files - Add a list of recently opened files to various File menus.
• Export Spooled File Specification Wizard - Display message for no records found.
• Preferences - Add Spooled File Export preferences.
• SQL Editor - Save As Member - Add ability to specify description and type.
• Calculator - Add paste ability.
• Messaging - Add ability to EXPDTA and IMPDTA to throw escape message for member not found error. (Update Server 3.1.2)
• File Editor - Use default values in Add mode.
• Layouts - Add Authority menu item.
• File Editor - Add tool tip field information to Modify Layout screen.
• Stored Procedures Edit - Add option to drop procedure based on SQL0456 message.
• Stored Procedures - Show SQL - Generate SQL for comments also.
• Stored Procedures - Add better support for Java procedures.
• Stored Procedures - Add DB2SQL parameter style.
• File Properties - DBR - Add key field description column. (Update Server 3.1.3)

• Print Preview - Fix some sizing issues when using Compress Columns.
• SQL Editor - Fix length of tab in Save member when using Syntax Coloring.
• SQL Wizard - Fix disappearing Where clause.
• File Editor - Fix problem when default values are less than 1 but greater than zero.(Update Server 3.1.1)
• File Editor - Make logical not editable if physical not editable.(Update Server 3.1.1)
• Check for missing LucidaTypewriter Fonts at start up.
• SQL Editor - Fix miscellaneous parsing errors.
• File Editor - Fix problems with disabled color in Metal look and feel.
• File Editor - Don't allow mass replace of protected column.
• Stored Procedures External Edit - Fix SQL0455 message by qualifying specific name.
• Stored Procedures - Show SQL - Select correct system.
• Stored Procedures Edit - Fix SQL0455 message by qualifying specific name.
• SQL Editor - Fix not being asked to save upon exit after opening a script when Syntax Coloring is on.
• Export SQL Results - Instead of error, export date as null when date format in connection is MDY and date is outside of valid MDY range 1940 to 2039.
• EXPDTA - IMPDTA - EXPSPL - Fix problem with some messages not be thrown when using USEMSG parameter. (Update Server 3.1.3)
• Default Value - Support Default Value of None. (Update Server 3.1.3)
• EXPDTA - Allow query to have a length greater than 256 characters. (Update Server 3.1.3)

Version: 3.4.0 - Released: 9-05-07 - Enhancements and Fixes.

Enhancements:

• SQL Editor - Upon error select position error in statement.
• SQL Editor - Add syntax coloring option.
• SQL Editor - Add option to clear log before executing.
• SQL Editor - Add option to stop executing multi statements upon error.
• SQL Editor Results - Make field viewer only modal to window.
• SQL Editor Results - Add ability to right-click and copy data.
• SQL Editor Results - Add button to view current SQL if too long.
• SQL Editor - Place currently executing SQL statement in status bar.
• SQL Editor Prompt Columns - Add system field name.
• SQL Wizard - Add ability to view the SQL statement as it is being built.
• SQL Wizard - Can now go back to the table selection screen after selecting columns.
• SQL Wizard - Table Selection - Allow user to select *LIBL and *USRLIBL.
• SQL Wizard - Table Selection - Multi-select files with mouse.
• SQL Wizard - Table Selection - Add file description tool tip.
• SQL Wizard - Improved join SQL.
• SQL Wizard - Add ability to use AS for file names.
• SQL Samples - Add find text ability.
• SQL Samples - Add syntax coloring.
• SQL Samples - All sample and editor window to be open simultaneously.
• Stored Procedures Execute - Add Reset value button.
• Stored Procedures Results - Add button to view parameters.
• Create - Alter Table - Add ability to allocate lengths for appropriate data types.
• Create - Alter Table - Generate SQL - Add encoding for appropriate data types.
• Create - Alter Table - Generate SQL - Add/improve rowid support.
• Create - Alter Table - Generate SQL - Add/improve null default value support.
• Generate SQL - Add option not to generate library.
• Field Viewers/Editors - Add ability to search.
• Field Viewers/Editors - Make word wrap optional.
• Field Viewers/Editors - Add row/column identifiers to title bar.
• Field Editors - Add ability to search and replace.
• Field Editors - Add ability to undo redo editing.
• User Access - SQL - Add logging.(Update Server 3.1.0)
• Layouts - Add Last used time stamp and user. Add created time stamp.(Update Server 3.1.0)
• Messaging - Give optional ability to EXPDTA, IMPDTA and EXPSPL to throw
  escape messages upon failure. Must use USEMSG(*YES).(Update Server 3.1.0)
• Text Editors - Make text editor behavior uniform.
• SQL Table components - Make behavior uniform.
• FTP Log viewer - cascade windows when opening multiple logs.
• IFS - Add ability to work with files that begin with a period.
• Triggers - Add trigger properties.
• WDSC Plugin - Add support for WDSC 7
• Export Spooled File - Add ability to change leading.
• Field Properties - Add support for ROWID columns. (Update Server 3.0.9)
• Layouts - Prompt Filter - Add Field Description column.
• Delete - Add ability to delete *MSGQ and *PNLGRP objects.
• Members - Allow multi-selected members to be used in FTP functions.
• FTP Log Viewer - Open View Field box upon double-click.
• FTPOBJ - Add restore member option - parameter RMBROPT. Useful when member names
  of an existing target file do not match the source. (Update Server 3.0.6)
• FTPOBJ - Increase maximum objects selected from 10 to 100, and maximum members
  selected from 10 to 50. (Update Server 3.0.6)
• FTPF - Increase maximum objects selected from 10 to 100. (Update Server 3.0.6)
• EXPDTA, EXPSPL, IMPDTA - Add redirect log output - parameter REDIRLOC. Allows
  log file to be directed to an IFS file or an OUTQ. Works in conjunction with
  the OUTPUT parameter. (Update Server 3.0.6)
• Command Line Option- Add ability to run iSeries commands from a command script
  using the -runcommand or -runcommandprompt arguments.
  

• File Editor Filter - Fix incorrect format being used in filter when new format selected.
• Layouts - Generate Script - Surround system names that contain spaces with double quotes.
• File Editor - Field properties - Select correct format instead of first format.
• File Editor - Filter - When filtering a file with a record length
  between 1009 and 2032 in view only mode, the incorrect number of
  records may returned due to a blocking factor problem. IBM may fix
  this via PTF, in the meantime we calculate the blocking factor.
• Layouts - Allow Surveyor Administrator to delete layouts with
  corrupt authority records.
• Layouts - Fix problem when user without 'Public Layout Authority'
  creates layout. (Update Server 3.0.9)
• File Groups - Allow user to choose a different system when saved system
  is not found.
• File Groups - Show error messages when loading files, and give user option
  of removing files in error from group.
• Import - Fix SQL0206 error when first field in specification is excluded.
• Export Database - Fix bug when excluding all but one field.
• Layouts - Generate Script - Surround layout names that contain spaces with double quotes.
• Generate DDS - Fix column headings and text not being generated for files
  that have reference file when 'Reference Data' box is unchecked. (Update Server 3.0.8)
• Field Properties - Fix incorrect length for complex types. (Update Server 3.0.8)
• SQL Generator - Fix incorrect length for complex types. (Update Server 3.0.8)
• File Editor - Recognize a field when it is renamed but original name is
  specified as key. (Update Server 3.0.7)
• Long file names - Fix long file names not appearing on various screens.
  (Update Server 3.0.7)
• Import/Export - When opening specifications on the client, look up by system name
  current IP address, user name, and password as opposed to using what is saved.
• SQL Editor - Allow Common Table Expressions under the 'Allow SQL' authority setting.
• FTPOBJ - Allow FTP 550 errors that contain successful restore messages to have a
  status of Finished instead of FTP Error. (Update Server 3.0.6)
• Export Fixed Width - SQL Results - Fix SQL error when next button is pressed.
• Export Fixed Width - Only reset field lengths if file changes when next
  button is pressed.
• WDSC Plugin - TN5250 - Fix key mappings not being saved.
• EXPDTA - Fix Fixed Width exports ArrayIndexOutOfBoundsException error.
• Export Database - Fix member not being replaced correctly when target file
  is on a different system than the source file.
• Export Database - When source file contains more fields than target file,
  give user option to exclude orphaned fields.
• SQL Editor - Fix library list field text being initialized to 'SURVEYOR' instead
  of saved preference when changing systems.

Version: 3.3.0 - Released: 8-31-06 - Enhancements and Fixes.

Enhancements:

• Export - Consolidate all Exports into Export Wizard.
• Export - Export to another database file.
• Export - Add column headings option for first row exported.
• Export Excel - Add option to bold column headings.
• Export - Add option to open exported file.
• Export - When exporting to Clipboard add ability to select a format.
• Export - File Editor and SQL results - Add ability to export with any delimiter.
• Export - File Editor and SQL results - Add ability to export in fixed width and XML.
• Import - Distinguish between warnings and errors.
• Import - Excel - Allow user to select a sheet.
• Import - Excel - Support basic formulas.
• Import - Add ability to match source and target fields by name.
• Import/Export - Add IASP support for EXPDTA and IMPDTA commands.
• User Access - Add 'Export Layout' authority that will allow users without Object Access to still export layouts.
• User Access - Add 'Export to Database' authority.

• User Access - Changes to Data Transfer logs will be immediate when the change is being made to the Administrator's currently connected user id.
• Generate DDS - Fix bug when references file not found. (Update Server 3.0.5)
• Generate DDS - Add support for allow null and alias. (Update Server 3.0.5)
• IFS Properties - Fix not available messages when IFS file has more than 16 authorized users. (Update Server 3.0.5)
• Object Search - Allow Object:*ALLUSR Library:QSYS or *LIBL Type:*LIB. Allows user to get a list of *ALLUSR libraries. (Update Server 3.0.5)

Version: 3.2.0 - Released: 3-15-06 - Enhancements and Fixes.

Enhancements:

• Added Edit Authority feature.
• Added Remember Window Size feature and preference.
• WDSC Plugin - Add Edit Authority. Version 1.2.3.

• TN5250 - Fix 'Key not allowed' error in Field Exit Required fields.
• TN5250 - Fix problem of lock up in 27x132 mode due to too many fields.
  
• TN5250 - Process control characters that cause some menu type fields not
  to appear.
• TN5250 - Fix data appearing in wrong place due to insert cursor conflict.
• TN5250 - Fix not all data being cleared in 27x132 mode.
• File Editor Filter - Fix 'Not' symbol character set incompatibility.
• File Editor Filter - Fix Filter not cleared when file is closed.
• Layouts - Fix problem of some elements of filter not being saved correctly
  after filter has been reset.
• Fast Path - Fix history read location.
• Install - Fix reconnect on some installs.
• WDSC Plugin - Fix File Editor not being launched from File Properties Main
  menu. Version 1.2.2.
• WDSC Plugin - Fix possible incorrect file attribute when a valid attribute
  appears in the objects description. Version 1.2.2.
• Spooled File Specification - Fix Margin and Auto Size not being populated
  in the Wizard.
• Procedure Properties - Fix problem of Procedure Properties, Edit and Copy
  features not working when specific name is different from routine name.
• Preferences - Moved 'Preview Display Count' to System section.
• Remove *ADMIN user when QSECOFR installs. (Update Server 3.0.3)
• FTPF - Get member name when *FIRST specified for client member. (Update Server 3.0.3)
• SFE - Add Layout Owner. (Update Server 3.0.3)

Version: 3.1.0 - Released: 12-08-05 - Enhancements and Fixes.

Enhancements:

• Layouts - Add ability to generate a script which can open a layouts without
  opening entire application.
• Export Layout - Export column headings or custom column headings, depending on the Layout's Name/Description property.
• WDSC Plugin - Add ability to edit data areas.
• WDSC Plugin - Add ability to display IFS file properties and permissions.
• Add ability to control Java output on EXPSPL, EXPDTA, and IMPDTA commands.
• Spooled File Export - Text files - Add ability to replace form feed with ASCII form feed.
• Export Wizard - Add ability export using Unicode encoding.
• Install - List administrators if user is not an Administrator.
• Optimize icons.

Fixes:

• WDSC Plugin - Fix incompatibility with WDSC 6.x
• TN5250 - Device names were not being retrieved correctly when preferences are stored in User Folder.
• Native Import and Export - Specify date format property on JDBC connection. Newer JDBC drivers are more sensitive to this property.
• User Access - When adding a new user. If the new user is in a group, and Modify Library List is checked, prompt user to copy the group's library list.
• Fix authority error when adding certain users to a group.
• Fix new users library list not being initialized with *NEWUSR's library list.
• Export logging - Log File Editor exports made by using Export Selected Records and Export Page
• Export Layout - Prompt user to fill in Prompt field values
• File Editor - Position - Do not trim leading spaces in Position dialog.
• File Editor Filter - Allow user to leave prompt field empty.
• File Editor Filter - Allow user to Run Filter, if they don't have Modify Filter authority.
• File Editor - Fix quirky select and right-click behavior of RRN fields.
• Client Update - Fix problem of some non-Windows platform not getting update due to missing folder.
• Import Excel - Fix problem of Crystal Reports created spreadsheet not importing.
• System Properties - Fix IFS version displayed as 3000.
• Update Server Library - Display better message for empty update.

Version: 3.0 - Released: 09-09-05 - Enhancements and Fixes.

Enhancements:

• User Access - Add ability to place users in a group.
• User Access - Add Object Access.
• User Access - Add Last Log On time stamp.
• User Access File Editor - Add Public Layout, Add, Change, Delete and Undelete authorities.
• User Access Spooled Files - Add Manage and Export authorities.
• Layout Security - Add ability to assign authority to individual layouts.
• Layout - Add Layout Properties.
• Layout - If the format id of the file has changed since the layout was created, the user is shown the differences and is given the opportunity to adjust the layout.
• Layout - Added option to open layout without the using the saved filter.
• Layout - Added option copy and rename.
• File Editor - Add Layout name to title bar.
• File Editor Filter - Add promptable filter fields. User will be prompted for input when the filter is executed.
• File Editor Filter - Added cancel button to revert back to previous filter before Filter window was opened.
• File Editor - Retain filter when changing member.
• File Editor - Add ability to set authority when using Save Layout As.
• Password protection - Improved password protection.
• Delete Database Objects - Delete multiple database objects from main window.
• Generate DDS - Add GENDDS command to generate DDS for multiple files.
• Configure - Add ability to change order of systems.
• SQL Editor Column Prompt - Add ability to sort and find in column prompt window.
• Changed monospaced font to a font which can more easily distinguish the letter O from the number zero.
• Delete objects/members - Made result message box scrollable.
• Add option to check for major upgrade on IFS.
• Delete Members - Add ability to remove multiple members from main window.
• FTP iSeries - No save file transfer - Add ability to specify transfer types ASCII, EBCDIC and Binary.
• FTP iSeries - Save file transfer - Add better error handling for save and restore operations. Must be installed on target system for restore messages
• FTP iSeries - Save file transfer - Use Save While Active *SYNCLIB.
• Add multi item progress bar to updates and spooled file export.
• SQL Editor - Show warning messages in log.
• SQL Procedure - Add right-click text edit menu items.

Fixes:

• File Editor Export - Fix unnecessarily adding double quotes around fields that contain commas for XLS export.
• Fix Lucida Typewriter Font not found.
• IFS Editor - Fix Ctrl-c not always working.
• FTP Workstation - Fix byte count for files over 2.14GB.
• Delimited Import - Fix problem of unnecessarily trimming text around delimiter character when that character is not used as a delimiter but is present inside of a text qualifier.
• Import/Export Wizard - Fix. Specification name may disappear if window is resized too small.
• Import - Give user opportunity to select a different system when saved IFS source system does not connect.
• Export Spool Specification - Fix. After opening a saved specification, the destination may be null if the destination format is changed without reloading the specification.
• Update Server - Library Objects - Fix not always working on V4R5.
• Member List - If member list too large use alternate retrieval method.
• Fix problem of frames not closing when the X is clicked on.
• SQL Editor - Fix Call stored procedure with system naming.
• External Procedures - Use system naming for Show SQL Editor when procedure contains entry points or when the external library is *LIBL.
• Fix busy cursor problem when beginning a File or Object Search.
• IFS Navigation - Fix bug of busy cursor turning off too quickly which allowed users to click on components that were not ready for input.