The iSeries Report Converters are ready for V6R1/V7R1 of i5/OS, starting with version 1.50

1.58.0

2015-03-25

  • Updated the TIF2PDFC command to utilize PDF version 1.5 in the header

1.57.0

2015-03-25

  • Added CNVIGCDTA data area to control whether double-byte data can be included in report attachments via the CPYSPLPDF command

1.56.0

2015-03-25

  • Added CNVCODPAGE data area to allow output file CCSID to be overridden from the default of 37

 

1.55

2011-03-15

Fixed problem with CSV conversion using a mask when the report is over c. 150 pages. It could either hang or report an "update without prior read" error.

1.53

2009-08-12

Brought back behavior for unstacking that was changed for version 1.46. That change had treated unstacked lines like a heading line, or as a single wide column. This was related to the change to unstack before the matching line, as well as after it.

Now the resulting unstacked line is parsed according to the COLUMNS parameter, as it used to do. This assumes that the number of lines to unstack and their layout is consistent throughout the spooled file.

1.52

2009-03-212

Added CPYSPLDIW command for converting report using DataImport Report Converter web service.

1.51

2008-6-5

Added RJSTIFF300 300 DPI workstation customization object to library to resolve issue of documents potentially rendering half-sized.

To implement the RJSTIFF300 300 DPI workstation customization, run the following commands:

ADDLIBLE RJSCONVERT
CHGCMDDFT CMD(CPYAFPTIF) NEWDFT('WSCSTNAME(RJSTIFF300) WSCSTLIB(RJSCONVERT)')                       
CHGCMDDFT CMD(CPYAFPPDF) NEWDFT('WSCSTNAME(RJSTIFF300) WSCSTLIB(RJSCONVERT)')

Also make a copy of the workstation customization object to QSYS as QWPTIFFG4 so that the Email Report Server, Batch Report Server and other products will convert AFP to TIFF and PDF correctly.

CRTDUPOBJ OBJ(QWPTIFFG4) FROMLIB(QSYS) OBJTYPE(*WSCST) TOLIB(QSYS) NEWOBJ(QWPTIFFG4O)                                                                     
DLTWSCST WSCST(QSYS/QWPTIFFG4)
CRTDUPOBJ OBJ(RJSTIFF300) FROMLIB(RJSCONVERT) OBJTYPE(*WSCST) TOLIB(QSYS) NEWOBJ(QWPTIFFG4)                                                               


1.50

2008-1-14

Added PDF converter to library build that handles zero line spacing. Program name: CPYSPLPD3R. This program handles zero line spacing correctly.

Changed default PDF converter from CPYSPLPDFR to CPYSPLPD3R. This setting is stored in the CNVPDFPGM data area.

  • Setting for PDF Converter that Handled Zero Line Spacing

CHGDTAARA DTAARA(RJSCONVERT/CNVPDFPGM) VALUE(CPYSPLPD3R)

  • Old Default PDF Converter Setting

CHGDTAARA DTAARA(RJSCONVERT/CNVPDFPGM) VALUE(CPYSPLPDFR)

Changed CPYSPLPDF setting for "Use auto page scaling-LPI/CPI . PAGESCALE" to *COR instead of *NONE. This was needed to support the new zero line spacing converter.

1.49

2007-05-03

Updated CPYSPLRAW command to handle spool files larger than 16 megs. Now we can download any size raw spool data file. CPYSPLRAW now calls program CNV0052CL instead of CPYSPLRAWC If a user has problems, the CPYSPLRAW command can be switched back to call program CPYSPLRAWC.

1.48

2007-03-14

Recompiled library to include new text report converter which will correctly handle a conversion condition if the last line of a report contains a line skip instead of a space.

1.47

2006-08-08

CPYSPLCSM has been fixed to allow the program to adequately handle spool file numbers of all lengths. Added new spool number edit logicwhen zero suppressing spool numbers.

1.46

2006-06-06

Fixed unstacking problems: - If headings were defined then all lines were treated as heading lines - If headings were not defined, matching unstack lines were treated as normal lines, using the column definitions found there

Fixed problem with heading lines that they did not have quotes around them.

Added ability to stack up lines that precede the matching line - use negative line count to use this new feature - positive line count to stack lines that follow the matching line.

Changed unstacking to treat resulting lines as heading lines - no column definitions are used and the result has quotes around it. Changed unstacking so that matching lines are always included - it is no longer necessary to use include settings for them.

