are removed if not (
, , , ,
, , , - ).
6CP0102 2011-03-08 CVTDBFXL incorrectly setting styling on detail rows
as if they were totals.
6CP0101 2011-03-03 CVTDBFXL not setting print area correctly where
hidden columns exist and there are subtotal or total
rows.
Not setting styling correctly on subtotal and total
rows where column related to a level break field at
a higher level.
CVTDBFXL giving a pointer error if STMFOPT(*ADD)
specified in conjunction with TOSTMF(*FTP) and the
file specified on the FTP() parameter did not
already exist.
If STMFOPT(*NONE) specified in conjunction with
TOSTMF(*FTP) and the file specified on the FTP()
parameter already exists, return an error message.
Where query has a variable referenced in break level
text for the final totals break, obtain value of
variable from previous record.
Experimental: option to output fields in the order
in which they are defined in the query by setting
environment variable CS_QRY_FLD_SEQ to *QRYDFN.
6CP0100 2011-03-02 Fix bug where exit programs called at the *STMFEND
exit point from the CVTSPLXLS and CVTSPLXL commands
were being passed the variables for the next stream
file, not the one just processed.
When CVTDBFxxx FROMFILE(*QRYDFN) used, and
conversion of the Query/400 query to a QM query
results in field column headings such as
COUNT_field_name or TOTAL_field_name, avoid
allowing the field name to appear as the column
heading when better text is available.
6CP0099 2011-03-01 Fix error CVT3001:
"Value *POS for field saCol01Method in structure
CS_COL01 is invalid"
Add options to DSPPRDINF to generate a product
status report and send it to ariadne.
When creating a Database-to-Excel map or Database-
to-XML map, and the input is taken from an SQL
source member, previously if *LIBL was specified
for the name of library in which the source file
existed, the source member had to exist in the
first instance of the source file in the library
list. Now, the library list will be searched and
all instances of the source file checked for the
member name in question.
6CP0098 2011-02-21 When processing a query that runs in *SUMMARY mode,
CVTDBFXL was taking certain attributes e.g. edit
codes from the wrong column. Correct this and other
issues related to the processing of *SUMMARY
queries, especially when CVTDBFXL ...
QRYDFN(... *RUNOPT ...) is used.
Fix to decimal data error when processing a barcode.
Fix to handling of digital certificates where the
first alias does not correspond to a private key.
Solves JVM crash when applying a digital signature
to a PDF.
Use of CVTSPLxxx EMAILMSG(*N) and CVTDBFxxx
EMAILMSG(*N) was generating a message consisting of
a single space character, enough to stop Outlook
displaying *EMBEDded attachments inline. Now
EMAILMSG(*N) will produce a message with no message
body.
Reinstate the CVTSPLTXT EMAILOPT( ... *MSGTXT ...)
option inadvertently lost on the move to V6.
New option to specify a user-defined preamble and
"postamble" to the HTML version of email messages.
Where they exist, these are used in place of the
standard system-supplied preamble and postamble
which wrapper a plain text message to create an
HTML version of it and can be used to do things
like changing the font in which the message appears.
The standard system-supplied preamble is
which sets the font to Arial.
The standard system-supplied postamble is
To create a user-defined HTML preamble, create
environment variable CS_EMAIL_HTML_START
To create a user-defined HTML postamble, create
environment variable CS_EMAIL_HTML_END.
For example, if the premable were defined as
the HTML version of messages would a larger font than
otherwise and that font would be Courier not Arial.
If you use this feature, it is your responsibility
to ensure that a valid HTML document results,
otherwise the message may not display correctly.
6CP0097 2011-02-18 Modify method of validating SQL statements in order
to avoid issues that can arise in environments
where the decimal point is a comma.
Fix array index error when STMFOPT(*ADD) used with
CVTSPLXL.
Add EXCLROWGRP parameter to CVTSPLXL to allow
exclusion of row groups based on the value of
report items.
When CVTDBFxxx is used with FROMFILE(*QRYDFN) and
the Query/400 query is run in *SUMMARY mode, ensure
that the output is processed in arrival sequence
unless a SORT() parameter is specified.
6CP0096 2011-02-15 Problems with FROM(*CURRENT) and EMAILFROM(*CURRENT)
causing CPF3C12 "Length of data is not valid."
Fix calculation of margins in spooled files where
some pages are landscape and others portrait.
Fix string error when the length of data specified
for a data item on the EXITPGMPOS command is
longer than the length of a line of text.
6CP0095 2011-02-04 Changes to ensure that, when CoolSpools functions
are being applied to a piece of data, any "special"
characters in that data (specifically, those used
as part of the syntax for calling the function,
e.g. parentheses () and commas, are not
misinterpreted as part of the function call.
Fix to handling of CCSID conversions when
retrieving current user's email address and
name from the system directory in CRTCMNMSG.
When processing CVTSPLPDF TOSTMF(*VIEW|*PRINT),
the temporary file used now has an extension of
.PDF rather than .TMP.
6CP0094 2011-02-02 Further Excel 2010 issues.
When CVTDBFXL, CVTSPLXLS or CVTSPLXL was being used
with STMFOPT(*ADD), the EXTSST record was being
duplicated. Excel 2010 opened such files in
"Protected View" as a consequence.
Fix offset to DEFCOLWIDTH record in Excel INDEX
record for existing worksheets when STMFOPT(*ADD)
used.
6CP0093 2011-02-01 Changes to address some issues with Excel 2010.
When CVTSPLXLS or CVTSPLXL was used with splitting,
the OLE header of files after the first was
not being entirely reinitialized. The resultant
slight mis-formation was giving a file open
error, but only in Excel 2010 (the problem
was not apparent with earlier versions of Excel).
Correct the generation of the internal Excel
INDEX record. Again, this issue was not apparent
with earlier versions of Excel but was causing
Excel 2010 to open files in "Protected View"
if the total number of rows in an Excel 97-2003
*XLS workbook exceeded approximately 67,000.
New option on CHARSET parameter of SNDCMNMSG to
control whether or not CoolSpools attempts to
harmonize the encoding of the various parts of a
multipart email by converting them all to a common
character set (typically UTF-8). This is intended
to address the issue with certain
Microsoft client email systems such as Outlook
and Windows Mail that the character set of the
message is taken from the first part of the message
and the charset attribute of later parts is ignored.
The default for the CHARSET parameter is now
*ENVVAR, allowing users to control the encoding
through an environment variable CS_EMAIL_DFT_CHARSET.
If this is not set, the default is now *CALC, which
will use ISO ASCII Latin 1 is the CCSID of the job
is Latin 1, otherwise UTF-8.
6CP0092 2011-01-27 When attaching a database file member to an email
using SNDCMNMSG, take account of the possibility
that member could be in a file in an independent
ASP.
Fix to TOSTMF(*EMAIL) option. Incorrect file name
was being used.
Change the method of generating temporary file
names to avoid issues with tmpnam() not producing
unique names system-wide.
Changes/additions to CoolSpools variables:
1) CURUSER, CURUSEREMAIL, CURUSERNAME and
CURUSERHOME are all now based on the current
user of the job, not job user profile. In most
cases these are the same, but it is possible for
them to be different, e.g. HTTP server processing
requests for different users.
2) New variables JOBUSER, JOBUSEREMAIL, JOBUSERNAME
and JOBUSERHOME now provide the functionality
previous provided by CURUSER, CURUSEREMAIL,
CURUSERNAME and CURUSERHOME.
3) New variables added:
SRLNBR (system serial number)
SYSNAME (system name from the network attributes)
HOSTNAME (host name from the TCP/IP attributes)
DOMAIN (domain name from the TCP/IP attributes)
4) Variables added for system directory attributes:
CURUSERDIRxxx Attribute xxx for current user
JOBUSERDIRxxx Attribute xxx for job user profile
SPLUSERDIRxxx Attribute xxx for spooled file user
OWNUSERDIRxxx Attribute xxx for spooled file owner
In each case xxx is the name of an attribute from
the system directory (see Search System Directory
QOKSCHD API for a list).
For example, to retrieve the preferred name of the
spooled file owner, use variable name
<:OWNUSERDIRPREFNAM:>
6CP0091 2011-01-26 Unless environment variable CM_SLT_SYS_DIR is set to
*NO, the system directory will now be available
as an email address directory from which you can
select email addresses (SNDCMNMSG, CRTCMNMSG etc.)
just as you can from CoolSpools Email
address directories.
6CP0090 2011-01-19 Fix to setting of style for title text lines
defined on HEADER parameter. The styling
associated with the detail line column was still
being used instead of *TITLE if an APYSTYLES was
defined for the final column.
Changes to the handling of email attachments.
By default, non-binary files attached to an email
will be sent in their original encoding, with no
data conversion performed, unless that original
data is encoded in EBCDIC, when it will be converted
to an appropriate equivalent ISO ASCII CCSID.
There is now a new option on the ATTACH parameter
of SNDCMNMSG and a new CM_A0300 attachment format
permitting the specification of the CCSID in which
the attachment should be sent.
This is intended to fix a number of issues,
including:
a) Attaching EBCDIC database file members as
*TEXT or *CSV was incorrectly sending the data
as EBCDIC since 6CP0086.
b) ASCII text files were being re-encoded as UTF8
by default.
6CP0089 2011-01-18 Fix to CVTDBFXL and CVTDBFSTMF HEADER() options
*COLHDG1, *COLHDG12, *COLHDG13, *COLHDG2, *COLHDG23
and *COLHDG3, which were not be processed correctly
and were producing the same output as
HEADER(*FLDNAM).
Fix to setting of style for title text lines
defined on HEADER parameter. The styling
associated with the detail line column was being
used instead of *TITLE.
6CP0088 2011-01-11 When CVTDBFxxx FROMFILE(*SQLSRC) was being used to
process SQL statements stored in a SQL source
member and SQLSRC(*LIBL/file_name mbr_name) is
specified, an error was being returned if the
specified member (mbr_name) was not found in the
first instance of file file_name in the library
list. Logic has been modified to look for a
member called mbr_name in other copies of file
file_name in libraries lower down the library
list as well.
Fix declaration of character set in the MIME header
of the HTML portion of a multipart email.
6CP0087 2011-01-05 When converting to Excel 97-2003 format, if the
number of rows generated exceeded a certain
threshold (unpredictable, but around 300,000),
causing the Excel index to overflow into a second
or subsequent continuation record, a variable
length string error occurred (due to memory getting
corrupted by being overwritten. Now fixed.
Fix erroneous SLP4232 message when EXCLFLD
parameter of CVTDBFXL is used and a record format
is specified.
When using CVTDBFXL with the *QRYDFN option,
the "Summary line style" option *PRINTER now
suppresses the break level field completely
in the same way as the *EXCLUDE option.
Correct the setting of free-format header lines
specified on the HEADER parameter of CVTDBFXL.
Where fields were excluded automatically e.g.
dummy fields used for processing queries and
Query/400 summary fields BREAKLVL and OVERFLOW,
the number of columns to merge was not being
calculated correctly.
Fix to handling of AR_ERR_ACTION (see 6CP0085
below) from CVTSPLxxx: emails being sent when
not error has occurred.
Support the use of environment variables
AR_ERR_FROM_EMAIL and AR_ERR_FROM_NAME
to allow the setting of the sender email address
and name for the error emails.
6CP0086 2011-01-05 When opening an Excel 2007 .xlsx file created with
CoolSpools, the Excel 2003 File Converter is
prompting the user to ask if a recalc should be
performed. Modify setting of workbook calcPr
(Calculation Properties) element to avoid this.
Encoding of text attachments being inadvertently
modified to UTF8. Use Base64 encoding for all
attachments other than inline to avoid this.
6CP0085 2011-01-03 Error handling options.
If you create an environment variable called
AR_ERR_ACTION, you can set it to any of these
values:
1. *EMAIL: email_address
Sends an error message to the email address
following *EMAIL:
2. *ADRL: email_address_list_name
Sends an error message to all of the email addresses
in the email address list the name of which follows
*ADRL:
3. *MSG: qualified_message_queue_name
Sends an error message to the message queue the
qualified name of which follows *MSG:
You can also create an environment variable called
AR_ERR_ACTION_mmmmmmm, where mmmmmmm is a message
ID, to set the error handling action for a specific
message ID. This takes precedence over the generic
error handling action specified by AR_ERR_ACTION.
6CP0084 2010-12-21 Support conversion of character values containing
thousands separators and currency symbol when
converting character fields to numbers using
CVTDBFXL ... APYSTYLES(... *NUMERIC)
6CP0083 2010-12-20 CVTDBFXL fixes.
Text-only map nodes (e.g. headings) not being
output when a new parent node is output.
Fix to handling of color codes expressed as
set of RGB hex values on CRTSTLDFN, OVRSTLDFN
etc.
6CP0082 2010-12-18 CVTDBFXL fixes.
Map nodes not being correctly processed when a
map is in used. Child nodes being not being
populated.
Date formatting not being correctly applied when
a map is in use.
Minor refinements to calculation of text widths
when *FITTEXT option used.
6CP0081 2010-12-15 CVTDBFXL fixes.
Invalid .xlsx being generated when an empty
worksheet is produced (because no records selected)
because the print area was being set to include
a non-existent row 1.
Invalid .xlsx being generated when more than about
300 worksheets added to the workbook because an
internal limit was being exceeded. This limit
has now been removed.
Fix to adding of worksheets to a .xls workbook that
does not contain an EXTERNSHEET record. This was
producing unreadable Excel.
6CP0080 2010-12-14 CVTDBFXL fixes.
Sheet names inadvertently being truncated if they
exceed 26 characters in length. Limit should be 31
(Excel's maximum).
6CP0079 2010-12-12 CVTDBFXML changes.
Where namespace defined at element level, element
was not being closed correctly.
Where namespace defined at element level, namespace
was not being handled correctly when generating
stylesheets and schemas.
6CP0078 2010-12-11 CVTDBFXL changes:
Fixes to setting of column widths for dates and
column to which formatting is applied.
Fix *FITTEXT method of handling column widths
where the font size is different from the default.
Modify "Freeze header rows" option to allow
the specification of a number of rows to freeze.
Fix to hiding of Excel colummns.
6CP0077 2010-12-09 Allow specificaiton of zero-width columns on
CVTDBFXL ... COLWIDTHS() as a convenient means
of hiding a column.
Fix to specification of the last visible column
when outputting to *XLSX format and unused
columns are hidden and a map is in use.
6CP0076 2010-12-07 Change to handling of namespaces when XML is
generated using CVTDBFXML with a map.
Namespace and prefix can now be specified for
each element in the map.
Fixes to error handling when user is not
authorized to add source member to default
source file used for storing SQL statements
when the input source for a database map is *SQL.
Option to specify a different source file to
store SQL statements when input source is *SQL
(specified using environment variable
SL_SQL_SRC_FILE).
6CP0075 2010-12-06 New buitin fonts.
Fix variable length string error when running
ADDDBFXLC with CONTENT(*IMAGE) IMGSRC(*PATH)
IMGCOLUMN(*SELECT)
6CP0074 2010-12-03 Fix to setting of print area by CVTDBFXL. Not
taking account of hidden columns at the right edge
of the page.
Remove PMTCTL from INCLFLDS, EXCLFLDS, SORT and
QRYSLT parameters to allow them to be seen when
FROMFILE does not specify a file name. Customers
will need to ensure that the field names specified
are those that are used in the output from a query,
SQL etc.
6CP0073 2010-12-01 Fix to setting of print area by CVTDBFXL. One too
many columns being included.
Fix CPFA0A2 error when AUT(autl_name) is used and
the authorization list name is longer than 5
characters.
Fix to processing of <:EXITPGMPOSn:> variables
when EXITPGM(*VAR) used.
Office 2010 reporting file errors in some
circumstances (not experienced with CoolSpools V6
but changes made for completeness sake).
6CP0072 2010-11-24 New OVRSTLDFN command allowing temporary style
overrides to be created.
Add PAGBRKS command to CVTDBFXL allowing the
definition of hard page breaks.
Modifications to definition of Database-to-Excel
row groups to allow the selection of different
row groups based on record contents.
2010-11-18 Add CVTDATES parameter to CVTXLDBF. This allow you
to tell CVTXLDBF to output numeric cells that have
date formatting applied to them as date values
rather than numbers. You can specify a variety of
date formats and separator options.
Fix to image handling in Excel: duplicate copies
of images were being included unnecessarily.
6CP0071 2010-11-13 Fixes to handling of images and LOBs in CTVDBFXL.
Support generic path names on ATTACH parameter
of SNDCMNMSG (e.g. ATTACH(('/my_dir/*.pdf'))
6CP0070 2010-11-04 Adjustment to the algorithm used to set column
widths in CVTDBFXL when *AUTOFIT used, as columns
were being set unnecessarily wide.
Also, add new option *FITTEXT which sets the width
of the column based on the on-screen width of the
text (taking account of the font metrics). Note
that the extra work required to calculate the on-
screen width of the text casues some performance
degradation when this option is used.
The default for the column width options is now
*ENVVAR, indicating that the setting of the
CS_XLS_COLUMN_WIDTH environment variable will be
used. If this environment variable does not exist,
the value *AUTOFIT is used as the default, as
before, but if you wish to use a different default
such as *FIELDSIZE or *FITTEXT, you can do so by
setting CS_XLS_COLUMN_WIDTH to this value.
6CP0069 2010-11-04 Add support for including images in Excel when
running CVTDBFXL with EXCEL(*XLSX) specified. See
new INCLFILE parameter. Also new *IMAGE option
on APYSTYLES indicating that the contents of a field
should be interpreted as the path to an image file
or as an image file itself (in the case of a BLOB).
6CP0068 2010-11-01 Fix to CVTDBFSTMF which was giving a decimal data
error whent he XLSPRINT parameter was used.
6CP0067 2010-10-27 Fix handling of sheet names containing apostrophes,
ampersands and other special characters when
converting to *XSLX.
6CP0066 2010-10-26 Fix bug introduced in 065 relating to validation
of color codes/names for CVTDBFXL, CVTDBFHTML and
CVTDBFXML.
Fix setting of print area and "rows to repeat at
top" where the sheet name contains embedded blanks
and we're converting to *XLSX.
Adjust logic for processing *AUTOFIT where a
numeric format is specified on the style so this
does not affect alphanumeric fields.
Default for "Save in directory" element of the SAVE
parameter of SNDCMNMSG is now *ENVVAR. This tells
CoolSpools to check environment variable
CS_EMAIL_SAV_DIR and use the value specified there,
if it exists. If it does not exist, the default is
*CURDIR (current directory) as before.
2010-10-24 If environment variable CS_MSG_LOG_SND_USER is set
to *CURRENT, the user name logged in the SNDRUSER
field of CM_MSGLOG is set to the current user
profile, not the job user profile.
2010-10-24 Modify method of obtaining IPC key for
Spool Admin semaphore operations as error
CPE3525 can occur if file ST_SPLTRN grows
larger than 2 Gb.
6CP0065 2010-10-22 Fix to setting of authorities on copied style
definitions, report definitions, report maps,
database maps and parameter sets.
Modification to the logic for generating new data
nodes when processing using a report or database
map.
Allow for use of <:variables:> before the first
appearance of the data item in the output.
6CP0064 2010-10-21 Enable support for AES encryption on V5R3M0 systems
with no 5722AC3 installed.
6CP0063 2010-10-20 Fix to generation of format string for numeric
values in Excel spreadsheets created using a report
map.
Text-only row group not being output first time.
Fix Excel file open error where zero rows output.
6CP0062 2010-10-18 SHTBEFORE and SHTAFTER parameters of ADDDBFXLR,
ADDRPTXLR, CHGDBFXLR, CHGRPTXLR, CPYDBFXLR and
CPYRPTXLR commands (added in 060) renamed
BFRACTION and AFTACTION.
SHTBEFORE(*NEW) is now BFRACTION(*NEWSHEET)
SHTAFTER(*NEW) is now AFTACTION(*NEWSHEET)
Options BFRACTION(*NEWPAGE) and AFTACTION(*NEWPAGE)
added to allow starting a new row group with an
Excel page break before it or ending a row group
with an Excel page break after it.
"Print header row on each page" option of XLSPRINT
parameter of CVTDBFXL and CVTRPTXL renamed
"Rows to repeat at top" in line with Excel itself.
This option now allows specificaiton of a number of
lines to be repeated at the top of each page when
the worksheet is printed. The default is *NONE.
There is also a special value *HEADER on CVTDBFXL
which sets the number of rows to repeat to the
number of header rows. There is a special value
*FROZEN for CVTSPLXL which sets the number of rows
to repeat to the number of frozen rows. The old
values *YES and *NO are still supported and are now
symnonyms for *HEADER/*FROZEN and *NONE.
The print area is now automatically and explicitly
set to the number of used rows and columns on each
work sheet.
6CP0061 2010-10-15 Add extra options to SPLITKEY and SPLITPOS
parameters:
- ignore blank values when checking *PRV
- *AND condition with following test
Comparison strings specified on SPLITPOS and
SPLITKEY also now support the use of the
˘˘PATTERN and ˘˘REGEX CoolSpools functions.
Add (default) CVTSPLXL MAPNAME(*SELECT) and
CVTSPLXML MAPNAME(*SELECT) options to select
maps from a list.
Message CVT0012
"Font id &1 cannot be implemented by a font mapping"
no longer a warning unless environment variable
CS_CVT0012_WARNING is *YES.
6CP0060 2010-10-14 Fix "Receiver value too small..." error that
occurred in unusual circumstances for AFP spooled
files (inline page segments and images precede the
first page in the data stream).
Option to produce diagnostics files.
Option to start a new worksheet before or after a
row group defined in a report-to-Excel map.
CoolSpools variables can be used in the sheet name.
Option to start a new worksheet before or after a
row group defined in a database-to-Excel map.
CoolSpools variables can be used in the sheet name.
CoolSpools Spool Converter vriable names defined
on EXITPGMPOS and EXITPGMKEY can now (optionally)
be enclosed in variable markers <: ... :>
CoolSpools Spool Converter now supports the use of
variables in the form <:item_name:> or
in various places, when a report definition is in
use.
CoolSpools Database now supports the use of
variables in the form <:field_name:> or
<:field_alias_name:> in various places, e.g.
report titles. This is dependent on a valid record
having been read from the file at the time the
variable is referenced.
Fix bug in CHGRPTITM prompt override program
that was defaulting the section to SECTION(*NONE)
rather than SECTION(*LINE).
6CP0059 2010-10-08 Fix error "ARI9004 Translation from CCSID xxx to
CCSID 65535 not supported." on systems where QCCSID
= 65535.
Fix "Length of varying length variable is out of
range" error when using multiple conditional
formatting groups.
Fix "Receiver variable too small..." error when
processing an Excel font.
Fix "length of start position out of range..."
error when trying to report an unknown SQL error.
New PDF merge API CS_PDFMRGR now the default when
more than 2 files are specified on the MRGPDF
command. This new API is intended to improve
PDF merge performance when multiple (> 2) input
files are specified.
It is possible to revert to using the old API
CS_MRGAPIR in all cases by setting environment
variable CS_MRG_PDF_API to CS_MRGAPIR.
It is possible to use the new API CS_PDFMRGR
in all cases by setting environment
variable CS_MRG_PDF_API to CS_PDFMRGR.
6CP0058 2010-10-06 Fix SAVSPLF error
"Length of varying length variable is out of range."
6CP0057 2010-10-05 Option to use CoolSpools Spool Cnv variables as part
of the constant text of an XML element or attribute.
Variables can be defined on the OPTIONS() parameter
e.g. OPTIONS((<:var_name:> var_value))
Fixes to CVTSPLXML processing
6CP0056 2010-10-05 Option to use CoolSpools Database variables as part
of the constant text of an XML element or attribute.
Variables can be defined on the OPTIONS() parameter
e.g. OPTIONS((<:var_name:> var_value))
Improve the handling of QM Query variables when
converting using a database map. These could
previously cause SQL errors to occur.
6CP0055 2010-10-01 Option to set the value of an XML element
or attribute to be a constant value instead of a
field/column value.
6CP0053 2010-09-25 New CVTSPLPDF ... TOSTMF(*VIEW) and TOSTMF(*PRINT)
options that use System i Access and the STRPCCMD
command to display the PDF created in Adobe Reader
or print it respectively.
6CP0052 2010-09-22 Add options to XLSPRINT parameter of CVTDBFXL to
set the number of copies and print quality
attributes.
Missing logical file CS_RPTRUL2.
6CP0051 2010-09-20 Add *LINKLABEL key to OPTIONS() parameter of
CVTDBFXL to allow the specification of a field to
supply the link label text for a hyperlink.
e.g. CVTDBFXL FROMFILE(QTEMP/LINKS)
APYSTYLES((*FLDNAM HYPERLINK *HYPERLINK *HEADER
*HEADER *HYPERLINK))
EXCLFLD((LABELTEXT))
OPTIONS((*LINKLABEL 'HYPERLINK:LABELTEXT'))
6CP0050 2010-09-17 CVT3001 error message
"The value specified for field saEMT01Type in
structure CS_EMT01 was . This is not one of the
permitted values..."
if default EMAILTO(*SELECT) option used on
CVTSPLxxx command.
6CP0049 2010-09-17 Further fix to handling of /Resources inherited from
parent /Pages object in MRGPDF (CS_MRGAPIR).
Fix handling of embedded carriage returns in strings
in CS_PDFMRGR.
Replace STMFCCSID parameter of CPYTOSTMF with
STMFCODPAG when capturing log files for LODFIX,
APYFIX and INSTALL commands (STMFCCSID not valid
before V6R1M0).
Fix setting of default cell XF for empty cells
when outputting to *XLSX format. Incorrect styling
was being applied to unused cells.
Incorrect generation of MULRK records when using
a map with *XLS format output and an unused column
position exists between cells containing RK numbers.
This resulted in the contents of the next column
being duplicated in what should have been an empty
column.
6CP0048 2010-09-16 Fix pointer error when processing a JPEG file
containing an APP1 segment which is not EXIF data
on CVTSPLPDF ... INCLFILE().
Spurious SLP9025 "STMFOPT(... *NO) not available
with TOFMT(*PDF)" message when CVTDBFXL ...
STMFOPT(... *NO) specified.
Fix validation of QIBM_NOTIFY_CRTSPLF when
creating a spooled file monitor than specifies
DTAQ(*ANY).
Fix handling of messages returned by CRTSPLMON,
CHGSPLMON and CPYSPLMON in WRKSPLMON.
Include option parameters (OPTPARM) when retrieving
script entries for an existing script in the
Automatic Spooled File Processing wizard (CFGSPLMON)
6CP0047 2010-09-15 MRGPDF not correctly handling /Resources
inherited by /Page objects from parent /Pages
for files after the first.
6CP0046 2010-09-13 MRGPDF not correctly handling white space at the
start of a string.
BOOKMARK(*PAGNBR) producing bookmarks without the
"Page " prefix text.
6CP0045 2010-09-07 Margins not being set correctly for HPT printers,
resulting in overlay misalignment.
6CP0044 2010-09-06 DSPPRDINF showing incorrect licensing information
for additional LPARs after the first.
6CP0042 2010-08-26 Default for CS_PDF_LIN_SHIFT should be *YES not *NO.
The position of lines specified by AFP line
drawing instructions was very slightly incorrect as
a result.
Tolerate use of \ for / on SNDCMNMSG MSGSTMF
6CP0041 2010-08-20 a) Fix margins when a spooled file is converted to
PDF and COR or auto-rotation are in effect.
b) Add F8=Select attachment option to CRTCMNMSG
c) Add ATTACH(*SELECT) option to SNDCMNMSG
d) Add option to convert fields to hyperlinks
with CVTDBFXL.
6CP0040 2010-08-12 a) Adjust dimensions of a PCL raster image
where the specified X dimension is not
an exact number of bytes. This was
causing a "form not found" error message
when a PDF created from an *USERASCII
spooled file was opened.
b) Not handling sign indicator (+/-) on
PCL instructions that set the horizontal
or vertical cursor position in decipoints.
Specified coordinates were being interpreted
as absolute when they should have been
relative.
c) Handle JPEG images containing EXIF data.
d) Fix issue with retrieval of user's home directory
2010-08-03 CVTSPLCSV truncating text when outputting
to UTF-8.
6CP0040 2010-08-06 Add MRGSPLF command.
6CP0039 2010-08-05 Fix MCH3601 pointer error when using <:EXITPGMPOSn:>
at:
Program . . . CS_SRVPGM
Module . . . CS_UTLFNCR
Procedure . . UTLGETPARM
Statement . . 446700
Add CHARSET parameter to SNDCMNMSG command to allow
users to specify the character set encoding to be
employed for the email. Default is UTF-8 but
Windows or ISO character sets can be requested
if required.
6CP0038 2010-07-22 Fix to issue with Excel files generated by Spool
Converter when opened by Excel 2003. Excel 2003
(but not Excel 2000 or Excel 2007 or Excel 2010)
was objecting to the way in which cell styles were
being output. This has now been amended to satisfy
Excel 2003's requirements.
2010-07-20 Fix handling of edit words where the
the zero suppression character plus the
replacement characters is one more than the
source length, resulting in no zero
suppression. This was previously generating
an Excel format string which did not
replicate the edit word correctly.
6CP0037 2010-07-14 Fix CMQ9034 "Invalid content type *ZIP" error when
emailing an attachment inside a zip.
6CP0036 2010-07-13 Default for CS_TXT_LINE_METHOD is now *NEW.
This means that if you wish to continue to use the
old logic for calculating line numbers in spooled
files, for reasons of backwards compatibility,
you will need to set environment variable
CS_TXT_LINE_METHOD to *OLD. This only applies to
customers who installed CoolSpools V5 or earlier
prior to PTF 5CV0028 (September 2005) and who
use exit program parameters, bookmarks or
splitting logic that relies on the specification
of line numbers.
6CP0035 2010-07-07 Changes to the rules controlling whether automatic
page rotation and/or Computer Output Reduction (COR)
are performed on a spooled file with PAGRTT(*AUTO).
COR can now be implemented even when the page width
is less that or equal to the page length, where
both page length and page width are greater than
8.5 inches.
If the old rules are required, add environment
variable CS_PAGRTT_COR_RULES with value *OLD.
6CP0034 2010-07-03 When the TOSTMF parameter contained /
inside a CoolSpools function call e.g.
˘˘XLATE("/","-",<:EXITPGMPOS2:>) the / was
being incorrectly identified as a directory
separator and parsing of the path name
produced incorrect results.
Add ˘˘REPLACE funciton to replace one string with
another.
Fix rounding error on numbers in XLSX files created
by CVTDBFXL.
6CP0033 2010-06-26 Update network details.
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.
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.