Surveyor/400 Changes
Version 4.3.8 - December 19, 2020

Changes Version 4

Build 4.3.8 12-19-20

• Import - Add ability to configure a custom connection.
  This allows for setting connection properties and preventing entire application from being busy when importing.

Build 4.3.7 07-27-20

• Preferences not saving due to Base64 issues with Java 9 or greater.
• RDi - Support non-Windows RDi versions.
• RDi - Lower chances of multiple TN520 dialogs opening when multiple application server instances are running.
• SQL Editor - Disable word wrap option when using syntax coloring.
• SQL Editor - When application is closing, do not display cancel button on save script dialog.
• SQL Editor - Certain Clob fields not displaying as text.
• File Editor - Bigint fields should allow 19 digits to be entered.

Build 4.3.6 02-28-20

• Upgrade to JT400 9.8
• IFS Editor - Add ability to copy file path to clipboard.
• Import - Excel - Import #DIV/0! errors as zero.
• File Editor - Fix window that opened File Editor appearing in front of File Editor.
• SQL Wizard - Support mixed case column names.
• SQL Search - Improve 'Search Not Available' error message

Build 4.3.5 04-12-19

• SQL Editor - Fixed issues with parenthesis and using the F4 key.
• SQL Editor - Display column size in data type after pressing F4.

Build 4.3.4 01-03-19

• SQL Editor - Add ability to open .sql files outside of application.
• Certificate Manager - Preferences - Add ability to specify location and password of key store.
• Certificate Manager - Preferences - Add ability to change key store password.
• Journal Entries - Handle large sequence numbers represented as -1. (Update Server 4.1.3)

Build 4.3.3 05-21-18

• Export - Excel 2007 - Add Streaming option.
• Export - Excel 2007 - EXPDTA - Add Streaming option. (Update Server 4.1.2)
• Journal Entries - Add option to leave window open after retrieving entries.

Build 4.3.2 04-09-18

• Export - Excel - EXPDTA - Out of memory now produces SVY0001.
• Import - Excel - IMPDTA - Out of memory now produces SVY0001.

Build 4.3.1 01-22-18

• Export - Excel - Add ability to wrap data in a cell.
• Stored Procedures - Execute - Removed parameter length restrictions.
• Object Properties - Fix incorrect size calculation for MB and GB. (Update Server 4.1.1)

Build 4.3.0 10-12-17

• Rebrand - Change Linoma information to HelpSystems
• Export - Database - Fix destination IASP when using EXPDTA. (Update Server 4.1.0)
• SP - Fix SP command not working. (Update Server 4.1.0)

Build 4.2.4 08-24-17

• Export - Excel - Fix whole number format being applied to decimal cells when decimal formatting left blank.

Build 4.2.3 07-24-17

• SQL Generator - Add ability to generate permission statements.
• SQL Generator - Add ability to generate drop statements.
• SQL Editor - Preserve leading spaces in literals when copying from SQL Log.
• SQL Generator - Fix V7R2 file not found error for long table names.
• Export Spooled File - Save ESPX specification - Fix Filter Overprinting and other advanced properties not saving.
• IFS - Fix right-click menu position when opened on empty portion of table after scrolling down.
• Disconnect - Make Surveyor temporary MSGQs *PUBLIC *ALL, so other user profiles may delete. (Update Server 4.0.10)

Build 4.2.2 03-10-17

• SQL Editor - Add Default Log Location preference.
• SQL Editor - Add Continuous Write preference.
• IFS File Chooser - Improve performance.
• Journal Entries - If error occurs when writing to temp file, but some records written, open temp file.
• Journal Entries - Default date/time fields when insert error occurs. (Update Server 4.0.9)
• Journal Entries - Upon error if no records are written, remove temp file. (Update Server 4.0.9)
• Journal Entries - When error occurs, if some records written notify client. (Update Server 4.0.9)

Build 4.2.1 01-05-17

• Journal Entries - Fix journal using file library instead of journal library.
• IFS - Deleting or renaming a folder in table expands wrong parent folder tree.
• IFS - Fix file not being recognized as duplicate when copying and pasting in root.

Build 4.2.0 11-29-16

• Journal Entries - Add ability to view journal entries for a given file in a temporary file using the File Editor. The journal entries may be saved as a Layout.
• Journal Entries - Display journal entries for a given *JRN object using the DSPJRN command.
• Custom Commands - Add STRJRN and ENDJRN.
• File Editor - Add preference to prompt for deleting of temporary journal save file.
• File Editor - Support SQL Double data type.
• SQL Function - Improve window sizing for large functions.
• TN5250 - Fix lock up on screen restore.
• Journal Entries - Add supporting programs. (Update Server 4.0.8)
• SQL Generator - Support NCHAR, NVARCHAR, DECFLOAT data types. (Update Server 4.0.8)

Build 4.1.8 07-25-16

• SQL Wizard - Fix SQL when joining 3 or more tables.
• SQL Wizard - Fix 'Use AS' checkbox 'Change Alias' option appearing twice.
• Import Wizard - Create table - Fix decimal field length calculation being too small when many numbers are to the right of the decimal point.
• Import Wizard - Fix certain types of 'REF!' errors not being recognized.
• Export - Excel - Fix issues with black and white colors.
• IFS - Fix double clicking on folders having no effect.
• IFS - Copy Name - Fix containing name of parent instead of child.

Build 4.1.7 05-04-16

• Client Command Line - Add ability to monitor for messages, such as SVY0101 No Records Exported, via command line options -exportdb2, -importdb2, -exportspool2.
• Client Command Line - importdb - Fix issue with importing Excel 2007
• RDI Plugin - Add instructions for version 9.5.
• SQL Editor Results - Add ability to view a BLOB field in field viewer.
• SQL Editor Results - Add ability to view an XML field in table.
• FTP - CPF3281, CPC32B0, CPI32B0, CPC7301, CPC7305, CPC7011 should not cause FTP Error status. (Update Server 4.0.7)
• MENU - Update address and copyright. (Update Server 4.0.7)
• EXPDTA, IMPDTA, EXPSPL - Update Java version help. (Update Server 4.0.7)
• EXPDTA, IMPDTA, EXPSPL - Add JVM name to header. (Update Server 4.0.7)

Build 4.1.6 12-14-15

