Batch Report Server/400 Revision History

From Support

Current version of Batch Report Server/400 is 1.53 Batch Report Server/400 is ready for V6R1 of i5/OS, starting with version 1.51

1.53

2008-8-24

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.

1.52

2008-3-7

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 Areas

• PDF80COL controls when we switch from Portrait to Landscape.
• PDF132COL controls when we switch to 132 col landscape.
• PDF198COL controls when we switch into 198 col landscape.

Data area PDF80COL default - 80                
Data area PDF132COL default - 132              
Data area PDF198COL default - 198              

1.51

2008-1-14

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)

1.50

2007-10-21

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.

1.49

2006-12-26

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.

1.48

2006-10-09

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.

1.47

2006-08-27

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.

1.46

2006-07-04

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.

1.45

2006-05-22

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.

1.44

2006-03-30

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.

1.43

2006-01-17

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.

1.42

2005-12-28

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.

1.41

2005-12-27

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.

1.40

2005-03-06

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.

1.39

2005-01-26

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.

1.38

2004-12-06

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.

1.37

2004-08-06

Fixed Image Server User ID to allow lower case entry.

1.36

2004-08-03

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.

1.35

2004-07-10

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)')

1.34

2004-07-03

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.

1.33

2004-04-30

Updated the IMGSPLF command to force a document title to be entered before a report gets archived to Image Server/400.

1.32

2004-02-19

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.

1.31

2004-01-15

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.

1.30

2004-01-15

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.

1.29

2003-12-24

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.

1.28

2003-11-08

Changed BCHLIST to create temporary file with *NOMAX for record count.

1.27

2003-09-23

Added spool overrides to PDF converter.

Page Orientation Override values:

• *PORTRAIT = portrait page orientation
• *LANDSCAPE = landscape page orientation
• Font Size Override (1-20)
• Line Space Override suggested values:
  • 80 col portrait = 8
  • 132 col landscape = 7
  • 198 col landscape = 6

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.

1.26

2003-09-14

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.

1.25

2003-08-01

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.

1.24

2003-07-22

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.

1.23

2003-02-18

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.

1.22

2002-11-19

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.

1.21

2002-09-14

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.

1.20

2002-09-02

Added initial F1 help panel implementation to selected commands.

1.19

2002-08-28

CREATED BCH205L/BCH205C FOR DATA ENCRYPTION. ALSO MODIFIED BCH301R TO MAKE SURE THAT THE PASSWORD FIELD GETS ENCRYPTED WHEN ENTERED FOR AN FTP SITE.

1.18

2002-08-02

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.

1.17

2002-08-02

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

1.16

2002-07-23

ADDED BCHUPG COMMAND TO UPGRADE SETTINGS TO NEW LIBRARY IF INSTALLED.

1.15

2002-06-04

ADDED NEW SPECIAL KEYWORDS COMBOS FOR SETTING THE IFS FILE PREFIX:

• *USERDATAFORM - User Data,Form Type
• *USERDATA_FORM - User Data_Form Type
• *FORMUSERDATA - Form Type, User Data
• *FORM_USERDATA - Form Type_User Data

1.14

2002-06-04

ADDED NEW SPECIAL KEYWORDS COMBOS FOR SETTING THE IFS FILE PREFIX:

• *SPOOLFORM - Spool file,Form Type
• *SPOOL_FORM - Spool file_Form Type
• *FORMSPOOL - Form Type, Spool File
• *FORM_SPOOL - Form Type_Spool File

1.13

2002-05-11

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.

1.12

2002-04-01

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.

1.11

2002-03-19

Added several special keyword combos for automatically setting the IFS file prefix when a report gets captured and converted by the Batch Report Server.

• *SPOOLDATE - Spool file, date (YYYYMMDD)
• *USERDATADATE - User data, date
• *JOBNAMEDATE - Job name, date
• *FORMTYPEDATE - Form type, date
• *SPOOLDATETIME - Spool file, date, time
• *USERDATADATETIME - User data, date, time
• *JOBNAMEDATETIME - Job name, date, time
• *FORMTYPEDATETIME - Form type, date, time
• *DATESPOOL - Date, spool file
• *DATEUSERDATA - Date, user data
• *DATEJOBNAME - Date, job name
• *DATEFORMTYPE - Date, form type
• *DATETIMESPOOL - Date, time, spool file
• *DATETIMEUSERDATA - Date, time, user data
• *DATETIMEJOBNAME - Date, time, job name
• *DATETIMEFORMTYPE - Date, time, form type

1.10

2001-12-27

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.

1.09

2001-09-19

Changed BCH005 to support 100 character IFS file.

1.08

2001-08-07

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.

1.07

2001-05-29

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.

1.06

2001-05-19

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.

1.05

2001-05-19

Added LPAR access code checking option.

1.04

2001-04-15

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.

1.03

2001-04-15

Soft coded content type passed to browser. We were passing application/octet instead of passing the file type, thus causing problems for Netscape users.

1.02

2001-04-09

Fixed BCHMON001 so that report descriptions get set correctly. We now set descriptions from WSR006 instead of WSR003.

1.01

2001-03-29

Added TIF output type for BCH301R.