*********************************************************************** *** 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/CoolSpoolsPTF.htm for details of the conditions under which you apply PTFs, the procedure to follow and the precautions we advise. *********************************************************************** *** 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 each installed option of licensed program 6COOLSP and a SAVLIB of library COOLSPV6R1 before applying PTFs in order to allow a recovery option in the event of corruption or failure. If PTFs are installed using the utilities provided (RTVFIX, LODFIX, APYFIX commands), these precautions are taken automatically. *********************************************************************** 6COOLSP CoolSpools V6R1M0 FIX PACK#: 032 LICENSED PROGRAM: 6COOLSP - CoolSpools Plus V6R1M0 ------------------------------------------------------ : SYSTEM : RELEASE : LEVEL : RECOMPILE : LIBRARY : : : : MIN/MAX : : : : : : : : : : 6COOLSP : V6R1M0 : 00/00 : N :COOLSPV6R1: ------------------------------------------------------ PRE/CO-REQUISITE PTF/FIX LIST ----------------------------- REQ LICENSED PTF/FIX LEVEL TYPE PROGRAM REL NUMBER MIN/MAX OPTION ---- -------- --- ------- ------- ------ NONE - FIX PACK IS CUMULATIVE AND INCLUDES ALL PREVIOUS FIXES DESCRIPTION OF CHANGES : ---------------------- FIX PACK DATE DESCRIPTION OF CHANGES -------- ---- ---------------------- 6CP0032 2010-06-18 ST_TRNRUL replaced by ST_TRNSTP. The PTF exit program will install a new physical file ST_TRNSTP which replaces physical file ST_TRNRUL. The contents of ST_TRNRUL will be copied to new file ST_TRNSTP. !!! N.B. If you are running a High Availability product such as MIMIX or Data Mirror, you may need to review your setup to ensure that ST_TRNSTP is replicated correctly. !!! New method of building fix packs to minimize the amount of data that needs to be downloaded. 6CP0034 2010-06-24 Add option to force conversion of alpha fields to numeric cells (CVTDBFXL command APYSTYLES parameter) Option to check for Excel formulas in character fields when using CVTDBFXL to output to *XLSX. 6CP0033 2010-06-21 New method of building fix packs to minimize the amount of data that needs to be downloaded. 6CP0031 2010-06-15 Correct logical file dependencies. Code signing. 6CP0030 2010-06-11 Fix bug in reading of OLE directory streams. 6CP0029 2010-06-10 Gather additional diagnostics for Excel build failure. 6CP0028 2010-06-09 "Divide by zero" error when processing PCL font file which contains a PCL data stream rather than just a font definition. 6CP0027 2010-06-07 Problem with ownershop of stream files included in PTF. 6CP0026 2010-06-07 Problem with ownership of stream files included in PTF. 6CP0025 2010-06-05 Fixes to digital signature function. 6CP0024 2010-06-04 Reinstate java files missing from previous. Add OPTIONS() parameter to CVTSPLxxx command to allow future expansion. Remove EMAILCFM and EMAILRPY commands and replace by new *CFM and *RPY options on EMAILTO parameter. Performance enhancements to MRGPDF command. 6CP0023 2010-05-14 Reinstate option to override column headings on INCLFLD parameter of CVTDBFSTMF command for reasons of backwards compatibility. More customers are using this feature than we had realized. In relation to the format-specific commands, CVTDBFXL, CVTDBFXML, CVTDBFHTML etc., the APYSTYLES parameter should be used instead. 6CP0022 2010-04-24 New features that had previously been made available only on CVTSPLXL are now also available from CVTSPLXLS. These include: - split to new worksheet - applying styles (note that CVTSPLXLS will not support the DFNSTYLES parameter and styles must be defined externally to the command string using CRTSTLDFN) - conditional formatting - control of column widths with COLWIDTHS parameter LINTYPES parameter has been extended to allow the definition of a line type name which can then be referenced on the APYSTYLES and CNDFMTGRP parameters to apply styling and conditional formatting to different line types. 6CP0021 2010-04-21 Fix attributes of program AR_FNCCTLR to avoid authority issues relating to registered functions. Fix issue with spurious blank page in PDF created from a PCL spooled file. The spooled file uses the PCL "Duplex page side selection" instruction in a spooled file which is not duplex. The PCL technical manual says this causes the current page to be jected, so a new page was being started, but this does not appear to be correct. Do not do a page throw in these circumstances if the first page is being processed and it is currently empty. 6CP0020 2010-04-19 Some objects missed from previous. 6CP0019 2010-04-13 Add support for parameter sets. 6CP0018 2010-03-26 Update two objects not included in previous. 6CP0017 2010-03-26 Replace BORDER parameter of CRTSTLDFN etc. commands with separate parameters for each border: TOPBDR, BOTTOMBDR, LEFTBDR and RIGHTBDR. This supports the setting of separate border styles, colors and (for HTML/XML) thicknesses for each of the top, bottom, left and right borders of a cell. This feature is only available through the use of user- defined, named styles created using CRTSTLDFN, and will not be supported on the DFNSTYLES parameter of CVTSPLXL, CVTDBFXL, CVTSPLXML or CVTDBFXML. Support the use of currency symbols and negative styling with the *GENERAL number format. Form type not being displayed by WRKSPLFPDM. FORMTYPE and USRDTA parameters of WRKSPLFPDM RUNSPLFCMD, CRTSPLRUL. CHGSPLRUL and CPYSPLRUL revert to mono case. This means that to select lower-case values, quotes must be coded around the parameter value, e.g. FORMTYPE(invoice) will select form type "INVOICE" but not "invoice", which would need to be specified as FORMTYPE('invoice'). This is intended to bring the commands into line with IBM's CHGSPLFA, CRTPRTF etc. 6CP0016 2010-03-22 CVTDBFSTMF/CVTDBFXL not setting print options correctly where XLSPRINT(*NO...) specified. Fix pointer error that occurred if an non-existent field was referenced on the APYSTYLES parameter. Fix "invalid value for MSGID" error that occurred when using the .EXE install program to install a product option other than *BASE or All options individually. Capture additional logging infrmaiton during the installation process. 6CP0015 2010-03-19 CVTDBFSTMF not setting columns widths correctly where was converted entirely to blank (null) cells because the corresponding database field was all blanks/nulls. When printing an Excel spreadsheet from versions of Excel prior to Excel 2007, n extra column was appearing because the last column field in ROW records was being set incorrectly (column numbers are counted from zero). Add option to control the appearance of zero balances to DFNSTYLES parameter and CRTSTLDFN etc for compatibility with edit codes. Adjust calculation of column widths. Allow an additional 2 characters for numeric and date columns beyond that which sould be strictly necessary to handle the fact that Excel appears to miscalculate column widths when printing. For example, a 10-digit number in a column set to a width of 10 (or even 11) characters appears as ########## when printed. 6CP0014 2010-03-17 CVTDBFSTMF not setting print options correctly. Minor adjustments to calculation of columns widths where *AUTOFIT selected. Below 10 characters, the width of a W is used. Above 50 characters, the width of a 9 is used. In between, the width is based on a sliding scale between the two. Fix pointer error when running IMPADMDTA. 6CP0013 2010-03-15 Fix to handling of output from CVTDBFSTMF and CVTDBFXL commands when FROMFILE(*QRYDFN) used. Add new output option *MIXED which produces a simple output file containing both detail and summary records. This is an alternative output style to the *COMBINED output form which produces a more complex output file containing summary-level text from the query. 6CP0012 2010-03-11 Update APYFIX to check for locks on base menu. Update PTF exit programs to ensure all database files have contents preserved. Fix CS_RPTLIN database relationships. Fix default for column width when EXCEL parameter not specified. Fix RTF issue related to 5CV0220. Where an underscore is followed by numeric text data, an invalid RTF data stream was being generated, causing text to disappear. Ensure that a space is output between the end of the RTF code and the following text. 6CP0011 2010-03-10 Fix "Duplicate variable name" error when validating EXITPGMPOS and/or EXITPGMKEY parameters. Fix formatting of CVTDBFSTMF/CVTDBFXL headings derived from query heading text. Improve calculation of Excel column widths. Don't apply default edit code to date fields. Change command defaults: 1) CVTDBFSTMF QRYDFN output form is *RUNOPT (for compatibility with V4 of Slipstream). CVTDBFxxx QRYDFN output form is *COMBINED (for improved output formatting). 2) Default option for column width now *AUTOFIT as this gives better results on the whole than *FIELDSIZE. Fix signature violation on some programs e.g. WRKSPLFPDM abnd CVTSPLTXT. 6CP0010 2010-03-05 Fix to decimal data error when emailing using CVTDBFSTMF. Fix to array index error when using CVTDBFSTMF or CVTDBFXL to convert a Query with subtotalling to Excel. Modifications to product packaging to address issues with installing on systems where the primary language is not English. 6CP0009 2010-03-02 Fix to DSPSPLTXT. Install procedure changes. 6CP0008 2010-02-26 Modifications to usage tips. Show usage tips for CoolSpools Database. Add options to PRTSTMF command to allow PJL initialization and reset commands to be sent to the printer. 6CP0006 2010-02-20 A. New features: 1. CVTXLDBF can now extract the latest calculated value of cells containing formulas from Excel 97-2003 workbooks as well as Excel 2007 workbooks. Improvements have also been made to the TOFILE(*FROMSTMF) and TOMBR(*FROMSTMF) options to ensure that a valid OS/400 file or member name is generated. Characters invalid in an OS/400 object name are now converted to underscores, except at the beginning of the name, where they are converted to hash symbols (#). 2. DSPPRDINF command (option 6 from Base Menu) now displays details of licensing and support and maintenance contracts, as well as the code and PTF levels. 3. New email option *EMBMSG added to SNDCMNMSG, CVTSPLTXT and CVTSPLHTML commands. This is intended to overcome (or at least provide a workaround for) the known issue with Outlook, which does not properly implement the MIME "Content-disposition: inline" instruction and displays files as attachments when the *EMBED option has been used. *EMBMSG works by combining the file contents with the text of any associated message (MSG, EMAILMSG parameters) to create a single, merged message text. 4. Help text added to several commands, notably those relating to report definitions, report lines, report items and report sections. Also on screen help is now available within the "Design Report Definition" function. B. Fixes: 1. PTF files are now owned by QDFTOWN not ARIADNE. LODFIX now handles ownership issues better. Ownership problems were causing LODFIX to fail. 2. A problem in the install process was identified which was causing registered functions not to be registered correctly. The install process was trying to use the product message file before it had been installed. The workaround where registered function problems are occurring because of this is to reinitialize them by running: ADDLIBLE COOLSPV6R1 CALL COOLSPV6R1/CP_INZFNCR 6CP0005 2010-02-02 A. New features: 1. New Automatic Spooled File Processing wizard (CFGSPLMON command) to simplify the setting up of automatic spooled file processing. 2. Ability to specify user-defined names for variables defined on the EXITPGMPOS and EXITPGMKEY parameters of CVTSPL... commands that can then be referenced as CoolSpools variables of the form <:user_var_name:> 3. New methods of specifying the email addresses to be used when sending emails from CoolSpools Spool Converter: a) EMAILTO(*EMAILFILE) and new EMAILFILE parameter allow the specification of a file and associated keys. Email addresses are read from the file at run time. Works with CoolSpools variables to allow the selection of different email addresses for different sections of the spooled file. b) EMAILTO(*EMAILSQL) and new EMAILSQL parameter allow the specification of an SQL statement. Email addresses are retrieved by executing the SQL statement at run time. Works with CoolSpools variables to allow the selection of different email addresses for different sections of the spooled file. c) EMAILTO(*USRDFNDTA) allow the use of the spooled file user-defined data attribute to store one or more email addresses to be used. B. Fix handling of Code 128 barcodes where the height is the special value x'FFFF'. C. Fix to handling of DDS AFPRSC keyword used with *SIZE option. D. Fix spurious CVT5340 where INCLFILE used with a PCL spooled file. 6CP0004 2010-01-29 Add support for new environment variable CS_AFP_OVL_RTT controlling whether overlay rotations are ignored or not. Host Print Transform and many AFP printers do not support overlay rotations. Where a customer has an application that specifies an overlay rotation, which CoolSpools by default implements, but the customer's printer does not handle overlay rotations, the results CoolSpools produces may not be what the customer expects. Overlay rotations are now ignored unless implemented unless CS_AFP_OVL_RTT = *YES. 2010-01-12 Address further issue with misalignment of overlays on spooled file with PAGRTT(90) and DUPLEX(*YES) where the front page is not rotated and the back page is rotated. Apply margin adjustments on rotated page only. At present this only happens if environment variable CS_APY_PAG_RTT_MGN is *YES. 2010-01-11 Address issue with misalignment on overlay on a rotated page caused when CVTSPLPDF ... PRTDEV(*SYSVAL) is used on a system where the QPRTDEV system value is not set to the name of an actual printer device. Consequently margin settings were not being properly established. Default margins to a common set of values. 6CP0003 2009-01-29 Test PTF. 6CP0003 2009-01-08 Test PTF. 6CP0002 2009-01-05 Test PTF. 6CP0001 2009-12-31 Test PTF.