*********************************************************************** *** W A R N I N G *** *********************************************************************** This PTF is cumulative and includes ALL of the changes described below. You should review the description of all changes since the last PTF you applied and consider their effects in your particular environment before deciding to apply this PTF See http://www.ariadnesoftware.co.uk/SlipstreamUserGuideV4R1.pdf for the procedure to follow. We recommend you: a) Do a SAVLICPGM of 4STMEXP before loading the PTF b) Do a SAVLIB of STMEXPV4R1 before loading the PTF c) Apply *TEMP initially. *********************************************************************** *** D I S C L A I M E R *** *********************************************************************** You apply this PTF at your own risk. In accordance with your software license agreement, in no event shall the Licensor be liable to you for any damages, including loss of business, loss of opportunity, loss of data, loss of profits or for any other indirect or consequential loss or damage whatsoever arising out of the use of or inability to use the Software, or resulting from any action implied, suggested, recommended or advised by the Licensor or one of its representatives or distributors, even if the Licensor has been made aware of the possibility of such damage. While every effort has been made to ensure that this PTF will have the effect described below and no other detrimental effect, this cannot be guaranteed and you are encouraged wherever possible to re-test your systemss after this PTF has been applied and before running the Software live again. PTFs should be applied *TEMP initially so they can be removed with RMVPTF should unwanted side-effects occur. We recommend you do a SAVLICPGM of licensed program 4STMEXP before applying PTFs in order to allow a recovery option in the event of corruption. *********************************************************************** 4STMEXP Slipstream PTF/FIX #: 4SX0095 LICENSED PROGRAM: 4STMEXP - Slipstream V1R1M0 ------------------------------------------------------ : SYSTEM : RELEASE : LEVEL : RECOMPILE : LIBRARY : : : : MIN/MAX : : : : : : : : : : 4STMEXP : V4R1M0 : 00/00 : N :STMEXPV4R1: ------------------------------------------------------ PRE/CO-REQUISITE PTF/FIX LIST ----------------------------- REQ LICENSED PTF/FIX LEVEL TYPE PROGRAM REL NUMBER MIN/MAX OPTION ---- -------- --- ------- ------- ------ NONE - PTF IS CUMULATIVE AND INCLUDES ALL PREVIOUS FIXES DESCRIPTION OF CHANGES : ---------------------- ORIGINAL FIX ISSUE PTF ID DATE NUMBER DESCRIPTION OF CHANGE ------ ---- ------- ---------- 4SX0095 2009-12-23 Issue caused by change 4SX0090 below. Excel format strings corresponding to the edited form of fields with edit codes which print spaces for zero values were being output with # for digits after the decimal point rather than 0, causing misalignment of values due to zero suppression after the decimal point. 4SX0094 2009-12-15 Option to output to an FTP server not handling a multi-line response from the FTP server that included a line shorter than 3 characters (the size of a response code). 4SX0093 2009-11-21 ***************************************** ****** Windows 7 Compatibility fix ****** ***************************************** Excel files created by Slipstream were giving an error when opened under Windows 7. The problem seems to relate not to the Excel data stream itself but to the OLE Compound File "wrapper" in which that data stream is enclosed. It is probable that a minor formatting error in this wrapper, which was tolerated/handled by earlier versions of Windows is now no longer tolerated/handled, perhaps because it is considered a potential security exposure? The way in which the OLE Compound File wrapper was built had already been rewritten ready for the next release of Slipstream (assisted by Microsoft finally releasing proper documentation for this file format) and in order to support Windows 7 we are releasing those changes earlier than previously intended as they appear to address Windows 7's issue. 4SX0092 2009-10-22 New method of parsing SQL queries for FROMFILE(*QMQRY), FROMFILE(*SQL) and FROMFILE(*SQLSRC) options to improve the reliability of the analysis of query columns. Previously errors such as edit codes being applied to the wrong column were possible. 4SX0091 2009-10-02 Fix to handling of files that contain text fields using different CCSIDs. Previously, a memory error could occur. 4SX0090 2009-09-02 Correct the editing of numeric fields with decimal places that are associated with edit codes that suppress zeros. Previously these were showing ".00" rather than blanks for zero values. 4SX0089 2009-09-02 Fix to 4SX0088 which corrected the selection of worksheets but caused an issue with frozen heading lines. 4SX0088 2009-09-01 When CVTDBFSTMF STMFOPT(*ADD) is used to create workbooks with multiple worksheets, both of the first two worksheets were selected when the file was first opened. 4SX0087 2009-08-21 Add SQL naming option to SQLSRC parameter to allow specification of the naming used in a SQL source member. 4SX0086 2009-05-03 Fix handling of Query final break text. 4SX0085 2009-05-02 Fix SQL error resulting from bug in previous change. 4SX0084 2009-04-29 Fix SQL "Value of column or variable XXXX too long" error that occurred when a COUNT function was used in a query on an alpnumeric field smaller than 10 characters. 4SX0083 2009-04-28 Fix MCH3601 "Pointer not set for location referenced" error when using INCLFLD parameter with a multi-format logical file. 4SX0080 2009-04-15 "Receiver value..." error when using XLSPROTECT parameter. 4SX0079 2009-03-31 Query/400 final level text not being output if there are no level breaks. 4SX0078 2009-02-18 Fix SQL error that occurred when processing a Query/400 with no sort fields. 4SX0077 2009-02-14 Where numeric editing has been applied in Query/400, give priority to that editing not the EDTCDE or EDTWRD defined in the Query outfile. 4SX0076 2009-02-12 Fix issue where Excel headers not frozen on new worksheets added when STMFOPT(*ADD) specified. Add options to EXCEL parameter "Apply column formatting" which allow the user to request that formatting should not be applied at the column level. This avoids column-level formatting being applied to unused cells. 4SX0075 2009-02-06 Correct problem interfacing between Slipstream and Communique which resulted in CMQ9054 error when a long file name was specified on the TOSTMF parameter. 4SX0074 2009-02-05 ! WITHDRAWAL OF SUPPORT FOR BIFF 5 EXCEL ! CVTDBFSTMF no longer supports output to Excel 95 BIFF5 format. This is because an issue with that support has been identified and support for BIFF5 is being withdrawn in the next release in any case. We believe that this is unlikely to affect any customers as it is our understanding that the BIFF5 support is redundant. 4SX0073 2009-02-05 Add maximum rows per worksheet to EXCEL parameter. 4SX0072 2009-01-23 Orientation specified on CVTDBFSTMF XLSPRINT parameter not being processed correctly, resulting in orientation always being landscape. 4SX0071 2009-01-14 Fix SLP9023 error when a QM Query has an ORDER BY clause containing a CASE statement. Fix retrieval of headings and editing from QM form. 4SX0070 2008-11-17 Fix MCH1210 "Receiver value too small to hold result" error when using CVTDBFSTMF ... STMFOPT(*ADD) on an existing spreadsheet containing long rich-text strings. 4SX0069 2008-11-09 Fix "Memory pool is zero" error caused by previous change when converting an empty file. 4SX0068 2008-10-28 Fix SLP9995 (SQL0407) error when using FROMFILE(*QRYDFN) and the query selects no data. Add option to specify individual heading text for each field defined on the INCLFLD parameter. Fix MCH1210 "Receiver value too small to hold result" error when switching to a new worksheet because the previous worksheet is full. 4SX0067 2008-10-09 Fix MCH1210 "Receiver value too small to hold result" error when converting a multi- format logical file to Excel format. 4SX0066 2008-10-08 Fix MCH1210 "Receiver value too small to hold result" error when converting a join logical file to Excel format. 4SX0065 2008-09-19 Fix CPF2817 when CVTDBFSTMF run a second time in the same job and a CLRLIB of QTEMP is done in between. 4SX0064 2008-07-16 Add element to HEADER parameter of CVTDBFSTMF command to control the appearance of column headings on overflow worksheets. 4SX0062 2008-06-05 XLSPRINT element "Print header row on each page" not working on sheets after the first. XLSPRINT element "Print header row on each page" not taking account of additional header lines. 4SX0061 2008-06-05 Add support for Slipstream variables. Fix bug where print headings where being duplicated into the printer footers if no print footers were defined. 4SX0060 2008-04-18 When processing a field alias as a column heading, conversion of the text to mixed case was not correctly handling leading quotes (subsequently removed). . 4SX0059 2008-04-13 Fields in database files created as outfiles from Query/400 with special numeric editing no correctly converted to Excel cells formatting when the job DECFMT attribute . I or J. 4SX0058 2008-03-05 Fix MCH1210 "Receiver value too small to hold result" error message when converting to Excel format and using the "addtional header lines" option of the HEADER parameter. 4SX0057 2008-01-22 ARI7008 ("Unable to update") message being sent unnecessarily when the OLE file contains a CompObj stream. The message is now only sent if the file contains other unhandled streams and storages in addition to the CompObj, e.g. VBA macros. 4SX0056 2008-01-19 Add STMFOPT(*RPLXLSSHT) option to specify that new Excel worksheet data should replace one or more existing worksheets. 4SX0055 2008-01-09 Fix SLP9023 error when parsing a QM query. 4SX0054 2007-11-29 Allow *CURRENT for EMAILTO parameter elements "email address" and "email name" in order to allow the retrieval of this information from the system directory so the email can be sent to the user running the command. 4SX0053 2007-11-29 Remove double quotes from column headers when processing FROMFILE(*SQL) or FROMFILE(*SQLSRC). Also convert spaces to breaks. 4SX0052 2007-11-20 Fix MCH3601 "Pointer not set for location referenced" error when an email-related error is detected in the command validity checker. 4SX0051 2007-11-10 Heading row not frozen on Excel worksheets created with CVTDBFSTMF...STMFOPT(*ADD). 4SX0050 2007-09-27 a) Fix SQL error that occurred when a Query/400 query was being processed in *COMBINED mode and the query had summary fields with decimal places. b) Fix "Unable to replace file" error when processing STMFOPT(*ADD) with TOFMT(*XLS) and TOSTMF(*FTP). 4SX0049 2007-09-25 Fix SL_VldLicFnc variable length error. 4SX0047 2007-09-17 When determining whether a numeric field should be considered a date field, allow edit words including zeros as well as blanks and date separator characters to trigger conversion of a field to a date. 4SX0046 2007-09-06 If a variable value specified on the QMQRY parameter is enclosed in apostrophes, leave them in place rather than stripping them off, if the value is numeric. This is in order to cope with the fact that SQL seems to insist that character variables are compared to character literals on V5R2M0 and earlier (but not on V5R3M0 and later). The user will need to set the apostrophes appropriately. 4SX0045 2007-08-31 Fix to SLIPSTREAM menu to avoid SYS3801 error when menu commands require prompting and he job is running in the S/36 environment. 4SX0044 2007-08-31 Change to the conditions under which Slipstream will consider a numeric field to be a date. Fields edited with edit code W are now included (along with edit code Y and 9 and edit words that look like a date). 4SX0043 2007-08-10 Further fix to handling of Query/400 queries with a large number of sort fields. 4SX0042 2007-08-09 Fix to potential SLP9006 error when processing FROMFILE(*SQLSRC) caused by not processing source files with record lengths < 92 correctly. 4SX0041 2007-08-09 Fix to RNX0100 "Length or start position is out of range" error when processing a Query/400 query with 8 or more sort fields (retrieved QM query source has sort field and sort sequence on different source lines). 4SX0040 2007-08-02 QM query variable values not being handled correctly where the value started with a number but was not all numeric. 4SX0039 2007-07-10 Fix "varying length string" error when grace period has expired. 4SX0038 2007-06-16 Add option to email output files as zip archives, with optional encryption/password protection. 4SX0037 2007-05-14 Modify the structure used to communicate FTP parameters to CoolSpools to ensure that it is compatible with versions of CoolSpools without PTF 5CV0116 and above. 4SX0036 2007-05-12 a) Conversion to PDF with TOSTMF(*FTP) not working correctly. b) Send the correct completion message when converting to PDF with TOFMT(*FTP). 4SX0035 2007-05-10 a) When converting to PDF, determine the job in which the spooled file was created rather than assuming the current job. This is intended to avoid issues that can arise when the CVTDBFSTMF...TOFMT(*PDF) command is run in an HTTP server job. b) Fix CCSID error when outputting the header in HTML. 4SX0034 2007-05-08 When converting to PDF, the spooled file that is created (SL_SQLOUT) is now owned by the original user in the job. This is intended to avoid issues that can arise when the CVTDBFSTMF...TOFMT(*PDF) command is run in an HTTP server job. 4SX0033 2007-04-17 New element "Trim blanks" for CSV parameter allowing control over whether blanks are trimmed from alphanumeric fields when outputting to CSV format. 4SX0031 2007-04-16 New *NONE option for the "Positive sign" element of the FIXED parameter. This lets you tell Slipstream to output numbers with no sign marker in front of them. N.B. Positive and negative numbers are indistinguishable in the output file if this option is selected. 4SX0030 2007-03-28 XLSPRINT enhancements: margins, headers, footers. HEADER enhancements: 0-3 free-format headings. EXCEL enhancements: column width option *AUTOFIT. 4SX0029 2007-03-14 TOFMT(*PDF) option not taking account of the member specified and always processing the first member. 4SX0028 2007-03-13 Add XLSPRINT, XLSADJUST and XLSFITPAGE parameters allowing Excel print options to be specified. 4SX0027 2007-02-26 Fix variable length string error when converting a file that uses double-byte CCSIDs 4SX0026 2007-02-20 Add XLSPROTECT parameter allowing protection of Excel worksheets. 4SX0025 2007-02-13 1. Support for STMFOPT(*ADD) with TOFMT(*XLS). Data is added to the existing spreadsheet as a new worksheet. 2. Allow setting of Excel font name and size using new elements of the EXCEL parameter. 4SX0023 2007-01-17 Unreadable Excel file being generated in some circumstances (where the file requires exactly 128 OLE sectors). 4SX0021 2007-01-12 Fix to the handling of multi-line FTP server responses. 4SX0019 2006-12-27 Add STMFOPT(... *NO) option to indicate thatam Slipstream should not create empty files when no records are converted. 4SX0018 2006-12-20 DBFDATFMT(*ENVVAR) now the default. Slipstream checks for an environment variable called SL_DBFDATFMT and takes the date format from there if it is found. 4SX0017 2006-12-13 Extend email subject line from 50 to 256 characters. Extend email message from 512 to 4096 characters. Add support for taking message text from a stream file. 4SX0016 2006-12-13 Further fix to 4SX0013 (a) below. Pointer error occurring if no special editing defined 4SX0015 2006-12-12 Fix to 4SX0013 (a) below. Make *NO the default for "Line breaks in Excel headers" option of HEADER parameter. 4SX0014 2006-12-12 This PTF number not used. 4SX0013 2006-12-07 a) Handle unusual editing definition on Query/400 outfile fields. b) Rename RUNCMD to RUNMNUCMD to avoid conflict with MIMIX object. 4SX0012 2006-11-11 Variable-length field not being converted if the last field in the record. 4SX0011 2006-11-02 Fix "Receiver value..." error when converting large binary values to *FIXED. 4SX0010 2006-10-26 Add option to HEADER parameter to allow linefeeds in Excel column headings to be switched off. 4SX0009 2006-10-05 SQL error when query had group-by fields but no order-by fields 4SX0008 2006-09-06 Output UTF-8 byte order marker x'EFBBBF' when STMFCODPAG(*UTF8) and UNICODE(*N *YES) specified. 4SX0007 2006-07-04 Changes to format of summary output. New *PRINTER option which attempts to recreate the format of printed queries more closely is now the default. Changes to editing/formatting of numeric values from Query/400 to try to reproduce the format of printed data more closely. 4SX0006 2006-06-09 SL025 Excel crashing when styles referenced due to incomplete definition of BIFF STYLE records. 4SX0005 2006-05-15 TOFMT(*PDF) fixes. 4SX0004 2006-05-13 TOFMT(*PDF) fixes. 4SX0003 2006-03-15 SQL naming option not working correctly. 4SX0002 2006-02-26 Add TOFMT(*PDF) option (requires CoolSpools) 4SX0001 2006-02-18 Add logging options. When outputting to an FTP server and emailing a file, attach the file with a name dervied from the FTP path name. CIRCUMVENTION : ------------- None. ACTIVATION INSTRUCTIONS : ------------------------- None. SPECIAL INSTRUCTIONS : ---------------------- None. DEFAULT INSTRUCTIONS : ---------------------- THIS IS AN IMMEDIATE PTF. SUPERSEDES PTF/FIX NO(S). APAR TITLE LINE -------------- ----------------------------------------------------------- NONE