• SQL Editor Results - Add ability to export a BLOB field to file.
• Edit Authority - Fix problems when object is in an IASP.
• SQL Search - Better enforce Object Access authority.
• Misc - Update online demo link.

Build 4.1.5 09-1-15

• SQL Editor - Add comment/uncomment menu option for selected text.
• SQL Editor - Add qcmdexc menu option for selected text.
• Views - Users must have *CHANGE authority to see a view's source.
• File Editor - When adding records, update default value of current date, time, and timestamp fields.
• File Editor - Treat Open DBCS fields as Graphic to avoid truncation.

Build 4.1.4 06-03-15

• Make compatible with Java 8.
• Create 64 bit version.

Build 4.1.3 05-19-15

• File Editor - Filter - Treat hex fields as character.

Build 4.1.2 05-07-15

• Import - Excel - Fix text value from a formula cell error.

Build 4.1.1 05-05-15

• EXPDTA - Database - Fix user space error when exporting to remote system.

Build 4.1.0 04-29-15

• Update JT400 driver to version 8.5.
• Update Excel driver.
• Allow user to change expired password.
• Add ability to display command information similar to DSPCMD.
• EXPDTA - Fix SVY0101 not working when using USMSG parameter.
• EXPDTA - Database - Fix user space error.
• View Properties - Fix SQL tab not appearing when name contains spaces.

Build 4.0.15 04-20-15

• EXPDTA, IMPDTA, EXPSPL - Fix USMSG parameter not working. (Update Server 4.0.6)

Build 4.0.14 01-06-15

• TN5250 - Revert some Field Minus handling to old behavior.

Build 4.0.12 01-02-15

• File Editor - Fix lock up when using Duplicate Prompt after resizing a column heading.
• Import - Excel - Handle Concatenate formula.
• TN5250 - Improve Field Minus handling.
• EXPDTA - Expand query length. (Update Server 4.0.5)

Build 4.0.11 11-13-14

• TN5250 - Attempt to handle write to window errors.

Build 4.0.10 10-30-14

• IASP - Improve IASP handling. (Update Server 4.0.4)

Build 4.0.9 09-25-14

• TN5250 - Add ability to copy and paste using keys.
• RDI Plugin - Fix Surveyor application not launching.

Build 4.0.8 08-11-14

• Constraints - Add ability to delete constraints.
• Constraints - Add ability to enable/disable constraints.

Build 4.0.7 05-09-14

• Import - Excel - Import error cell correctly.
• Job Properties - Add general job information.
• Export - Add ability to export all members to a folder.
• EXPDTA - Add ability to export all members to a folder. (Update Server 4.0.3)

Build 4.0.6 01-30-14

• IMPDTA - Unable to import Fixed Width file without specification.

Build 4.0.5 10-22-13

• File Groups - Unable to add file to group.

Build 4.0.4 10-17-13

• Web Update - Change alternate site.
• EXPSPL - Fix margins with decimal points. (Update Server 4.0.2)

Build 4.0.3 10-04-13

• SQL Editor - Export - Export All button not working.

Build 4.0.2 10-01-13

• Import - Open specs when source fields are empty.
• Import - Excel - Import #REF! errors as zero.
• Import - Fixed Width - Fix mapping error when saving in XML.

Build 4.0.1 09-18-13

• Fix object not found with single user license.

Build 4.0.0 08-22-13

• Library List - Library List Groups - Add ability organize libraries into groups.
• Library List Groups - Add ability to secure library list groups.
• SQL Search - Add SQL Search feature. Search for database files, indexes, procedures, functions, triggers and constraints.
• SQL Search - Distinguish types of files such as SQL tables and DDS physicals.
• SQL Functions - Add ability to view, create and manage SQL functions.
• Specifications - Add option to save import, export and spool Specifications in XML format.
• IFS - Add ability to view, create and manage network shares.
• System Properties - Add database properties.
• DBR - Add ability to view unique keys.
• File Editor - Add reason code for non-editable files.
• Layouts - Increase maximum size of layouts.
• FTP Log Viewer - Make summary buttons toggle buttons.
• Upgrade to Java 7.
• Upgrade Java Toolbox to 7.9
• Improve last system used logic.
• EXPDTA - Fix *Headings not working without specification.
• IFS - Fix Copy to Workstation in tree.
• Improve key positioning in table when duplicate letters present.
• Report message id when error in message description API.
• File Search - Add more record search options.

Changes Version 3

Build 3000 3.8.19 09-19-13

• Add Surveyor 4.0 message.

Build 3000 3.8.18 01-09-13

• User Access - Allow 'Max Export Records' to be set when 'Object Access' is not selected.

Build 3000 3.8.17 01-04-13

• User Access - Allow 'Max Export Records' to be set when only 'Export Layouts' is selected.
• IASP - Various IASP fixes.
• EXPDTA - Fix 'Password is not set' error when using a spec saved with custom connection and ran by a user id different from the one saved.
• Import - Improve empty source fields error handling.
• Export - Excel - Fix problem when opening a specification that contains custom headers and footers.

Build 3000 3.8.16 10-18-12

• Test build.

Build 3000 3.8.15 08-07-12

• SQL Wizard - Columns not loading when table name is less than ten characters and contains a period.

Build 3000 3.8.14 07-12-12

• IMPDTA - Excel - Fix 'Password is not set' error when using specification.

Build 3000 3.8.13 03-29-12

• Import - Add option to recognize negative number patterns.

Build 3000 3.8.12 03-08-12

• Export Spool - Line Feed Filter - Not filtering line feed when line feed is first character on page.

Build 3000 3.8.11 02-24-12

• Command Line Option - Add exportdb2 and importdb2 which allow override of source and destination.
• SQL Editor - Doesn't create SSL connection when SSL specified on system.
• Export Wizard - SQL - Allow Call Procedure statement.
• Export Wizard - SQL - When SQL contains more than one file and column headings are specified, column headings only displayed for first file.
• Stored Procedures - Execute - Timestamp parameter in wrong format.

Build 3000 3.8.10 02-02-12

• Import Wizard - Excel2007 - Next button causing lock up on certain sheets.

Build 3000 3.8.9 01-18-12

• Library List - JOBD button not replacing library list.

Build 3000 3.8.8 01-11-12

• File Editor - Position To does not scroll to top when position by RRN.
• File Editor - If delete fails due to trigger, do not show delete message in status.
• Configure Screen - System name cannot be blank.
• Import - Delimited - Strip all non-numeric characters from numeric fields.
• Import - Excel 2007 - Count not accurate for blank rows.
• Stored Procedures - Insert Parameter not inserting blank row.

