WinSpool/400 is ready for V6R1/V7R1 of i5/OS, starting with version 3.68
Fixed problem with PAGEBREAK. A CR/LF was inserted after the PAGEBREAK character, adding an extra line.
Added data area to say whether or not to add the CR/LF after a PAGEBREAK.
- CRLFPGB - 1 character. This contains a Y or N to add a CRLF after a page break or not. The default is Y to keep the current logic.
Fixed problem with double byte spool files shifting over 1 character.
Added 2 data areas to handle page breaks.
- PAGEBREAK - 2 characters. This contains the hex characters to be used as a page break. The default is '0C' These 2 are converted to a single hex character and inserted on page breaks.
- LASTPAGE - 1 character. This contains a Y or N to indicate whether or not to add a final page break at the end of the report. The default is 'Y'.
Fixed WSPLADDMS not to specify QSYS for the library in the ADDMSGD command when adding custom CPF message CPFFFFF to QCPFMSG. This was a problem when the customer had multiple languages installed, so that there could be a library named QSYS2924 above QSYS in the system portion of the library list.
Updated FDMERGE and FDMRGSPLF commands to call WSPLADDMS. In a case where a customer upgrades the WINSPOOL library but doesn't run WSPLUPG, this can cause errors to return from FDMERGE or FDMRGSPLF even though the PC merging seems to complete just fine. This is because we have a custom CPF message CPFFFFF in QCPFMSG in QSYS that wasn't created but is needed.
Changed build of program WSP010C to fix a problem with Host Print Transform output.
Added WCNV003 command to support SPL report downloads for Enterprise Report Delivery.
Updated WSPLASCII command and created data area WSPEXTUDEF to determine if we add EXT:PDF or whatever the IFS extension is for the file we're spooling when calling WSPLASCII.
Set WSPEXTUDEF to *YES if you want to add EXT:PDF~ to the front of the user defined data value (Default).
Set WSPEXTUDEF to *NO if you do not want to add EXT:PDF~ to the front of the user defined data field when respooling. *NO is used when you want to preserve the original user defined data value.
A byproduct of this update is that the FDMERGE command will utilize this functionality as well when merging and re-spooling an electronic form. Set
Set WSPEXTUDEF to *YES if you want to add EXT:PDF~ to the front of the user defined data value when calling respooling with FDMERGE (Default).
Set WSPEXTUDEF to *NO if you do not want to add EXT:PDF~ to the front of the user defined data field when respooling with FDMERGE. *NO is used when you want to preserve the original user defined data value.
Updated program WSPL0020 to only strip 5th position character from a spool file if the WSPLDBCS data area is set to *YES and *PRTCTL is specified. If *NONE or *FCFC were specified when WSPLDBCS was *YES, the 5th position from a data line would get lost.
If WSPLDBCS is set to *NO, the problem was never occurring so that can be a temporary solution for users who do not want to upgrade the WINSPOOL library.
Updated FDMERGE command. After update 3.67, the FDMERGE command was erroring with a 0002 error when users tried to use FDMERGE.
NOTE: Minimum OS/400 release is V5R1.
Added remote server URL parm to the FDMERGE command. If *DEFAULT is specified, the value is retreived from the FDMRGHOST data area, otherwise simply pass a valid URL to a Window server running the RJS Forms Server web application.
IF WSPLDBCS data area is *YES, we now remove extra print control character in data so position offsets are correct in report. Previously all data would be shifted by 1 character.
Enabled TIF support on FDMERGE commands. Requires: PDFCreator PDF Print Driver and RJS Ghostscript 32 API Added PRDLIB to FDMERGE command. Added GETMAILIFS compilation.
Added native forms merge command FDMERGE to allow users to merge spool files with form overlays natively from the iSeries from within their iSeries CL or RPG programs. This command requires a license for the WinSpool/400 Electronic Forms software.
Additional software requirements: There is an ASP.Net companion web application that must be loaded on a Windows PC with the IIS Web Server and RJS Electronic Forms Print server in order for this to work. A dedicated print server PC running Windows XP or Windows 2003 should be set up to run on demand forms generation. Windows 2000 should work as well.
Updated WCNV002R to make sure that a page break gets written at the end of the last report page. This was causing the FDMRGSPLF to chop the last line of a report during processing.
Added DLTSPLF parm to FDMRGSPLF command.
Added *NOMAX and re-use deleted records to files WSPLTCPI and WSPLTCPO work files created in program WSPL112C. This will insure that these files do not fill up when created by WinSpool/400 TCP API's during spool file downloading and user does several thousand report downloads or does not have authority to the CLRPFM command. We think the re-use deleted records was causing the problem because we were deleting all records programatically if the CLRPFM command didn't work because of user authority issues. This would cause the deleted records count to grow.
Added 5000 byte MSG parm to MAILRPT command.
Added native forms merge command FDMRGSPLF to allow users to merge spool files with form overlays natively from the iSeries from within their iSeries CL or RPG programs. This command requires a license for the WinSpool/400 Electronic Forms software.
Additional software requirements:
- iSeries Office Integrator Library and License.
- WinSpool/400 and WinSpool Eforms License.
- iSeries Office Integrator PC Server V1.1.55.
- WinSpool/400 Electronic Forms Merge Engine on PC.
- FormDocs Software on PC.
Updated library to handle LPAR's 10 or above for license checking.
Added PSC output type to MAILRPT command for emailing Postscript files.
Added CPF message CPFFFFF to system message file QCPFMSG. This will allow V5R3 users to be able to use the WinSpool/400 TCP/IP API.
In V5R3, the CPF9898 message no longer returns useful info via the command line when called via FTP remote command calls. Neither do user messages. We were able to get things to work by creating a custom CPF message CPFFFFF with a 45 byte msg data parameter. This is an odd workaround, but it works. Also modified all TCP/IP spool API's that use CPF9898 to use CPFFFFF as the return message. This library version should work with all OS/400 versions back to V4R3. Also created CL command WSPLADDMS command to auto-add message CPFFFFF to QCPFMSG.
Removed special license check for the WSPCPYSP2 API command.
Added PDF encryption setting to the MAILRPT API command. The RJS PDF Encryption API must be loaded on the PC running the WinSpool Email Report Server program.
Changed WSPLIST to create temporary file with *NOMAX for record count.
Added alternate output queue list API comm WSPL046 to use the QGYOLSPL API instead of QUSLSPL to list spool files. This API allow us to soft code the number of spool files want to return per list pass. To enable the command to be used by the WinSpool/400 PC API, change data area WSPOUTQCMD to a value of: WSPL046. If changed to WSPL016, the old QUSLSPL API version will be used. To set a maximum number of spool entries to retreive in WinSpool/400, when the new WSPL046 API is enabled, run the following command to change the max value: CHGCMDDFT CMD(WSPL016) NEWDFT('COUNT(100)'
NOTE: This command will not currently work with WinSpool/400 API. Apparently FTP jobs have a problem with the QGYOLSPL API.
Added WSPCPYSP2 command for copying a report with $ACH headers and making sure all $ACH headers occur on line 1 and all data lines start on line 2 so reports can be split correctly with the fill option in the page definition. This is a separately licensed function.
When running WSPLUPG command, we now always set the QUSRSPLA data area to 1411 bytes so that user defined data gets downloaded when an output queue list is retrieved. This caused a problem when users updated from an old version of the WINSPOOL library to a current version and then needed to use the user defined data to set email address info.
Added FROMRCD parm to WSPCPYSPL command.
Changed WSPLRAW2R to resolve decimal data errors that must have been introduced during the six digit spool file number changes in V3.49.
Added WSPLJOBLOG to allow joblogs to be listed for FTP jobs.
Major Change: Implemented the ability to handle up to 999999 spool file entries per AS/400 job. This is to comply with V5R1 update to allow this.
Note: If users are using any of the report server commands in their own programs, they will need to test their programs to make sure the programs don't need to be updated to handle the new 6 digit spool file numbers.
Added WSPLUPG command to upgrade settings to new library version if installed.
Added initial F1 help panel implementation to selected commands.
Updated WSPLASCII to be able to spool files larger than 6 megs. WSPASCII can now spool unlimited file sizes.
Added support for new remote command API call WSPL_SubmitCommand2 which can now call up to a 1024 byte command line instead of only 200+ a character command lines.
Added WSPCPYSPLF command to allow a group of reports stored in an AS/400 file with *FCFC characters to be re-spooled for capture by Email Report Server, Batch Report Server,etc.
Added history file for WSPROUTE. File name is MLADRH00. After a report has been processed and emailed via WSPROUTE, a record for the email recipient will be removed from MLADR00 and added to MLADRH00 for historical and debug purposes.
Changed WSPDUPSPL parm size from 3800 to 4000 bytes for V5R1 support. Reports were not correctly being duplicated by this command when used.
Modified WSPLASCII to set the output PTY to 9. user defined data field is also going to be set up as follows: ext:pdf~<user defined data value>.
Added MSGTEXT PARM to the MAILRPT command.
Changed WSPLRAW command to handle spool files larger than 16 megs. now we can download any size raw spool data file. WSPLRAW now calls program wsplraw2cl instead of WSPLRAWCL. if a user has problems, the WSPLRAW command can be switched back to call program WSPLRAWCL.
Changed WSPDUPSPL command to handle spool files larger than 16 megs.
Added command wspl0203 for downloading a selected page range from a spool file.
Modified WSPLASCII parameters to allow the IFS doc extension to be defaulted into the spool file FORMTYPE when an ifs document is spooled via the WSPLASCII API.
Added WSPLASCII command to spool ASCII files to output queue entries. This function will be used to spool ifs files to spool file entries for emailing, capture, etc.
Modified MAILRPT command to handle the following extensions: FRM, HTX, NAT, NAP. FRM - electronic forms conversion HTX - embedded html text handling NAT - native AFP to TIFF conversion NAP - native AFP to PDF conversion
Created WSPMAILKEY, WSPADDRESS and WSPROUTE commands. Also created MLADR00 file for use with WSPADDRESS and WSPROUTE. These commands can be used to route selected emails for processing to another queue by tracking a unique user data key created by WSPMAILKEY and then assigned to a report.
Created WSPL024BC to check access code data area using *LIBL.
Made a change to LPAR checking code to insure we don't get a decimal data error at stmt 227 when checking partitions.
Added LPAR access code checking option.
When converting AFP to PDF with command WSP0063, we will now retry the TIFF to PDF conversion up to 2 times if it fails. Sometimes the TIFF to PDF conversion fails for no reason and works the second time it's called. Very bizarre.
Added WSPDISTILL data area for Postscript to PDF conversion.
Spool entry length is now picked up from the user space so the 82/88 setting will not be needed. This eliminates the need for the QLISTLEN data area.
Created command WSPLIST to list spool files from a selected OUTQ to an *OUTFILE. This is a utility command and not currently used by any of the WinSpool programs.
Created WSPL0162 and WSPL0202 to download OUTQ listings and also spool files to temp IFS file as well as QTEMP. We have had at least 1 user who has had FTP lockups under Windows NT when downloading WINOUTQ from library QTEMP.
Don't create CHKOBJIFSR if V3R2M0 chosen.
Created WSPLTEMP command to create work directory /rjstemp.
Created CHKOBJIFS command.
Added the RJSWRKOUTQ and RJSWRKSPLF commands.
Added commands WSP0062 & WSP0063 for AFP to TIF and PDF conversion. These commands are for internal use by WinSpool only. They are not for use outside of the WinSpool product.
Created command WSPTEMP to create work files in the /RJSTEMP IFS directory.
Created command WSPLKILL to delete IFS work files.
Removed test call to QCMD from MAILKEYC. This was causing errors when using the MAILRPT command from the WinSpool library.
Created the WSPTEST1 command for generating a reform report sample. The report data is stored in file SPOOLTEST2.
Added WSPEFORM data area for handling the electronic forms license.
Added ALCOBJ logic to MAILKEYC to prevent duplicate key errors when adding to MLRPT00 when the MAILRPT API command is used. USEDDS flag now defaults to *NO.
If WSPUSEDDS is *YES the DDS for the work file is used to recreate the work file before each pass and the CCSID value for file is determined by data area WSPCCSID.
Commands changed to use this are:
Added WSPCCSID and WSPUSEDDS data areas to allow us to handle international character sets.
Fixed MAILRPT so it doesn't clear user data unless the MAILRPTUSR data area is set = *YES.
Added the following commands to handle the fax report server: WRKFAXRPT/WRKFAXRPTC WSPFAXRPT/WSPFAXRPTC
Tweaked WSPL016R to include the entire 255 character user defined data.
Tweaked WSPLDUPSPL command to handle V3R2.
Created WSPLDUPSPL command and PGMS. **NOTE**: This locks us into V3R7
Modified WRKERPT & SPLPROCESS commands to have a user filter.
Modified MAILRPT command to preserve original OUTQ in MLRPT00 when an entry is written to the file.
Created WSPLATR2 command to retrieve spool file outq.
Changed RPTMSGF message file reference in WRKERPT programs.
Added original spool outq name/lib to MLRPT00 FILE.
Converted all access codes to use the new Y2K formatting.
Added AFPTOPCL command code. Removed ALWRTVSRC from WSPLRAW and WSPLNET commands.
Added WSPLOS3 command to set the allow double byte value. Also added data area WSPLDBCS as well to support this. We should now be able to download DBCS spool files via FTP. We also increased each data record from 400 to 1000 bytes to ACCOMODATE double byte data.
Added PAGWIDTH, PAGELENGTH, OVERFLOW LPI, CPI, PAGE ROTATION values to output file in program WSPL016R when listing spools.
Added WSPNET command for controlling the AS/400 netserver.
Added WSPLRAW command to handle raw AS/400 spool files. This gives us the ability to download native spool files as well as PCL or Postscript forms data for viewing and printing.
Changed SNDMAILC so that users can use CHGCMDDFT on MAILRPT to set defaults when MAILRPT is called from WRKERPT.
Fixed MAILRPT API issues created by fix made in 3.08.
Fixed MAILRPT API so that it handles a * PASSED as the job name correctly.
Added "MSG" output type to MAILRPT CMD.
Changed all CRTPF commands to include MBR(*FILE) when a file is created this will prevent error 22029 from the WinSpool/400 software during downloads.
Modified WSPL016 to include 150 chars of user defined data if value is set. 2) Added WSPOS2 to set QUSRSPLA length.
Added WSPTOFL2 API for copying AFP/IPDS files to TIFF files in the shared folder.
Added version data area.
Added AFPTOFLR command code.
Added GETSPLF/PUTSPLF command code.
Added from email address to file MLRPT00.
Added WSPTOFLR API for copying AFP/IPDS files to TIFF files in the shared folder.
Removed RPTSPLIT30 library reference from program SPL100C.
Added WSPLNUM command and programs.
Modified MAILRPT command to use WSPLNUM to get the report spool number we now also reset user data if the same report number is reselected for emailing via the MAILRPT command. This allows the same report to be easily re-sent without manually resetting user data.
Added command WSPHOLD. Put 2 second DLYJOB on WSPMOVE. Put 2 second DLYJOB on WMOVOUTQ. Added setup menus WSPLMNU, WSPLMNU1, and WSPLMNU2. Allow command access to limited.
Fixed command WSPL019C. It was passing an incorrect PARM into WSPL016R since the change made in V2.42. An error could occur at statement 46200 and could appear in QSYSOPR if an older version of the library is used. An invalid command response error could be received by WinSpool 95 when a spool list is retrieved by user.
NOTE: All users of 32-bit Batch Report Server and Email Report Server need V3.00 or above of the WINSPOOL library.
Added GETMAIL compilation.
Added new access code command - WSPLSEC. Added MAILRPT compilation. Added WSPLMNU menu build. Added WRKERPT compilation. Added SPLPROCESS compilation.
Soft codes V4R3 changes and created WSPLOS command.
Changed WSPL016R for V4R3 IBM changed byte offsets from 82 to 88 which caused problems when listing spool files.
Added code for AFP/IPDS processing.
Converted TCP/IP work file record length from 214 to 400 bytes.