May 14th, 2008
Products
Download
Company
Contact
Home

Home » Products » Surveyor/400 » What's New

What's New

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)
Fixes:
  • 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.
Fixes:
  • 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.
Fixes:
  • 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.
Fixes:
  • 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.