Build 3000 3.8.7 11-10-11

• Import Excel - Fix rounding problem with large double values.
• Import Excel - Fix problem with import into SMALLINT data type.

Build 3000 3.8.6 09-23-11

• Import Excel 2007 - Treat null cells the same as empty cells.

Build 3000 3.8.5 07-14-11

• Export Spool - Fix Filter Overprinting error when single character on page.
• Export Spool Preference - Fix backward compatibility issue with filter line preference introduced in 3.8.4.

Build 3000 3.8.4 06-16-11

• Export Spool - Add filter line feed option.
• Spooled File Viewer - Add filter line feed option.
• EXSPL - Add filter line feed option.(Update Server 3.3.1)

Build 3000 3.8.3 04-29-11

• IFS File chooser - Repress file listings based on Surveyor authority.
• IFS File listing - Improve performance.
• Export - Update progress bar text for zero records.
• Miscellaneous maintenance.

Build 3000 3.8.2 03-01-11

• Export - Fixed Width - Add Load Fields button.
• Export - Fixed Width - Add Always use field length box.
• File Editor - Fix backwards Hebrew characters.
• Export Wizard Spool - PDF - Fix auto calculated margins for certain individually selected spooled files.

Build 3000 3.8.1 11-24-10

• EXPDTA - When using a specification column headings suppression ignored.

Build 3000 3.8.0 11-17-10

• IFS - Transfer folders to and from workstation.
• IFS Explorer - Add right-click menu option to System menu.
• IFS Preferences - Add IFS Explorer initial folder preference.
• IFS Explorer - Fix miscellaneous navigation problems.
• File Editor - Filter - Add position to, on field select screen.
• File Editor - Filter - Add show fields as seen in Layout check box.
• Export - Excel - Add ability to append to an existing sheet, or add new sheet to an existing spreadsheet.
• EXPDTA - Enable HEADTYPE(*HEADINGS) when using query.
• SQL Editor - Add Font preference.
• SQL Editor - Results - Fix numeric column auto size.
• Upgrade to JTOpen 7.1
• EXPDTA - Support Excel append.(Update Server 3.3.0)
• Field Properties - Field procedures check for loval.(Update Server 3.3.0)

Build 3000 3.7.8 09-23-10

• File Editor - Field Editor - Add overwrite ability.
• Export Excel - Add headers and footers when printing.
• Export Excel 2003 - Fix autosize happening too many times.
• Export Excel 2007 - Fix some numbers appearing as timestamps.
• Import Excel 2007 - Fix problem with empty cells.
• Install - Drop all procedures from Surveyor library. Eliminates duplicates.
• SQL Editor - Add CLIENT_APPLNAME to connection.
• SQL Editor - Save As - Begin with current file name.
• Save As - Warn if file exists.
• Export Spool - If Filter Overprinting automatically export by pages.
• Export Spool - Size better for Motif look and feel.
• Configure Screen - Resize system window.
• EXPSPL - Fix procedure VDRS235C not being declared.
• IMPDTA - When using a specification, add ability to override source and destination.(Update Server 3.2.8)
• EXPSPL - When using a specification, add ability to override destination.(Update Server 3.2.8)
• Field Properties - Add support for field procedures.(Update Server 3.2.8)
• Member List - Show member in use if it has exclusive lock.(Update Server 3.2.8)

Build 3000 3.7.7 07-23-10

• Export Wizard - Add ability to run in own connection and specify connection properties.
• Add some support for XML data types.
• Upgrade to JTOpen 7.0
• SQL Editor - Fix problem with cursor location when using F4 on some scripts.
• EXPDTA - Add QRYLIB parameter, which allows user to specify a library when using the QRY parameter.(Update Server 3.2.7)
• EXPDTA - When using a specification, add ability to override source and destination.(Update Server 3.2.7)
• Field properties - Add XML field support.(Update Server 3.2.7)

Build 3000 3.7.6 07-09-10

• File Editor - Set library list to not interfere with field proc.
• Export Spool - When exporting a single spooled file do not use spool file listing.
• Export Spool - Add more error handling to trigger escape message.
• Export Spool - Add program to retrieve spooled file number for *LAST and *ONLY.(Update Server 3.2.6)

Build 3000 3.7.5 04-29-10

• File Editor - Member/DBR Select - Add refresh button.
• File Editor - Filter - Recognize DBCS Open/Alpha as character data type.
• SQL Editor - Debug - Add UPDPROD(*YES) for debugging.
• Windows Look and Feel - Make mnemonics appear when Alt key is pressed.
• Allow tree positioning by typing in first character of tree node.
• FTP to iSeries - Allow 128 character case sensitive passwords.
• FTP to iSeries - Allow 128 character case sensitive passwords.(Update Server 3.2.5)

Build 3000 3.7.4 04-09-10

• Export - Pre-2007 Excel - Fix custom formatting of decimal and whole numbers.

Build 3000 3.7.3 03-25-10

• IFS - Add IFS Explorer.
• File Editor - Add alternating row color.
• File Editor - Allow custom column heading export with a non-saved layout.
• Export Spool PDF - Allow user to enter margin size.
• Export Spool Specification - Fix problem opening specification.
• EXPSPL - Allow user to enter margin size.(Update Server 3.2.4)
• DSPSPEC - Fix problem displaying Excel Import specifications.(Update Server 3.2.4)

Build 3000 3.7.2 03-04-10

• Export Excel - Fix error when saving specification.
• File Sizes - Round up to 1KB.
• Custom Commands IFS - Add CHGATR and CHGATR ATR(*CCSID).

Build 3000 3.7.1 02-11-10

• Export Excel 2007 - Fix incorrect row limit.
• TN5250 - Handle Invalid stream command better.
• SFE - Fix SFE command not working for various translations.
• EXPDTA - Fix Excel 2007 default data font size.(Update Server 3.2.3)

Build 3000 3.7.0 02-01-10