Enhanced unstacking to handle page breaks, ignore report headings, and to stop when it encounters other matching unstack lines.

Enhanced heading line definititon to include a value for additional lines to be excluded from the resulting heading - this handles the situation where column headings from the original report should be excluded because the mask defines column headings.

1.45

2006-03-19

Corrected problem that last character of line with 0 advance was getting dropped.

1.44

2005-08-20

Added a native CNVMRGPDF command to allow two PDF files to be merged into a single PDF file. The CNVMRGPDF command uses Java for the PDF merging. It requires V5R1 and above and the V1.4 Java JDK. The V1.4 Java JDK can be obtained from IBM via PTF's. V5R2 and above should already have the V1.4 Java JDK installed.

Also added a VFYJDK command which can be run to verify that V1.4 of the Java JDK is present on the system.

Note: The CNVJAVAENV command must be run to restore the Java classes needed before using the CNVMRGPDF command. CNVMRGPDF is licensed as part of the native PDF Report Converter.

NOTE: Minimum OS/400 release is V5R1.

1.43

2005-01-07

Fixed CSV/400 problem that, in certain situations, caused last line of a page to merge with first line of the following page.

1.41

2004-10-20

Added the ability to allow the user to start the processing at a specified line and activated the "number of rpt heading lines" option. Included with these changes is the addition of two new variables that can be used in the SQL statement WHERE clause that is built. They are CPAGELINE and CPAGENUM. They allow selection based on report line number and page number.

1.40

2004-07-09

Added the 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(CPYSPLPDF) NEWDFT('PAGESCALE(*COR)')

1.39

2004-06-02

For CPYAFPPDF, CPYAFPTIF and CPYSPLHPT commands, changed the output path length from 100 to 255 characters.

1.38

2003-09-23

Added spool overrides to PDF/400. Page Orientation override values are *PORTRAIT = portrait page orientation and *LANDSCAPE = landscape page orientation; Font Size override (1-20); Line Space override suggested values are 80 column portrait = 8, 132 column landscape = 7 and 198 column landscape = 6

1.37

2003-08-11

Updated CSV/400 converter logic to only process output fields specified as *NUM through the negative sign alignment logic if the user specifies negative sign adjustment.

1.36

2003-06-18

Added SLK conversion type to CPYSPLCSV. SLK files can be opened via excel and seem to handle character formatted fields better than CSV in some cases.

Note: Data area CSVCNVTYP must be set to *SLK in order to convert to SLK. *CSV in order to convert to CSV.

1.35

2002-11-17

Added SLK conversion type to CPYSPLCSV. SLK files can be opened via excel and seem to handle character formatted fields better than CSV in some cases.

Note: Data area CSVCNVTYP must be set to *SLK in order to convert to SLK. *CSV in order to convert to CSV.

1.34

2002-09-18

Added HP4 compatible workstation customization object for use with CPYAFPPDF or CPYAFPTIF. The customization object name is RJSTIFFHP4.

Added zero margin *HP4 compatible workstation customization object for use with remote output queues when using host print transform. This will print to HP printers without including a left, top, bottom, right page margin. This can help line up overlays correctly when printing from the AS/400. The customization object name is RJSHP4.

1.33

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 converter 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.32

2002-09-02

Added initial F1 help panel implementation to selected commands.

1.31

2002-08-26 Reference source for changes.

1.30

2002-08-02

Implemented zero suppression option for data fields is zero suppress = *YES on the CPYSPLCSV command.

1.29

2002-07-29

Added special values for unstacking. If *CHAR is passed, the selected unstack field must be all characters. If *NUMERIC is passed, the selected unstack field must be all numbers. Implemented negative sign handling. If *LEFT is passed, negative signs are placed to left of data if found in record data. If *RIGHT is passed,negative signs are placed to right of data if found in record data.

1.28

2002-07-23

Added CNVUPG command to upgrade settings to new library if installed.

1.27

2002-07-22

Added line unstacking to CPYSPLCSV. Up to 5 lines can be unstacked into 200 bytes columns. This is a great way to combine report detail lines for processing. Only one unstack criteria is allowed.

Added line output start/stop points. If criteria specified for stopping output, data output is stopped until a valid start criteria is found. Up to 5 start/stop criteria fields can be specified.

1.26

2002-06-20

If no records are selected, the converter places a "** No Records Found **" message in the CSV file instead of failing. Created data area NORECMSG to hold the no records selected message text.

