Batch Report Server/400 is ready for V6R1/V7R1 of i5/OS, starting with version 1.51
The PDF converters did not handle the pipe (|) character correctly. This is now controlled by a data area (REPLCHAR). It defaults to a pipe, but can be changed to whatever character the end user is not using. Possibilities would be a tilde (~), reverse quote (`) or some other character which is not used.
When using this option, the FTP destination options must be used in Batch Report Server/400 to specify destination.
Filezilla is a great FTP server for sending reports to a Windows based server location for import with WebDocs iSeries Batch Import or WebDocs Windows Batch Import.
If BCHRDX data area contains WDIRDX: we will be batch importing to WebDocs iSeries.
If BCHRDX data area contains WDWRDX: we will be batch importing to WebDocs Windows.
If BCHRDX data area contains WDIRDX: or WDWRDX: and the user defined data contains IMGSERVER: we pull the indexes from the
user defined data and create an RDX file and send the RDX file when sending a report via FTP. The RDX file name will always start with the same prefix as the FTP file.
For WebDocs iSeries the folder path may look like the following: Flr1/Fl2/Fl3/Flr4/Flr5 because the folder path is concatenated with all 5 levels.
For WebDocs Windows the folder path may look like the following: xxxxx-xxxx-xxx-xxxx-xxxxx because the folder name is a single GUID value.
Added BCHTSTAMP data area to control whether we uniquely timestamp converted report files when they are created in the IFS. Default is *YES which is consistent with how RJS recommends using Batch Report Server. *NO disables unique timestamps so if a file already exists with specified name, we cannot overwrite the document unless BCHREPLACE data area is set to *YES.
Added BCHREPLACE data area to control whether Batch Report Server is allowed to overwrite existing files if a file of the same name already exists in the IFS folder. Default value is *NO which is consistent with how RJS recommends using Batch Report Server. Warning: Setting BCHREPLACE value to *YES can cause reports to get overlaid if BCHTSTAMP data area is also set to *NO.
If BCHREPLACE=*NO and a report conversion fails, we now write an ERRORINFO record to the log file so we know why conversion failed. We used to only write to the joblog. Now we write to log file BCHLOG00 and the joblog. If BCHREPLACE=*YES and a report conversion replaces an existing IFS file, we will write an INFOWARN record to the log file so if a user questions why a report file was overwritten, we can explain to them that because they enabled the BCHREPLACE data area = *YES and possibly disabled the BCHTSTAMP setting by setting to *NO, thus the file replace condition was induced.
If BCHTSTAMP = *NO and BCHREPLACE = *YES we will automatically overwrite existing files in the IFS if files of the same name are found. This can be used is users want to overwrite the same report name regularly. This is not the recommended setting. The recommended setting is BCHTSTAMP=*YES, and BCHREPLACE=*NO to insure file uniqueness.
Note: The BCHREPLACE = *YES setting should only be used if you ALWAYS want to overwrite an existing IFS file if it already exists.
Added BCHIGCDTA data area to control being able to CPYSPLF on reports with DBCS data. If set to *YES, the text based report converters can copy double-byte data (DBCS). If set to *NO, double-byte data cannot be included in report attachments. Default value is *NO to be consistent with older versions. After changing this data area setting, any jobs that are using Batch Report Server commands must be ended and re-started as the temp files live in library QTEMP and only get re-created one time per job.
Added data areas BTOCCSID and BTOCODEPAG to control the destination code page and CCSID when copying files to an IFS, NFS or QNTC (Windows) location.
If a customer wants to copy files to only an IFS destination the BTOCCSID data area should be set to *OBJ and BTOCODEPAG should be set to *OBJ. This is the default setting.
If a customer wants to copy files to a QNTC destination the BTOCCSID data area should be set to *CALC and BTOCODEPAG should be set to *OBJ. This setting should also work for IFS locations.
If a customer wants to copy files to a NFS destination the BTOCCSID data area should be set to *OBJ and BTOCODEPAG should be set to 437. This setting should also work for IFS locations.
Changed BCHSPLF command to no longer use the BCODEPAGE data area added in V1.40. BCHSPLF now uses BTOCCSID and BTOCODEPAG data areas when copying files to an IFS, NFS or QNTC destination.
Changed BCHEXTRACT command so that it does not generate a listing for creating physical file QTEMP/BCHTXT00.
Enabled full text indexing capability for all words within a text report that gets checked in to WebDocs. Each line of a selected report is parsed and the keywords are captured into the WebDocs full text index database. Full text indexing is available via the output queue monitor commands BCHMON and BCHMONDQ as well as the IMGSPLF command.
To set up a report for full text indexing the following must be done:
The BCHFULLTXT data area must be set to *YES to enable full text indexing engine. This only needs to be done once.
From the RJSBCH menu, an entry must be created for a selected report on the Edit Report Masks screen. The following fields must be entered for a mask entry: Spool File name and Criteria Pattern. The Criteria Pattern value must be sent to *FULLTEXT. *FULLTEXT is now the default value for a new report mask entry.
Note: When a report is full text indexed we attempt to eliminate duplicate keywords during the processing of the report to minimize full text database size. However for large reports, several thousand keywords may get generated so use full text indexing sparingly.
Updated IMGSPLF command to use a temp file prefix of BCHI instead of BCH. The temp file name had the possibility of colliding with the temp file used by BCHSPLF which is called by IMGSPLF. This random scenario could occur on an iSeries box that moves too fast.
Updated BCHMONC4 program. Removed RJSIMAGE library reference in call to DOCTX02 for full text indexing.
Added option to place *SPOOLJOB in report description for an output queue entry. This allows descriptions to map based on spool file and job combination.
Allow AFP for output type in the Edit Output Queue List screen. Converter was working. It just didn't allow the AFP type to be entered on the settings screen.
Updated IMGSERVER: keyword to support folder overrides so user can direct to specific folder during processing.
Example: IMGSERVER:Doc Title;Index1;Index2;Index3; Index4;Index5;Index6;Index7;Index8;Index9;Doc Type;Flr1;Flr2;Flr3;Flr4;Flr5;
Updated output queue monitor to support processing reports with the new Native DataImport Converter command (CPYSPLDIW) available in the Native Converter library V1.52. The Native DataImport converter works in conjunction with a web service to convert documents to MS Excel, MS Access, Dbase and any other DataImport supported conversion format.
The Output Data Type parameter on the Edit User Output Queue Settings program should be set to DIW when converting with DataImport converter.
The second output queue detail screen in the Edit User Output Queue Settings program has field entries for the DataImport Mask IFS file and the various DataImport conversion types. Use XLS8 as the default output type. We recommend storing DataImport mask files in an IFS folder named: /RJSDIW.
Note: Prior to using this option, make sure to test the CPYSPLDIW command with a DataImport mask to make sure it works as expected.
Updated BCHMONC4 to remove the 1 second job delay between each spool file being processed. This should speed up Batch Report Server WebDocs checkin processing dramatically.
To support removal of the job delay, updated BCHMONC4 to make sure that it bails with an error if a destination output file already exists.
Updated BCHMONC4 to insure that temp files in /RJSTEMP get cleaned up if DOCCHKIN fails when checking a document in to WebDocs.
Updated BCHMONC2 to remove the 1 second job delay between each spool file being processed. This should speed up Batch Report Server processing dramatically.
To support removal of the job delay, updated BCHMONC2 to make sure that it bails with an error if a destination output file already exists.
Added capability to use the built-in OS/400 support that can write an entry to a data queue each time a spool file is created. This will allow Batch Report Server processing of large output queues to be much faster because we don't have to list the entire output queue. When processing an output queue we will simply read the list of spool files from the selected data queue via BCHDTAQMON, write them to the BCHSPOOLS table in RJSBCH and then use the BCHMONDQ command to actually process any entries for a particular queue using the same logic as BCHMON. The sequence of events will be: create spool file, data queue entry created automatically, BCHDTAQMON reads data queue entry and writes to BCHSPOOLS and then BCHMONDQ processes and distributes the report to selected location. This scenario will requires at least one instance of the BCHDTAQMON command to be running to capture data queue entries to BCHSPOOLS as they are automatically generated.
Added BCHDTAQMON command. This command monitors a data queue attached to an output queue and processes each entry and writes the report info to the BCHSPOOLS table. BCHMONDTAQ must be run before any spool entries will get picked up by the BCHMONDQ command.
Example command to create data queue that will be attached to an output queue: CRTDTAQ DTAQ(QGPL/QPRINT) MAXLEN(256) SEQ(*FIFO) SIZE(*MAX2GB)
Example to attach data queue to an output queue: CHGOUTQ OUTQ(QGPL/QPRINT) DTAQ(QUSRSYS/QGPL)
Each time a report goes to "Ready" status a new data queue entry gets created. So if you hold/release a spool multiple times then multiple data queue entries get created for a report.
Added BCHMONDQ command. This command processes output queue list entries the same as BCHMON with the exception that it does not read the output queue list directly. It reads the output queue list from the BCHSPOOLS table which is fed by the data queue specified on the BCHDTAQMON command. This will result in a large performance gain for customers who process large output queues.
Updated BCH008R PDF converter to generate font size out to 2 decimal points when *COR PDF option is used. This will allow reports that are 80 columns with 85 lines to not lose the last line of data. The last line wasn't really getting lost. It was just printing off the page palette because the font sizing was using 0 decimal places and not scaling within the bottom boundary of the page.
Added ability to soft code 80,132,198 column threshold for when to switch font sizes and also when to rotate from Portrait to Landscape. This functionality is controlled by data areas in library RJSBCH.
Data area PDF80COL default - 80 Data area PDF132COL default - 132 Data area PDF198COL default - 198
Added PDF converter to library build that handles zero line spacing. Program name: BCH019R. This program handles zero line spacing correctly.
Changed default PDF converter from BCH008R to BCH019R. This setting is stored in the BCHPDFPGM data area.
Setting for PDF Converter that Handled Zero Line Spacing CHGDTAARA DTAARA(RJSBCH/BCHPDFPGM) VALUE(BCH019R)
Old Default PDF Converter Setting CHGDTAARA DTAARA(RJSBCH/BCHPDFPGM) VALUE(BCH008R)
Updated PDF converter to recognize if a report needs to flip into legal page size if it has 80 columns and more than 66 lines per page. This feature is not enabled for landscape reports currently.
Updated BCHSPLF, FTPSPLF and FTPSPLCHK commands to pass page width and page length to BCH008 when converting spool files. This will prevent 198 column reports from inadvertently getting truncated when *COR is specified on the BCH008 command. *COR is currently the default for BCH008. This problem did not affect reports processed via the output queue monitor command BCHMON. BCHMON was already passing the page length and width to the BCH008 command when converting to PDF.
Updated BCHMON command to have an output queue group parameter so that only selected output queues will be processed. The output queue group field entry can be entered on the Edit Output Queue List screen. If the command parameter is left blanks, all output queues will be processed.
Updated ASCII text report converter program to make sure that line spacing is appropriately added to the last line of the report if the last report line contains a skip character instead of a line space. If last line contained a skip previously, it would simply be written after the previous data line with no skips.
Added FTP passive parm to all FTP commands. FTPSPLF, BCHTFR and BCHMON command. When passive is set to *YES, the SENDPASV 1 directive is sent prior to an FTP transfer. Otherwise SENDPASV 0 is sent. Previously no passive directive was sent prior to file transfers. FTPSPLCHK is the only exception. Since FTPSPLCHK sends to another iSeries system, neither the port or passive parms are used with FTPSPLCHK.
Added five folder level support for WebDocs and renamed Image Server headings to say WebDocs. If customer has a version of WebDocs prior to 2.08, they can still use this version of Batch Report Server because we only attempt to call DOCCHKIN with 3 folder levels if folder level 4 and 5 are not entered in the output directory list. Five folder levels were also added to the IMGSPLF command.
Added FTP port to output queue monitor program and BCHTFR and FTPSPLF commands.This allows FTP users to send report files to an FTP server that does not use the standard FTP port 21. If *DFT is specified for the FTP port, port 21 will be used. If a port number is specified, the port will be used to connect to the remote FTP server when sending reports via FTP.
NOTE: Minimum OS/400 release is V5R1.
Fixed problem with document type when if came from the OUTQ settings and not from the user-defined data. The problem showed up in the document type parameter of the WebDocs pre-checkin exit program.
Added capability for FTPSPLF, FTPSPLCHK and BCHSPLF commands to be able to extract *USERASCII files with output priority 9. These are usually PC files spooled by RJS forms, webdocs batch import or other processes used to spool IFS files to outq. The file extension will be derived from the EXT: entry in the spool file user defined data field.
Added data area BCHRDX to soft code value pulled from user defined data. Default value we look for is IMGSERVER:
Added OEM rebranding info into programs. Added BCHCRTRDX code to build program.
Created regular expression program and command BCHREGEXP to scan a string for selected pattern matches using regular expressions (RegEx) for string compares. This enhances the full text index extractionbecause we can now do true pattern matching in strings.
Added copy/paste option to full text mask entry program.
Added full text index extraction for reports being checked into WebDocs. All reports are checked for indexing if the BCHFULLTXT data area is set to *YES. A mask entry must be set up for each field the user wants to extract into the full text table. GO RJSBCH Menu option 6. "Edit Report Masks" can be used to set up a field extraction mask. Field extraction is done based on spool file name, searching for a key value in a report text line based on beg/end column and then extracting the appropriate field data from an identified line.
Updated BCHSPLF to set the code page to 437 when copying file to end destination. This should accomodate files being sent to a remote NFS or QNTC server. The BCODEPAGE data area default = 437. You may also need to set data area BCHSETAUT to *YES. This changes IFS file authority before copying report to final destination.
Added FTPSPLCHK command to check in a report to Image Server running on a remote AS/400. Checkins are done via FTP. This requires Image Server V1.52 and above because this program calls IMAG014C and IMAG014R which were added to support this command in Image Server/400.
Enabled multiple entries in the user-defined data area if IFSFILE: is a keyword. The keyword IFSFILE: sets the name of the IFS file that is created. To use this keyword, it must be specified in positions 1 - 8 of the user-defined data area. For those who will utilize this feature and also have Email Report Server/400, ERS/400 should be running at version 2.38 or higher.
Fixed Image Server User ID to allow lower case entry.
Fixed pointer or parameter error that can occur if the BCHLIST command is used and the QUSRSPLA data area is set to 1600 instead of 1411. Temporary workaround prior to this version is to set the QUSRSPLA data area to 1411.
Added ability to enable computer output reduction (*COR) to allow the PDF converter to better anticipate the lines per inch (LPI) and characters per inch (CPI) within a report. This setting will maximize the use of the page and will result in larger more readable font sizing on the PDF files. The following command must be run to enable computer output reduction in the PDF files:
CHGCMDDFT CMD(BCH008) NEWDFT('PAGESCALE(*COR)')
Updated BCHDUPSPL to allow a new user ID value to be set during spool file duplication. *CURRENT will set the user ID to the current user ID copying the report. *SAME will set the user ID to the original spool user ID. Any existing user ID can also be specified. Also updated error handling so that CPF errors will be generated if a copy fails.
Updated the IMGSPLF command to force a document title to be entered before a report gets archived to Image Server/400.
Fixed problem where output queue monitor would fail when sending a report to Image Server/400 via program BCHMONC4. The error was: Object BCHMONUSPC type *USRSPC already exists in library QTEMP. Total parameters passed does not match number required.
Updated the IMGSPLF command to default to *AS400USER instead of *CURRENT for the check-in user ID field value. *AS400USER will look up the current AS/400 user ID associated with an Image Server/400 user ID and will return the correct Image Server/400 user ID for document check-in. This parameter is useful if Image Server/400 user ID's are not set up to correspond with an AS/400 user profile.
Added CSV Report Converter support for the Batch Report Server/400. BCHSPLF, FTPSPLF and IMGSPLF commands also support the CSV output type. Requires Native Report Converter library and CSV Report Converter License.
Added BCHDEBUG data area. If enabled, and a report is being written to Image Server/400, the index values will be written to the job log as they are extracted from the user defined data field.
We will now ignore open spool files with a status of *OPEN. If the spool file is on hold, the status will display as *HOLD so we will still try to process the spool file. If a report is being spooled and is in *HOLD status, this could still cause an error to occur until the report is finished spooling.
Changed BCHLIST to create temporary file with *NOMAX for record count.
Added spool overrides to PDF converter.
Page Orientation Override values:
Changed QUSRSPLA data area default from 1411 to 1600 so we pick up the user defined options correctly. These fields are used for overriding spool file info.
Added BCHSETAUT data area for setting IFS document authority for *PUBLIC access during report capture. If set to *YES - *PUBLIC access is set to *RWX during conversion so the users and AS/400 api's can access IFS documents. If set to *NO - *PUBLIC access is not set to *RWX during checkin. Doc access is based on the AS/400 user ID used to convert the document.
Fixed IMGSPLF command to correctly pass the print control character parameter to the BCHSPLF command so SPL reports convert with the correct print control characters when interactively converted with IMGSPLF.
Created IMGSPLF command to allow users to manually convert and check-in spool files to the Image Server/400 software.
Added IMGSPLF command to menu option 15 on the RJSWRKOUTQ and RJSWRKSPLF screens to allow users to interactively archive reports to the Image Server/400 software.
Added BCHATR2 command for retrieving user defined data field from spool.
Expanded Batch Report Server support to allow forms generated and uploaded via WinSpool Electronic Forms in *USERASCII format with output priority of 9 to be captured and stored.
Expanded Image Server/400 support to allow forms generated and uploaded via WinSpool Electronic Forms in *USERASCII format with output priority of 9 to be captured and stored.
When sending reports to Image Server/400, index information can now be automatically pulled from the user defined data field. User defined data info can be set for a report via the OVRPRTF command when a report is generated.
Index user defined data line format is:
IMGSERVER:Doc Title;Index1;Index2;Index3;Index4;Index5;Index6;Index7;Index8;Index9;Doc Type;
Added document type to Edit Output Queue List info entered when sending to Image Server/400.
Added initial support for Image Server/400. Reports can now be sent to Image Server/400 document folders. Requires Image Server/400 V1.07 or greater.
Added FTP delay to FTPSPLF command. This can allow us to slow down the sending of files via FTP if the customer has FTP server speed or session locking issues.
Fixed output queue monitor program to correctly handle the decryption of the stored FTP password if sending to a remote FTP site. This was causing 530 errors when connecting to a remote FTP server. This problem dates back to the V1.19 change.
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 initial F1 help panel implementation to selected commands.
CREATED BCH205L/BCH205C FOR DATA ENCRYPTION. ALSO MODIFIED BCH301R TO MAKE SURE THAT THE PASSWORD FIELD GETS ENCRYPTED WHEN ENTERED FOR AN FTP SITE.
Added debug flag to FTPSPLF and also if debug = *YES, an inquiry message will be sent to the user ID runninng the FTPSPLF command.
Changed lock file to transfer is ASCII mode so the data gets converted to viewable ASCII.
Added switch to FTPSPLF to allow it to create a lock file while transferring a report. This would prevent a remote application from trying to process a report that is still being sent from the AS/400 to an FTP site. The lock file is auto-deleted after the report transfer completes. Example report and lock files:
Report: /REPORT001.PDF Lock File: /REPORT001.LCK
ADDED BCHUPG COMMAND TO UPGRADE SETTINGS TO NEW LIBRARY IF INSTALLED.
ADDED NEW SPECIAL KEYWORDS COMBOS FOR SETTING THE IFS FILE PREFIX:
ADDED NEW SPECIAL KEYWORDS COMBOS FOR SETTING THE IFS FILE PREFIX:
Added new PDF converter program to create PDF files that are updateable.
Also added BCHPDFPGM data area to tell the email report server which PDF converter to use. If set to BCH008R, the regular PDF converter is used. If set to BCH018R, the new PDF converter will be used.
Added page size info for call to RTF converter BCH004R to prevent MCH3601 error at code line 337.
Added page scaling info for call to PDF converter BCH008R to prevent MCH3601 error at code line 1029.
Added several special keyword combos for automatically setting the IFS file prefix when a report gets captured and converted by the Batch Report Server.
Added page size for *LETTER or *A4 paper to the RTF Converter.
Added paragraph point spacing for 80, 32 or 198 column reports to RTF Converter.
Changed BCH005 to support 100 character IFS file.
Fixed CPYAFPPDF command to keep it from locking up when called from a java environment the RJSTIFF service program has been compiled for release V4R1 compatibility. We changed it to V4R2 compatibility and it now works. Java was added to the AS/400 in V4R2.
Changed SQL buffer 3000 bytes to 28000 bytes. Users were getting errors if more than 18-19. User access entries were added for a user. This should raise the limit to several hundred entries per user.
Updated user access entry screen to display criteria info on subfile screen. Also added copy/paste feature as well.
Added WRSPURGE command and WRSSQL commands to be used for purging reports from system. ? Reports in the IFS are automatically deleted when a record is manually deleted from BCHINDEX.
Added LPAR access code checking option.
Added ability to pass flag settings to the PCL to PDF converter. These are set via the new WRSPCLCMD command and they are stored in the WRSPCLCMD1, 2, 3, 4 data areas. Updated PGM BCHMONC2 to support WRSPCLCMD data areas for PCL to PDF conversion.
Soft coded content type passed to browser. We were passing application/octet instead of passing the file type, thus causing problems for Netscape users.
Fixed BCHMON001 so that report descriptions get set correctly. We now set descriptions from WSR006 instead of WSR003.
Added TIF output type for BCH301R.
Still have questions? We can help. Submit a case to Technical Support.