• Import/Export - Support Excel 2007.
• Export Excel - Add ability to specify title.
• Export Excel - Add ability to specify sheet name.
• Export Excel - Add ability to autosize columns.
• Export Excel - Add ability to change font properties of title, headings and data.
• Security - Support SSL connections.
• Output Queues - Add ability to work with spooled files from output queue properties.
• Preview - Add Copy Cell.
• Preview - Restrict printing and copy cell with export authority.
• Fast Path - Add tool tip to Object combo box.
• Fast Path - Add Select Member button.
• Stored Procedures Execute - Allow null parameters.
• SQL results - Improve column sizing.
• IFS Editor - Increase buffer size, other miscellaneous improvements.
• Add ability to delete triggers.
• Add ability to select/deselect all columns in table components.
• Upgrade client to Java 1.6.
• Upgrade all drivers, including upgrade to JTOpen 6.6.
• Support Nimbus Look and Feel.
• Install - Add options to declare procedures and create IFS files when the Surveyor library has been moved to a new system.
• Install - Add ability to cancel Web Update.
• Export Spool - Filter Overprinting - Don't filter out new line characters in certain situations.
• File Editor - Fix busy cursor bug on the DBR select screen when double clicking on the file to select.
• Member list - Fix bug when members are locked. V5R4 and above. (Update Server 3.2.2)
• EXPDTA - Add Font options.(Update Server 3.2.1)
• EXPDTA - Allow QDLS.(Update Server 3.2.1)
• EXPDTA/IMPDTA - Support Excel 2007.(Update Server 3.2.0)
• Spooled File Manager - Fix bug with 10 character library and 10 character Output queue.(Update Server 3.2.0)

Build 3000 3.6.18 02-01-10

• Prepare for version 3.7
• Spooled File Export Text - Fix ASCII Form Feed replacement.

Build 3000 3.6.17 10-16-09

• Import - Excel - Fix problem when opening specification in which a different system must be selected.
• Export - Excel - Fix problem when spreadsheet contains more than 32767 rows.

Build 3000 3.6.16 08-07-09

• Update Server - Add more objects for V6R1 conversion(Update Server 3.1.8)
• Update Server - Remove obsolete objects.

Build 3000 3.6.15 07-07-09

• Import Wizard - Excel - Fix - When opening specification in which saved sheet is not the first sheet, first sheet is opened. introduced in 3.6.14.

Build 3000 3.6.14 06-09-09

• Import Wizard - Excel - Reload sample data when a saved specification is open and a new source Excel file is selected with a different sheet name.

Build 3000 3.6.13 06-08-09

• Preferences - Fix - Monospaced Font value may be null, when upgrading from old version.

Build 3000 3.6.12 05-26-09

• Import Wizard - Preserve field mappings even if file, library or system changes as long as fields remain the same.
• DSPSPEC - Import Specification - Display field mappings.
• File Editor - Filter - Fix matching parentheses problem when deleting a row.
• TN5250 - Fix problem of screen reverting back to 24X80 when using SEU in 27x132 mode and interrupted by break message.

Build 3000 3.6.11 05-05-09

• Command Line Option - Don't show trial period dialog when running non-GUI features.

Build 3000 3.6.10 03-31-09

• Plug-in - Support RDi 7.5
• Run SQL - Surround system file names that contain a period in double quotes.

Build 3000 3.6.9 03-10-09

• Import - Excel - Update preview table when selecting a starting row.
• Import - Excel - Fix problem with saving a specification introduced in 3.6.8.

Build 3000 3.6.8 03-02-09

• Import - Excel - Allow import of Label type records.
• File Editor - Filter - Upgrade GUI, now able to traverse using keys.
• SQL Editor - Find/Replace - Fix hang up due to thread lock.

Build 3000 3.6.7 02-09-09

• EXPSPL - Add - Replace Form Feed with number of line feeds needed to fill page.(Update Server 3.1.7)

Build 3000 3.6.6 01-19-09

• Export Spooled File Text- Add - Replace Form Feed with number of line feeds needed to fill page.

Build 3000 3.6.5 12-23-08

• File Editor - Fix 'Position to' when key field is Graphic.
• Preferences - Add a choice for monospaced fonts. DBCS characters were not being displayed correctly using the default monospaced font.

Build 3000 3.6.4 12-08-08

• Import - Excel - Fix error for unexpected Excel sub-record.

Build 3000 3.6.3 11-11-08

• Library Chooser - Default libraries shown to user's library list setting.
• Error Log - Redirect error log to user directory if user cannot access.

Build 3000 3.6.2 11-06-08

• SQL Generator - Add FOR COLUMN option.
• File Editor - Allow ESC key to close 'Position to' dialogs.

Build 3000 3.6.1 10-28-08

• File Editor - Fix Filter lock up on V6R1.
• TN5250 - Add Greek ccsid.
• Delete - Add ability to delete a service program.
• Stored Procedures - Support service program procedure with SQL naming.
• Memory - Increase memory heap for new downloads.

Build 3000 3.6.0 09-18-08

• TN5250 - Add SSL support.
• SQL Editor - Preferences - Add ability to specify tab length and replace tabs with spaces.
• SQL Editor - Find Replace - Add ability to find and replace tab characters using \t.
• SQL Editor - Syntax Highlighting - Improve multi-line comment highlighting.
• SQL Editor - Improve Error handling.
• Field Names - Support 128 column field names(Update Server 3.1.6)
• Export Spooled File - Allow generated EXPSPL_LOG spooled file to be exported when not in use.
• Stored Procedures - Execute - Add ability to change connection properties.
• Stored Procedures - Preferences - Add connection properties preference.
• Stored Procedures - Create SQL Procedure - Add ability to set SQL path and date format.
• Stored Procedures - Copy - Add ability to copy multiple procedures.
• Stored Procedures - Copy/Edit - Add ability to set connection properties.
• Properties - Add number of objects to file, procedure and object filters.

Build 3000 3.5.15 09-06-08

• Export - Fix BigDecimal format problem in Java 1.6

Build 3000 3.5.14 08-13-08

• Beta - Add ability to get beta version.

Build 3000 3.5.13 07-25-08

• User Access - Version 29 Upgrade - Administrators not given View User Access when upgrading from version 29x.

Build 3000 3.5.12 07-24-08

• Import Wizard - Allow wizard to open if source file not found.

Build 3000 3.5.11 07-21-08

• SQL Results - Fix BigDecimal format problem in Java 1.6

Build 3000 3.5.10 06-17-08

• Import Wizard - Fixed Width - Fix field lengths being loaded from destination file instead of from saved specification field lengths.

Build 3000 3.5.9 05-09-08