1.25

2002-06-10

Implemented switch to allow commas to be stripped from output data in CPYSPLCSV. All output variables are now trimmed when CPYSPLCSV is used. This will remove leading/trainilg space from data.

Added report title parm to CPYSPLCSV.

1.24

2002-05-13

Added level breaking to CSV converter. Also strip commas.

1.23

2002-05-11

Added new PDF converter program to create PDF files that are updateable.

Also added CNVPDFPGM data area to tell the PDF report converter which PDF converter program to use. If set to CPYSPLPDFR the regular PDF converter is used. If set to PYSPLPD2R, new PDF converter will be used. Fixed program PCLERR not found problem. This error would happen with CPYAFPPDFC a work in progress piece of code was accidentally released in V 1.21 update.

1.22

2002-05-11

Added &PAGESIZE PARM for program call to CPYSPLRTFR in the CPYSPLRTF command to prevent a pointer error.

1.21

2002-05-10

Changed the following commands to handle copying reports correctly when '*' is specified for the job name indicating thecurrent job. CPYSPLANSI, CPYSPLPDF, CPYSPLRTF, CPYSPLHTM, CPYSPLCSV, CPYSPLPRN

1.20

2002-01-28

Changed QLISTLEN defaults to 88.

1.19

2002-01-18

Created CSV101R mask entry program.

Added message file CNVMSGF.

Added program CNVMSGC.

Created command CPYSPLCSM for calling the CSV Converter from ERS/400 and other products using the selected mask name.

1.18

2001-12-27

Added page size for *LETTER or *A4 paper to the RTF Converter.

Added paragraph point spacing for 80, 132 or 198 column reports to RTF Converter.

1.17

2001-12-07

Created CSV Converter - CPYSPLCSV.

1.16

2001-11-30

Added auto page scaling option to PDF Converter if the page scaling parm default gets changed to *AUTO. This will auto-scale PDF file sizes based on page length/width/LPI/CPI.

1.15

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.14

2001-08-07

Added LPAR access code checking option.

1.13

2001-04-30

Extended CPYSPLRAWR converter to handle 100 character ifs path instead of 50. The as/400 command and CL program had not been updated from 50 to 100 the last time this was fixed.

1.12

2001-02-20

Changed RTF, PDF, HTML converters to scan up to 200 lines for the longest report line during conversion.

1.11

2001-02-08

When converting AFP to PDF with command CPYAFPPDF, 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.

1.10

2001-02-08

Fixed text converters so that they correctly merge zero line space info. We swapped the merge fields around because the fields were getting merged in the incorrect order. We also now write the last line of a report if it contains zero line spacing.

1.09

2000-12-08

Extended CPYSPLRAWR converter to handle 100 character IFS path instead of 50.

1.08

2000-11-21

Added JOB/USER/JOB NUMBER to temp file names to prevent potential work file naming conflicts.

1.07

2000-11-10

Replace { } characters with brackets when performing an RTF conversion. This prevents errors when opening an RTF report if it has an unmatched bracket in the report data.

Added new zero line spacing logic to the TXT, HTML, RTF and PDF text converter programs. Data should not get lost on the reports any more.

1.06

2000-10-05

Fixed NTS002 txt converter to prevent -0002 errors if a data line is blanks.

1.05

2000-08-25

Created CPYAFPTIF and CPYAFPPDF commands to copy AFP reports to TIFF or PDF formats.

Added code to move objects from TIFFLIB to library rjsers.

Implemented RJSWRKOUTQ & RJSWRKSPLF commands. WRKMRPT command now uses RJSWRKOUTQ command.

Added CNVNUM, CNVATR and CNVSPLF commands.

Added RJSCONVERT menu.

Changed all commands to create temp work files in the /RJSTEMP IFS directory. Created command CNVTEMP to do so.

1.04

2000-06-27

Fixed problem where line space/skipping wasn't picked up on the last record. This change was only made to NTS002 which is the ASCII text PRN converter. We will not change the other converters unless asked.

1.03

2000-03-20

When converting to PDF, scan for '\)' and replace with '\134)' if found this should prevent errors in case of a slash and parenthesis found on the right side of a report data line.

1.02

2000-02-18

Added ZEROSPC parm to CPYSPLRTF command.

1.01

2000-01-29

Added CHKOBJIFS command to check for IFS files.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: August 09, 2018