• Export SQL Results - Null value not tested correctly when a null object is returned as a result of a CASE expression returning null.

Build 3000 3.5.8 05-06-08

• SQL Editor - Add ability to show column labels as column headings in result window.
• SQL Editor - Add tool tip field information to column headings in result window.
• SQL Editor - Add optional warning for potential library list problems.
• SQL Editor - Export Page - Fixed Width - Use metadata field lengths.
• Import Wizard - Create table - Fix 'File does not Exits' message since 3.5.7
• Export XML - Replace spaces with underlines if tag names contain spaces.
• Standardize Member Selectors - Standardize open, save and add member screens.

Build 3000 3.5.7 04-11-08

• Spooled File Manager - Add ability copy spooled file attributes to filter.
• Object Filter - Fix bug with date format.

Build 3000 3.5.6 04-07-08

• Spooled File Manager - Add ability copy spooled files.
• File Editor - Use main library list.
• Table Chooser - Only list tables user does has access to.

Build 3000 3.5.5 03-31-08

• Import - Add ability to import flat files.
• View Properties - Show View SQL on SQL tab.
• Triggers - Add ability to view INSTEAD time triggers.

Build 3000 3.5.4 03-05-08

• Fast Path - Open Object Search if wild card used.
• Export Wizard - Fix bug when IFS destination system is different than source system.

Build 3000 3.5.3 02-25-08

• WDSC Plugin - Share connections among features.
• User Access - Members of a group will use log/audit files set up at the group level.
• User Access - Add ability to Copy a user or group.
• User Access - Library List - Add ability to select libraries from other users.
• User Access - Add ability to restrict users from viewing User Access.
• Fast Path - Run SQL - Make connection before showing selection menu.
• File Editor - Filter - Add ability to add a row to bottom of filter.
• V6R1 - Prepare objects for V6R1. (Update Server 3.1.4)
• SQL Wizard - Fix inability to enter a date with more than 8 characters. (Update Server 3.1.4)

Build 3000 3.5.2 01-30-08

• Spooled File Export - Fix Filter Overprinting box not being loaded from preference.
• Update Server - Disable menu item if not Administrator.
• File Editor - Hex viewer - Fix column heading being truncated in certain situations.
• Procedures - Display number of procedures in status bar.

Build 3000 3.5.1 01-18-08

• File Editor - Fix - After updating a cell and using mouse to move to a new cell value of updates reverts back to original value. Caused by Java 1.6.
• SQL Editor Preference - Added a no parsing option.
• Stored Procedure Wizard - Do not parse SQL when using Procedure wizard.
• Stored Procedure Wizard - Improve SQL procedure formatting.
• Export Table - Clipboard - Fix error when using Fixed Width format and not pressing the Next button.

Build 3000 3.5.0 12-18-07

• 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.
• SQL Editor - Save As Member - Add ability to specify description and type.
• Preferences - Add Spooled File Export preferences.
• Calculator - Add paste ability.
• Layouts - Add Authority menu item.
• File Editor - Add tool tip field information to Modify Layout screen.
• File Editor - Don't allow mass replace of protected column.
• File Properties - DBR - Add key field description column. (Update Server 3.1.3)
• Default Value - Support Default Value of None. (Update Server 3.1.3)
• Print Preview - Fix some sizing issues when using Compress Columns.
• Export Spooled File Specification Wizard - Display message for no records found.
• SQL Editor - Fix length of tab in Save member when using Syntax Coloring.
• SQL Wizard - Fix disappearing Where clause.
• Messaging - Add ability to EXPDTA and IMPDTA to throw escape message for member not found error. (Update Server 3.1.2)
• File Editor - Fix problems with disabled color in Metal look and feel.
• EXPDTA - IMPDTA - EXPSPL - Fix problem with some messages not be thrown when using USEMSG parameter. (Update Server 3.1.3)
• EXPDTA - Allow query to have a length greater than 256 characters. (Update Server 3.1.3)

Build 3000 3.4.4 10-23-07

• File Editor - Use default values in Add mode.
• 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.

Build 3000 3.4.3 10-15-07

• Internal build.

Build 3000 3.4.2 10-02-07

• Stored Procedures External Edit - Fix SQL0455 message by qualifying specific name.
• Stored Procedures Edit - Add option to drop procedure based on SQL0456 message.
• Stored Procedures - Show SQL - Generate SQL for comments also.
• Stored Procedures - Show SQL - Select correct system.

Build 3000 3.4.1 09-27-07

• Stored Procedures - Add better support for Java procedures.
• Stored Procedures - Add DB2SQL parameter style.
• 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.

Build 3000 3.4.0 09-05-07

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

Build 3000 3.3.11 05-01-07

• WDSC Plugin - Add support for WDSC 7
• 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.

Build 3000 3.3.10 04-17-07

• Export Spooled File - Add ability to change leading.
• 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)
• Field Properties - Add support for ROWID columns. (Update Server 3.0.9)

Build 3000 3.3.9 04-03-07

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

Build 3000 3.3.8 01-24-07

• Import - Fix SQL0206 error when first field in specification is excluded.

Build 3000 3.3.7 01-09-07

• Layouts - Prompt Filter - Add Field Description column.
• 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)

Build 3000 3.3.6 12-05-06

• Delete - Add ability to delete *MSGQ and *PNLGRP objects.
• 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)

Build 3000 3.3.5 12-01-06

• 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 - Improve SPL parsing.

Build 3000 3.3.4 11-03-06

• SQL Editor - Allow Common Table Expressions under the 'Allow SQL' authority setting.
• Members - Allow multi-selected members to be used in FTP functions.
• Members Properties - Allow multi-selection of members.
• 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 - Allow FTP 550 errors that contain successful restore messages to have a status of Finished instead of FTP Error. (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)

Build 3000 3.3.3 10-04-06

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

Build 3000 3.3.2 09-28-06

• EXPDTA - Fix Fixed Width exports ArrayIndexOutOfBoundsException error.
• Command Line Option- Add ability to run iSeries commands from a command script using the -runcommand or -runcommandprompt arguments.

Build 3000 3.3.1 09-15-06

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

Build 3000 3.3.0 08-31-06

• 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 - Changes to Data Transfer logs will be immediate when the change is being made to the Administrator's currently connected user id.
• User Access - Add 'Export to Database' authority.
• 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)

Build 3000 3.2.3 05-19-06

• Server change - Recompiled various programs to target release V5R1. This was done to prevent new installs from experiencing a MCH3601 error due to IBM PTFs. This change will not help existing installs. Existing installs must download a save file from http://www.linomasoftware.com/beta/surveyor54/

Build 3000 3.2.2 05-17-06

• SQL Results Excel Export - Right trim character fields.
• Command Editor - Fix incorrect identification of comments for commands that can contain /* that is not a comment. Example: (LIBRARY/*ALL)
• TN5250 - Add better error handling for Invalid Commands.

Build 3000 3.2.1 03-31-06

• WDSC Plugin - Remove registration requirement. Version 1.2.4.
• FTP iSeries - When using save file transfer use *ALL for members instead of *FIRST when member name not specified.
• Install - Handle missing procedure call Exception.

Build 3000 3.2.0 03-15-06

• Added Edit Authority feature.
• Added Remember Window Size feature.
• WDSC Plugin - Add Edit Authority. Version 1.2.3.
• Preferences - Remember Window Size preference.
• Preferences - Moved 'Preview Display Count' to System section.

Build 3000 3.1.5 02-28-06

• TN5250 - Fix 'Key not allowed' error in Field Exit Required fields.
• Fast Path - Fix history read location.
• Install - Fix reconnect on some installs.
• 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)

Build 3000 3.1.4 02-08-06

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

Build 3000 3.1.3 01-13-06

• File Editor Filter - Fix 'Not' symbol character set incompatibility.
• File Editor Filter - Fix Filter not cleared when file is closed.
• Spooled File Specification - Fix Margin and Auto Size not being populated in the Wizard.

Build 3000 3.1.2 12-27-05

• Procedure Properties - Fix problem of Procedure Properties, Edit and Copy features not working when specific name is different from routine name.

Build 3000 3.1.1 12-20-05

• Layouts - Fix problem of some elements of filter not being saved correctly after filter has been reset.

Build 3000 3.1.0 12-08-05

• Layouts - Add ability to generate a script which can open a layouts without opening entire application.
• WDSC Plugin - Add ability to edit data areas.
• WDSC Plugin - Add ability to display IFS file properties and permissions.
• Optimize icons.

Build 3000 3.0.8 11-22-05

• Native Import and Export - Specify date format property on JDBC connection. Newer JDBC drivers are more sensitive to this property.
• TN5250 - Device names were not being retrieved correctly when preferences are stored in User Folder.

Build 3000 3.0.7 11-15-05

• Minor bug fixes and documentation changes for public build.
• 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.

Build 3000 3.0.6 11-09-05 (not available to public)

• WDSC Plugin - Fix incompatibility with WDSC 6.x
• Export logging - Log File Editor exports made by using Export Selected Records and Export Page
• File Editor - Position - Do not trim leading spaces in Position dialog.

Build 3000 3.0.5 10-21-05

• Export Wizard - Fix some special characters not exporting correctly to IFS. Caused by Unicode change in 3.0.3.
• EXPDTA - Add Unicode option.(Update Server)
• EXPDTA - Fix failure of exports using a specification due to older version of Java Toolbox licensed program. Caused by Unicode change in 3.0.3.(Update Server IFS)
• Add ability to control Java output on EXPSPL, EXPDTA, and IMPDTA commands.(Update Server)
• EXPSPL - Add option to replace form feed characters with ASCII form feed characters.(Update Server)
• Fix authority error when adding certain users to a group.(Update Server)

Build 3000 3.0.4 10-06-05

• Spooled File Export - Text files - Add ability to replace form feed with ASCII form feed.

Build 3000 3.0.3 10-04-05

• Export Wizard - Add ability export using Unicode encoding.
• Fix new users library list not being initialized with *NEWUSR's library list.(Update Server)

Build 3000 3.0.2 09-26-05

• 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.
• Export Layout - Prompt user to fill in Prompt field values.
• Export Layout - Export column headings or custom column headings, depending on the Layout's Name/Description property.
• File Editor - Fix quirky select and right-click behavior of RRN fields.
• Install - List administrators if user is not an Administrator.
• Client Update - Fix problem of some non-Windows platform not getting update due to missing folder.

Build 3000 3.0.1 09-13-05

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

Build 3000 3.0.0 09-09-05

• 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.
• File Editor Export - Fix unnecessarily adding double quotes around fields that contain commas for XLS export.
• 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.
• Fix Lucida Typewriter Font not found.
• FTP Workstation - Fix byte count for files over 2.14GB.

Changes Build 29xx

Build 2909.09 04-21-05

• Changed monospaced font to a font which can more easily distinguish the letter O from the number zero.
• IFS Editor - Fix Ctrl-c not always working.
• Delete objects/members - Made result message box scrollable.
• Add option to check for major upgrade on IFS.

Build 2909.08 03-09-05

• Delete Members - Add ability to remove multiple members from main window.
• 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.

Build 2909.07 02-28-05

• Export Spool Specification - Fix. After opening a saved specification, the destination may be null if the destination format is changed without reloading the specification.

Build 2909.06 02-09-05

• Update Server - Library Objects - Fix not always working on V4R5.

Build 2909.05 02-03-05

• FTP Workstation - Progress bar not working correctly due to change in 2909.03.

Build 2909.04 01-27-05

• FTP AS400 - No save file transfer - Add ability to specify transfer types ASCII, EBCDIC and Binary. (Update Server)
• FTP AS400 - Save file transfer - Add better error handling for save and restore operations. Must be installed on target system for restore messages (Update Server).
• FTP AS400 - Save file transfer - Use Save While Active *SYNCLIB. (Update Server)
• Member List - If member list too large use alternate retrieval method. (Update Server)

Build 2909.03 01-19-05

• SQL Editor - Call stored procedure with system naming.
• Fix problem of frames not closing when the X is clicked on.
• Add multi item progress bar to updates and spooled file export.

Build 2909.02 01-12-05

• Import - Give user opportunity to select a different system when saved IFS source system does not connect.
• External Procedures - Use system naming for Show SQL Editor when procedure contains entry points or when the external library is *LIBL.
• SQL Editor - Show warning messages in log.
• Fix busy cursor problem when beginning a File or Object Search.

Build 2909.01 12-21-04

• IFS Navigation - Fix bug of busy cursor turning off too quickly which allowed users to click on components that were not ready for input.
• SQL Procedure - Add right-click text edit menu items.
• Debug mode - Add some code for debug mode.

Build 2909 12-10-04

• Workstation Schedule Import/Export via command line - Added command line options when launching application. Options allow imports and exports without using a GUI for a given specification.
• Import Excel - Added ability to specify beginning row.
• Add ability to set registry entries for Windows file extensions via command line.
• Locks - Added ability to send messages to, or end multiple jobs that are locking an object.
• Spooled File Export - Allow user to open PDF viewer after export.(Windows)
• Spooled File Viewer - Improve GUI appearance when searching.
• Spooled File Export/Viewer - Add logic for extended ASCII (foreign) chars.
• File Editor - Menu will be labeled View instead of Edit if user has view only authority.
• File Editor - Fix incorrect member being chosen when selected from a list of sorted members.
• SQL Editor - Improve error handling in save and open member functions.
• SQL Editor - Surround delimited export delimiter in quotes.
• SQL Wizard - Fix only short file names allowed in text field.
• Export Excel - Fix columns being shifted when first column is blank.
• Export Wizard Excel - Do not leave first row blank if column headings are omitted.
• Export table Excel - Fix error when exporting a Surveyor table that contains a field like 100kb.
• FTP Workstation - Add ability to view job log when a save error occurs.
• FTP AS400 - Add button to view job log when Send button pressed.
• WDSC Plug-in - Fix problem of losing serial number when upgrading WDSC.
• WDSC Plug-in - Changed Alt key combinations no to interfere with LPEX editor.

Build 2908 07-08-04

• WebSphere Development Studio Client - Surveyor/400 can be plugged into WDSC.
• FTP - Add feature to transfer save files via FTP to and from workstation.
• Save Files - Add ability to view save file contents.(Update Server)
• Spooled File Export - Added ability to export page ranges.
• Support table names with mixed case and spaces. Must enclose in double quotes.
• SQL Wizard - Add ability to construct multiple joins.
• SQL Editor - Add icons to result window.
• SQL Editor - Add ability to view CLOBS.
• SQL Editor - Add ability to view BLOBS as images.
• SQL Editor - Fix truncation problem when saving script as member.
• SQL Editor - Fix problems when saving and opening a member.
• SQL Editor - Retain formatting of statements in SQL log.
• Run SQL - Use mixed case name when possible if launched from tree.
• Run SQL - Not always looking at correct naming preference. Fixed
• Import - Better support for date formats when importing an Excel file.
• Import - Add authority to deny users the ability to replace records.
• Import - When creating a table based on the file being imported, replace spaces in field names with underlines.
• Import Wizard - Prompt user for saving spec after import if specs have changed, instead of automatically saving specs.
• Import Wizard - When using the create table feature for delimited files delimited by a character other than a comma, window will just close on first attempt. Fixed.
• Export Wizard - Right justify numeric fields for Fixed Width export.
• Export Wizard - File name not correct when name contains mixed case and spaces when launched from tree.
• File Editor - Make the display of new line and tab chars optional.
• File Editor - Open - Add member chooser.
• File Editor Filter - When launching the File Editor from certain member screens, filter may not work due to member name and format name being concatenated. Fixed.
• File Editor Filter - Fix error message thrown by filter not showing while leaving busy cursor on.
• IFS - Add create date to main IFS table.
• FTP AS400 - Make into wizard instead of tab pane.
• Custom Commands - After running a command that results in an error, allow the user to view the job log.
• Editors - Add ability to undo/redo text changes in SQL Editor, IFS Editor and Command Editor.
• Connection - Add better error messages when connection rejected due to user name and password problems.
• Searching - Fix inability to cancel a search without an established command connection.
• Install - Add check for system value QFRCCVNRST.
• Tree - In Windows look and feel some tree node fonts may be truncated.

Build 2907 03-08-04

• Update EXPDTA and IMPDTA so they may work without a specification(Update Server)
• Added ability to search for source files. In Object and File searches.(Update Server)
• Preferences - Consolidate on Configure screen. Add new preferences for Export Wizard, Fast Path, Import Wizard, Spooled File Viewer, Spooled File Export and SQL Editor.
• Preferences - Give import and export spooled file their own default directories.
• Import Wizard - Add ability to import a value as null.
• Import Wizard - Fixed Width - Add ability to load lengths from table.
• Import Wizard - Allow user to specify number records used to estimate field lengths and data types when creating a table.
• Import Wizard - Fix bug when loading excluded or mapped fields.
• Import Wizard - Add date formats mmddyy, yymmdd.
• SQL Editor - Add ability to change date, time, and binary connection properties.
• SQL Editor - Support single line comments.
• SQL Editor - Wrap text when saving as member.
• SQL Editor - Added ability to select member when opening or saving a member.
• SQL Editor - Run SQL - Fix bug that locks file when using this feature.
• SQL Editor - Fix bug when pressing F4 when query contains multiple files.
• SQL Editor - Fix bug when saving to *FIRST member.
• IFS - Add progress and status bars when copying and deleting files.
• IFS - Add ability to make a duplicate of a file or folder with a Copy of prefix.
• IFS - Fix problems when copying IFS data between different iSeries.
• IFS - Improve tree and table refresh after copying or deleting.
• File Editor - Disallow change mode for read only files.
• File Editor - Fix ability to filter a multi format file.
• File Editor - Fix bug that would allow a user with view only ability to change a file under certain circumstances.
• Export Wizard - Calculate fixed width numeric lengths based on actual length instead of displayable length.
• Export Wizard - Add date formats mmddyy, yymmdd, and yyydd.
• Layouts - Delete authority inconsistent. Users can delete any layout they create. Must have Edit authority to delete other users layouts.

Build 2906 02-26-04

• Import/Export - Added ability to import/export Excel files.
• SQL Editor - Ability to cancel queries.
• SQL Editor - Add ability to use system naming.
• SQL Editor - Run Scripts in their own threads, so users may use other features concurrently.
• SQL Editor - Launch select, insert, or update statement from menu item of a given database file menu or member menu.
• SQL Editor - Make it easier to move SQL statements from SQL Log to editor.
• SQL Wizard - Add ability to join files.
• SQL Wizard - Improve how keys and buttons work to populate GUI.
• SQL Wizard - Use wizard to design insert, update and delete statements.
• SQL Wizard - Columns names are sorted in default order. May be optionally sorted ascending or descending.
• Export Wizard - Add ability to append to an existing file for some formats.
• Export Wizard - Add ability to use member when specifying a query. Type the member name in the Member field.
• Export Wizard - Make query window easier to use.
• Export Wizard - Add more XML options.
• Import Wizard - When creating a table, field data types and lengths are estimated based on first 50 records in file.
• Import Wizard - Improve format of date and timestamps.
• Import Wizard - Many miscellaneous fixes.
• Import Wizard - Remove some special characters from numeric fields.
• Import Wizard - Add ability to suppress warnings.
• Surveyor - Add ability to use different IASPs. File Editor pending.
• Help - Add right-click pop-up menu to select and copy text.
• File Editor - Add support for unicode - CCSID 13488.
• File Editor - Fix. Function keys not always working.
• File Editor - Fix. Invalid Duplicate Prompt values when columns re-arranged in single mode.
• File Editor - Fix. In single record mode latest changes are not always shown when paging up and down.
• File Editor - Hex Editor - Make column heading wider.
• IFS File Chooser - Display location and improve how directories are selected.
• IFS - Fix. Copy and Move to workstation was only allowed for single file.
• IFS - Fix. Unable to delete multiple directories.
• Spooled File - Improve Filter overprinting when the overprinted characters are underlines.
• Library List - Just collapse Database portion of tree when Library List is changed.
• Preview Tab - Fix. Timestamp values with an hour of 24 being rounded up.
• Printing - Heading not visible on some black and white printers,
• Procedures - Add Show SQL button to procedure properties.
• Procedures - Separate copy and edit functions.
• Update Server - Combine Apply Server Patch with Update Server.
• Screen Size - When Surveyor Opens in 800 X 600, tool bar may disappear if resized on some computers.
• Server Change(2905) - Update EXPDTA and IMPDTA commands to work with Excel files.
• Server Change(2905) - Change FTP commands to handle NAMEFMT 1 naming convention.
• Server Change(2905) - Fixed problem of offline size on object tab not being displayed correctly when the value is greater than 1,000,000,000 bytes.
• Server Change(2905) - Fix DBR bug. Garbage data appearing in relations for very large relations.

Build 2905 08-11-03

• Custom Commands - Added ability to prompt OS/400 commands. When an object is right-clicked, a list of non-interactive commands relative to that object is displayed.
• Custom Command Manager - Associate your own custom commands with certain objects based on the object's type and attributes.
• Command Editor - A script of single or multiple OS/400 commands may be executed or saved to be ran at a later time.
• Object Filters - Object Filters return a list of objects for a given set of filter criteria. Filters appear in the tree on the main Surveyor/400 window either under a library or under the Database folder.
• Spooled File Manager - Fixed inability to move spooled files on V5R2.
• Spooled File Manager - Allow lower case characters in user data field.
• Spooled File Manager - Default *LIBL for an Output Queue library.
• Spooled File Export - Fix inability to browse IFS.
• Data Area Editor - Do not trim leading spaces.
• Object Search - Fixed Object Search hanging when launched by right-clicking a library in the tree.
• File Editor Filter - Fix field not being large enough to hold some binary numbers.
• File Editor - Fixed fields appearing to be cut off in position to feature.
• TN5250 - Fixed device combo box being empty when new system is added.

Build 2904 04-16-03

• File Editor - Fixed page up bug introduced in 2903.

Build 2903 04-14-03

• Database Audit Log - Added ability to record File Editor audit trails to a database file.
• Spooled File Export - Changed Filter Overprinting to allow a character to be printed on top of a blank character instead of excluding them.
• File Editor Filter - Added Is Blank and Not Blank.
• System Properties - Added version number of IFS jar files.
• Uppercase passwords - Do not store passwords as uppercase.
• Library List - Fixed bug when library list contains more than 100 libraries. Use Apply Server Patch to apply this fix.
• Stored Procedure - Fix bug when executing a stored procedure with no parameters.
• Import - When importing a delimited file, fill in missing columns with blank columns.

Build 2902 02-27-03

• Data Area Editor - Added ability to edit Data Areas via Fast Path and Object Search.
• User Access - Added security flag for editing Data Areas.
• Spooled File Export - Fixed overprinting bug when Filter overprinting selected. Only a portion of the spooled file was being exported.
• SQL Editor - Selecting from some files would cause SQL0913. Opening results sets differently fixed the problem.
• Help - Fix highlighted text being too dark when using search function.

Build 2901 01-28-03

• Security - Fix problem of Surveyor inadvertently saving password in the preferences.
• Spooled File Export - Added new darker fonts for PDF's.
• Spooled File Export - EXPSPL command - No longer need specification. Must have server version 2901. Use Apply Server Patch from the Help menu.
• Spooled File Export - Fix attribute problem on V5R2.
• Tree - Fixed problem of displaying bad file names when AS/400 naming and low detail selected. Problem only occurred in long file lists.
• Library List -- Accommodate V5R1's 250 library list maximum.
• Field Properties - Fix incorrect field information when sorting tables.
• File Editor - Fix problem with packed decimal fields that have no digits before the decimal place.
• File Editor - Fix find feature only working with *FIRST member.
• File Editor - Added ability to select members from the DBR member tab.
• Sorting - Sortable tables may now be sorted by single clicking a column heading.
• Spooled File Viewer - Fixed the Unload Page button not being visible when using 800 X 600.
• Display of DDS source - Some DDS source not justified correctly.

Build 2900 11-21-02

• Added AS400 commands to export database files and spooled files. Also there is a command to import a database file.
• Library list - No longer in alphabetical order.
• Library list - Added ability to re-order.
• Library list - Added ability to revert to Job Description's list.
• User Access - New users can now adopt *NEWUSR's library list.
• SQL long file and field names are better supported. The long names are now viewable everywhere. You can also type a long name in the Fast Path and File Search.
• Spooled File Manager - More filter criteria and information is available.
• Spooled File Export - Add ability to automatically calculate paper size for multi spooled file exports.
• Spooled File Export - Added more font sizes.
• Spooled File Export - Added ability to change margins.
• TN5250 - Add ability to choose CCSID.
• Wheel mouse is now supported.
• Improved file choosers.
• Field Properties - Includes buffer positions.
• SQL Editor - Fix new connection sometimes losing password.
• SQL Generator - Fix not all foreign keys appearing.
• File Editor - Improved error handling for server side errors.