54.196.194.204
  Easy400
search with google   
Site surfing
Home
Tools
Documentation
Code snippets
Links
Subscribers
Testimonials
Downloads/Register
last updates
 
Suggestions
Forum
 
Support Easy400.net with a contribution:
If you are not familiar with PayPal, quickly learn how to do it.
 
Last major updates  
For detail information also on minor updates, please use the following links:

cgicbldev2 cgidev2 cgiwrkdbf cvt101 db2xtools endjobs epolice fixhdtab fupload graphit
howtoajax hssfcgi ifstool jsdatepick loginout mmail odf plcheckup pop3read sectcp
vrtsav webact websql wrkvldl wsectcp xlparse xlparse2 xlscgi zip zipsave

 

May 28, 2014 ZIP Fixed the case where in command UNZIP an IFS path name contains embedded blanks.
March 18, 2014 IFSTOOL Command IFSTOOL/READDIR has a new parameter, MASK, which allows to report back only the stream files with names matching a given pattern. Read about it at this page.
March 17, 2014 MMAIL-AMailer New AMailer enhancement in receiving incoming mail messages: images embedded in the message body are now regularly displayed when reading the message and are also made available as attachments.
March 14, 2014 MMAIL-AMailer Provided documentation about implementing Internet mail-boxes on IBM i, see this page.
March 8, 2014 HSSFCGI New command RPTXLSGEN provides detail information about the workbooks created from the current job.
March 6, 2014 HSSFCGI "Ad-Hoc" program regeneration no longer sensitive to database file creation / last-change date changes: mandatory for production boxes without ILE-RPG compiler.
March 6, 2014 CGIWRKDBF "Ad-Hoc" program regeneration no longer sensitive to database file creation / last-change date changes.
March 2, 2014 MMAIL-AMailer Improved POP3 client interface.
February 25, 2014 CGIDEV2 Service program CGIDEV2/CGISRVPGM2 was added new subprocedure WrtSectionToStmf(). This procedure may be used to generate on the IFS large stream files exceeding 16 MB. See this page.
February 8, 2014 HSSFCGI Removed limit of 500 characters for conversion of character strings to spreadsheet text-cells (commands XLSGEN, XLSXGEN and TABLEXLS).
February 6, 2014 GRAPHIT Provided examples of stacked charts, see this page.
January 30, 2014 MMAIL Fixed the interface to IBM INFOPRINT SERVER, after detecting problems with V6R1.
December 18, 2013 GRAPHIT This new utility is now equipped with 6 types of charts (Line, Radar, Bar, Polar, Pie and Doughnut). A new powerful CGI program (named CHARTIT) allows to generate the desired type of chart, with the desired data, at a cost of a few minutes.
December 13, 2013 GRAPHIT This is a new utility that demostrates how you can generate fabulous HTML5 graphs with your CGI programs. Have a look.
October 10, 2013 POP3READ & MMAIL A new feature allows to get e-mail messages also from SSL POP3 servers.
September 10, 2013 MMAIL It was found that command EMLPTUMSG was sending the message only to the first addressee. That has been corrected.
September 3, 2013 ZIP New parameter JUNK(*YES) on command ZIP/ZIP prevents recording of directory names.
Also compression of full IFS directories now supported on command ZIP.
August 24, 2013 ENDJOBS Command ENDJOBS/ENDJOBS is no longer sensitive to the OS/400 release. It works from OS/400 release V5R3 on. See this page.
August 3, 2013 MMAIL & AMailer - Removed bug causing accumulation of useless stream files in IFS directory /mmail/work.
- Fixed AMailer modules and subprocedures dealing with detachment of BASE64 encoded message bodies and attachments.
June 16, 2013 MMAIL SMS messages can be sent through an e-mail message to a SMS Gateway, see page MMail: E-Mailing SMS messages.
May 21, 2013 MMAIL A new command, EMLTXTSTMF, allows to create and send an e-mail message starting from a text stream file. Attachments are of course supported.
May 19, 2013 MMAIL *** This is the first V5R3 release of MMAIL.
This release features a new way of retrieving the local time zone and more parameters for command EMLPTUMSG (e-mail an impromptu message).
May 18, 2013 MMAIL Fixed the management of parameter RTNPTH (return Path) in all programs related to commands EML... and STREML... .
*** This is the last V5R2 release of MMAIL.
The next releases will be for V5R3.
April 13, 2013 MMAIL New command EMLPTUMSG allows to send an inpromptu message (maximum length 5000 characters) up to 50 e-mail addresses. See this page.
March 11, 2013 EPOLICE Error messages reported via e-mail from command RCVMSGQ are now correctly formatted and can be read without any problems.
February 25, 2013 FIXHDTAB Fixed Header Table support - Utility FIXHDTAB is now documenting and supporting a new fabulous JQuery plugin, DataTables from SpyMedia. Read about it.
February 18, 2013 MMAIL Provided documentation about E-Mail/SMTP Authentication. Check out this IBM Software Technical Document.
February 10, 2013 IFSTOOL A new parameter, RUNBATCH(*YES), allows command IFSTOOL/READDIR to submit its execution to a batch job. In this case, the library of the results data base file DIRLIST is no longer QTEMP and can be assigned by the user. Parameter RUNBATCH(*YES) is recommended whenever huge IFS directories are processed. For more information, see this page.
December 30, 2012 CGIDEV2 Two new CGISRVPGM2 subprocedures - DspStmf() and DnlStmf()- allow to send a stream file to the browser / download it. Check out this page.
December 22, 2012 ENDJOBS A new small utility featuring a command able to end multiple jobs in a single shot. See this page.
December 18, 2012 MMAIL New command EMLHTML2 allows to create and send a mail message having an HTML stream file as body and attaching up to other 30 stream files. See this page.
November 5, 2012 MMAIL-AMailer Updated three modules of service program SOCKETMAIL. See the MMAIL change log.
October 30, 2012 MMAIL A new command, SplPdfCvt, allows to pre-define spl-to-pdf conversion parameters for ...EML... commands.
See this page.
September 12, 2012 MMAIL MMAIL commands EMLSPL, STREMLSPLF, STREMLSPL2, SENDMIME and SPLFTOPDF may now take full advantage of all the fancy features available in the spool-file-to-PDF conversion IPDF free utility. See commands CSVIPDF/CREATEIPDF and MMAIL/IPDFCMDPRO on this page.
September 4, 2012 MMAIL A great FREE product from Orati Systems, IPDF, is now supported through MMAIL EML... commands for converting spool file to PDF's. For more information about this feature, see this page.
August 30, 2012 XLPARSE2 Provided support for parsing very large spreadsheets (more than 10,000 rows).
August 20, 2012 IFSTOOL Unability to report stream files larger than 2,147,483,647 bytes has been removed.
August 9, 2012 MMAIL National characters support:
  1. if the selected character set (see command MMAIL/CHARSET) is UTF-8, in EML... mail messages the names of the sender and of the recipients are encoded in UTF-8.
July 10, 2012 MMAIL National characters support:
  1. if the selected character set (see command MMAIL/CHARSET) is UTF-8, in EML... mail messages the subject is encoded in UTF-8.
July 6, 2012 MMAIL National characters support:
  1. MMAIL is now supporting character sets other than ISO-8859-1, uncluding UTF-8.
    Therefore MMAIL is now able to send mail message bodies in languages like Czech, Hungarian, Polish, Norwegian, Swedish, etc.
    Character set UTF-8 is recommended. Use command MMAIL/CHARSET to set your default character set.
June 15, 2012 MMAIL MMAIL commands EMLMSG, EMLSRCM, EMLSPL, EMLSPL2, EMLSAVF, EMLSTMF and EMLSTMF2 use a source member for the text of the message body and the related programs execute a STRSEU command to edit the source member.
The following enhancement has now been provided.
If command STRSEU is not available (a very common case on production boxes, where PDM is not installed), the EML... programs, instead of STRSEU, send a display file screen that allows the user to edit the source member text. If the user presses F3 from this screen, then command EDTF is executed.
June 9, 2012 MMAIL MMail allows not only to send mail messages, but also to receive mail messages addressed to given user accounts.
This can be done through the MMAIL-integrated utility named "AMailer".
Incoming mail messages can be received and processed through a local program on a IBM System i box.
Both Internet and System i locally defined user accounts are supported.
AMailer" provides tools to define such accounts.
System i locally defined user accounts are supported through "AMailer" generated user profiles.
However, a System i box can be already supporting mail exchange among local users using existing user profiles.The good news is that now "AMailer" is also able to generate its mail accounts by referring to existing system profiles.
In this way, already existing local mail user environments may take advantage of processing through local programs the incoming mail to local accounts.
Read here.
May 16, 2012 XLPARSE2
  • Improved *ESCAPE message processing in commands XLSCONVERT and XLSTABLE
  • Added sample CGI program UPLANDRUN (Upload a spreadsheet from PC and run XLSTABLE for it), see this page.
May 7, 2012 ODF Rcdfmt of SYSTEMS file was added fields for three STRTCPFTP command parameters: CCSID, PORT, SECCNN.
May 2, 2012 HSSFCGI In commands XLSGEN and XLSXGEN, the maximum number of user-defined cell styles has been raised from 494 to 10,000. See this page.
April 28, 2012 ODF The main ODF utility command, ODSTR (Start Object Distribution), has been enhanced to support transmission up to 300 remote systems.
The selection of the remote systems to be engaged has been inproved through
  • a remote systems list, to chose from
  • optional selection of all the available remote systems
  • optional selection of remote systems via generic names.
April 18, 2012 CGIDEV2 Fixed subprocedure random by replacing call to API CEERAN0 with a call to API Qc3GenPRNs for pseudorandom numbers generation.
March 21, 2012 CGIDEV2 It was found that CGIDEV2 supports a maximum of 50 output variables in a HTML row. This restriction was due to local subprocedure "SetupArrays" in module XXXWRKHTML. That procedure now has been changed to support up to 500 output variables in a HTML row.
March 13, 2012 XLT941 This utility is used to translate to a different national language your HTML scripts. This release includes some enhanced ability to detect - for translation - the text strings used in JavaScript functions ALERT and CONFIRM.
March 4, 2012 CGIWRKDBF Some important updates:
  • Added ability to update/delete the selected database record when non-unique keys are used.
  • Fixed positioning after record add/update.
  • Fixed ad-hoc program generation when null capable fields are involved.
February 29, 2012 MMAIL Updated subprocedures MimeSplpdf and MimeImbAtt so that the names of the attached PDFs are no longer suffixed with a 5 digit number (e.g. "QPDSPLIB_97813.PDF" will now be "qpdsplib.pdf").
February 7, 2012 CGIDEV2 "HttpOnly" flag in Set-Cookie HTTP header now supported by subprocedure CrtCookie.
January 28, 2012 /FixedHeaderTable This is a jQuery plugin that allows to keep the table headers steady while a table is being scrolled. It also allows the user to display only selected columns of the table. The tool is documented at this page.
January 26, 2012 CGIWRKDBF Implemented Table Fixed Header feature, based on a JsQuery plugin.
January 20, 2012 DB2XTOOLS Now truly compatible with V5R2.
January 15, 2012 XLSCGI Added more examples of CGI programs generating XML speadsheets. See this page.
January 5, 2012 MMAIL Added command MMAIL/UPDMMLIB. It allows to update a MMAIL cloned library (originally created with command MMAIL/CRTMMLIB) with fresh software from the last installed release of library MMAIL. See this page.
December 31, 2011 MMAIL New MMAIL release fixes
December 25, 2011 CGIDEV2 Commands CGIDEV2/REBIND and CGIDEV2/DUPSRVPGM may help when installing the latest CGIDEV2 over a previous CGIDEV2 version. See this page.
December 22, 2011 CGIDEV2 Subprocedure encode2 now supports also encoding of characters to decimal entities (besides conversion to named entities). New subprocedure decode2 supports decoding of named and decimal entities.
December 20, 2011 /jsDatePick This is a jQuery based tool that allows to pick up dates and move them into input fields of a form. See this page.
December 16, 2011 HSSFCGI Command TABLEXLS now supporting also SQL views.
December 16, 2011 CGIWRKDBF WRKDBF now supporting also SQL views.
December 10, 2011 CGIWRKDBF
  • "Bottom" positioning now provides a full page of records, instead of showing just the last record.
  • Fixed "bottom" positioning for packed and date key fields.
  • Fixed the display of negative signed and packed key fields.
December 1, 2011 HSSFCGI Provided parameter DEC-POS for formulas. Example:
    < data type="formula" dec-pos="3" > .
November 26, 2011 CDGIWRKDBF WRKDBF now supporting also UCS-2 (data type "G") database fields.
November 25, 2011 HSSFCGI Command TABLEXLS now supporting also UCS-2 (data type "G") database fields.
November 18, 2011 LOGINOUT User name and password lengths increased from 20 to 100 characters.
November 17, 2011 WRKVLDL User name and password maximum lengths were increased from 20 to 100 characters, thus supporting, for instance, e-mail addresses as user names.
November 17, 2011 DB2XTOOLS One bug fixed ( encoding not always complete if > 1 character to encode ) + improved performance on command DB2XML.
November 16, 2011 IFSTOOL
  • Parametr DIR in commands READDIR and SEARCH now supports a generic path name (ending with an *)
  • SEARCH command now able to scan also Unicode stream files.
October 28, 2011 IFSTOOL A new parameter (IGNDIRS) on command READDIR (Report the contents of a directory) allows to neglect up to 100 sub-directories.
October 27, 2011 HSSFCGI Full recovery feature now available with parameter RECOVERY in commands XLSGEN, XLSXGEN and TABLEXLS. Especially useful when facing JVM memory problems during generation of large worksheets. Read about it.
September 29, 2011 MMAIL It is now possible to insert images (for instance a logo) in message bodies of EML... commands, by simply specifying the images to be displayed.
As an example, if you want to display a boat image, just insert something like this in any point of your message text:
   < img src="http://www.easy400.net/mmail/image/0002378.gif" >
September 21, 2011 CGICBLDEV2 Added three procedures to service program CGICBLDEV2/CGICBLDEV2:
  • QAppHtmlToStmf Append the HTML buffer to a stream file
  • QChkIFS Check an IFS object
  • QLowfy Convert a character string to lowercase characters.
September 13, 2011 CGIWRKDBF Fixed an important bug in the *LK record filtering process.
September 5, 2011 CGIWRKDBF
  1. Provided a User Guide
  2. Added new powerful operator *LK ("like") for record filtering.
August 30, 2011 HSSFCGI A new parameter ("anchor") has been added to the data type PICTURE.
It establishes the behavior of a picture when
  • the cell is resized
  • a new column or a new row is added to the worksheet.
For more information, see this page at topic Picture resizing and relocating.
August 28, 2011 MMAIL Provided a parameter to zip (compress) attached spool files (either converted to PDF or not).
This feature applies to commands: EMLSPL, EMLSPL2, EMLSPLX, EMLSTMF and EMLSTMF2.
August 26, 2011 FUPLOAD Improved maintenance features (rename / move / delete) of WEB program FUPLOAD3.
August 17, 2011 CGIDEV2 Subprocedure AppHtmltoStmf() (Append html output buffer to an existing stream file) was added to service program CGIDEV2/CGISRVPGM2 as per request to the Easy400Group.
July 24, 2011 CGIDEV2 Added some code to subprocedures ZhbGetInput and ClrHtmlBuffer to handle exceptional uncontrolled cases of memory trashing.
July 16, 2011 HSSFCGI New features:
  • Parameter LOG in commands XLSGEN, XLSXGEN and TABLEXLS
  • Keyword COLUMN-MAXWIDTH for XLSGEN tag <cell>
Fixes:
  • Ability to define formulas VSUM/HSUM/VAVG/HAVG over a previous series of cells containing formulas
  • Spreadsheet name length forced to 30 max when XLSX workbooks generated.
July 12, 2011 CGICBLDEV2 Subprocedures GetHtmlIfs and GetHtmlIfsMult of service program CGICBLDEV2/CGISRVPGM2 are now supporting Unicode (CCSID 1208) stream files. Unicode support for subprocedure WrtHtmlToIfs was made available in May 2009.
June 13, 2011 CCGIWRKDBF Steady Headers is a special feature of the CgiWRKDBF utility. It allows to keep the column headers steady, while the table is being scrolled.
This feature is driven by the server CGI program, after receiving information from the browser about the screen height.This piece of information is acquired when the utility is started from its first page, while no such information used to be made available when the utility is started on its second page via URL
    http://.../cgiwrkdbfp/wrkdbf.pgm?xrequest=CMD&xfilename=aaa&xlibname=bbb
Thats has now been fixed.
Note for FireFox users - FireFox 4.0 has dropped the support for the HTML tags TBODY and THEAD, in the sense they are no longer interpreted as block-groups (as tag DIV does).TBODY and THEAD tags are the base for handling Steady Headers. As a consequence, the Steady Headers feature no longer works with FireFox 4.0, while it still works with I.E. 9.0 .
June 11, 2011 MMAIL It was found that MMAIL utility CVTSPLFPDF (while able to convert to PDF *SCS and *AFPDS spool files) will fail in converting to PDF *IPDS, *AFPDSLINE and *LINE spool files
(Error message: QwpzHostPrintTransform failed : CPF6DF8 hptopt = 30).
On the other site it was found that MMAIL utility CVTSPLSTMF, besides converting *SCS spool files, has no problems in converting to PDF *IPDS, *AFPDSLINE and *LINE spool files.
We have therefore updated subprocedure MimeSplfPDF in such a way that, when requested to process a PDF conversion for an *IPDS, *AFPDSLINE or *LINE spool file via CVTSPLFPDF, it calls CVTSPLSTMF instead.
June 10, 2011 HSSFCGI New features for cell border support:
  1. Parameter CELLBORDER for commands XLSGEN, XLSXGEN and TABLEXLS.
  2. Keyword border for XLSGEN tag <cell>.
See this page.
April 9, 2011 ZIP This ZIP release fixes potential problems in displaying the result from a ZIP or an UNZIP command.
March 25, 2011 CGIDEV2 Subprocedures GetHtmlIfs and GetHtmlIfsMult are now supporting Unicode (CCSID 1208) stream files.
February 21, 2011 HSSFCGI Added more features:
  • A <HEADER ...> XLSGEN opcode to generate print headers and footers
  • New features for command TABLEXLS and pgm WEBTABLEXL:
    • multiple database files input
    • multimember file support
    • screen headers and print headers.
February 14, 2011 HSSFCGI Added keywords UNDERLINE and ITALIC for the XLSGEN control statemenf <data ...>, see this page.
Added HYPERLINK support for <data type="formula">, see here.
February 10, 2011 HSSFCGI Added parameter CELL-WIDTH to the XLSGEN control statement <cell ...>. This allows to establish the size in pixel of a spreadsheet cell (and the column it belongs to). See this page.
February 2, 2011 ODF Added controls to prevent users from using system user profiles (like QSECOFR) not allowed to run submitted jobs or FTP jobs.
January 31, 2011 DB2XTOOLS
+WEBSQL
Released new versions of the two utilities. They provide better parameters for converting the queried data to the desired output format. The major part of the enhancements are focused on the CSV output format.
The new version of WEBSQL requires the new version of DB2XTOOLS to be also installed.
January 14, 2011 MMAIL Fixed some problems in EML... commands validity check programs when FROMADDR(*DIRENT) specified. For details, please see this forum posting.
December 18, 2010 HOWTOAJAX If you did not use Ajax so far, you may be interested in our method. Take a look at our Ajax pages.
December 6, 2010 HSSFCGI Added a "freeze pane" feature to keep heading rows steady when scrolling rows. See new parameter FROZEN in commands XLSGEN, XLSXGEN and TABLEXLS. Check out page http://www.easy400.net/hssfcgi/html/page2.htm.
November 27, 2010 ODF Added command ODRCV (Receive Objects from a Single Remote System). See this page.
November 20, 2010 FUPLOAD Validation of files to be uploaded is now possible both at client and at server side, see this page.
November 17, 2010 WEBSQL This is a new utility, based on DB2XTOOLS. It provides a way to define, from the WEB browser, an SQL query on System i databases. The user can then request to convert the result of the query to a PC format (XML, HTML, CSV or TXT) and display it through the appropriate MS Office utility. See this page.
November 12, 2010 DB2XTOOLS A new exciting WEB feature makes using this utility very simple, in converting database files to XML, HTML, CSV and TXT formats. Display of results on the WEB browser is at the touch of a button. See this page.
November 3, 2010 FUPLOAD The FUPLOAD program FDNLOAD, supporting the download of whatever stream file, was found unable to download stream files larger than 16 Megabytes. Luckily, a Scott Klement's suggestion provided the way out, so that now downloading any size stream file is possible in the FUPLOAD utility.
October 29, 2010 MMAIL Added support for Spooled File Actions.
If your system is at least at release V6R1, on command WRKSPLF (and other commands dealing with spool files), you may install more options (A, B and C) to e-mail spool files or to save them as IFS stream files (text or PDF).
For detail information see this page.
October 15, 2010 XLPARSE
+XLPARSE2
Utility XLPARSE has been merged into XLPARSE2. XLPARSE has been withdrawn. XLPARSE2 provides a way to import Excel spreadsheets to IBM i databases. Both extensions XLS and XLSX are supported. XLPARSE2 requires V5R3, v5R4 or a subsequent release. For detail information see page http://www.easy400.net/xlparse2/html/page1.htm .
October 11, 2010 XLPARSE
+XLPARSE2
The XLSTABLE target database file can now be a multimember file, and a target member can be specified.
Numeric spreadsheet cells can now be received also on database character fields.
October 8, 2010 MMAIL Fixed severe error that was inhibiting mail sending.
October 7, 2010 HSSFCGI Fixed a problem that was causing command XLSGEN to fail on V5R4.
October 4, 2010 CGICBLDEV2 Subprocedures QZhbGetVar and QZhbGetVarUpper of service program CGICBLDEV2/CGICBLDEV2, when called from COBOL program, no longer work with OS/400 release V6R1.
Reason is that those subprocedures return a 32767 char variable, while the COBOL program is usually expecting a shorter character variable.
This is why those two subprocedure have now been changed and now return a 1000 char variable. COBOL programs calling those subprocedures should be changed accordingly.
October 1, 2010 HSSFCGI This is a major release, providing color support for EXCEL spreadsheet cells. See this page.
September 23, 2010 MMAIL Added an exit point to subprocedure SendMail. This allows an user-program to validate any message from MMAIL. See this page.
September 16, 2010 HSSFCGI Now supporting background colors in column headers of a spreadsheet.
September 13, 2010 ODF It is now possible to transfer via FTP PUT command all or selected members of a file.
September 8, 2010 MMAIL Fixed a problem (pgm WARNLSTRLS) that was spoiling e-mailing response time.
September 6, 2010 HSSFCGI In this HSSFCGI release, the size limit of 16MB for the XLSGEN XML-like stream file input to commands XLSGEN / XLSXGEN, has been dropped.
August 26, 2010 DB2XTOOL A new version of this utility (library DB2XTOOLS) has been made available by Antoon van OS, The Netherlands. See this page.
July 12, 2010 HSSFCGI Support for XLSX Excel spreadsheets has been added.
July 5, 2010 HSSFCGI New important feature. Command TABLEXLS allows to generate an XLS Excel Spreadsheet from any database file. See this page.
June 15, 2010 HSSFCGI HSSFCGI (the utility that allows to create .xls Excel spreadsheets) now supports any formulas compatible with Excel 2003.
June 1, 2010 POP3READ Fixed a small bug related to memory deallocation - It was preventing some messages from being correctly received.
May 25, 2010 WRKVLDL This is a new CGI utility for maintaining validation lists. See this page for documentation.
May 11, 2010 HSSFCGI A fix was added to XLSGEN program. It was not closing the stream file containing the .xls workbook just created. That did not allow the stream file to be copied or moved.
April 16, 2010 CGI_WRKDBF Solved an old problem related to the replacement of an ad-hoc program when the record format of the related database file is changed.
March 18, 2010 XLPARSER2 XLPARSER2 is the successor of XLPARSE. It allows ILE-RPG programs to read not only XLS, but also XLSX Excel spreadsheets. See this page.
March 7, 2010 XLPARSE Added command XLSTABLE. It allows to read an Excel XLS sheet as if it were a database file. In this way an Excel XLS sheet can now be read by any program language, RPG III, RPG IV, C, COBOL, ... what you have.
See this page.
February 15, 2010 CGI_WRKDBF New features added:
  1. Alternate background colors for table rows, for easier reading
  2. Record marker, to change the background color to all fields of a record
  3. Add alike record, to create a record similar to the one selected for update.
See also this page.
February 3, 2010 VRTSAV This is a new utility (Virtual Save & Transfer), which allows to perform saves on virtual tapes and to transfer the save data to another system where they can be stored on real tape volumes. For detail information see this page.
January 21, 2010 CGI_WRKDBF Fixed the following bug: only the first 5 key fields of database file record formats were recognized as key fields.
January 19, 2010 XLPARSE POI 3.6 - installed on XLPARSE January 5, 2010 release - was found unable to process a customer .xls spreadsheet, while POI 3.2 was able. As a consequence, POI 3.2 was put back into XLPARSE.
December 23, 2009 ODF The following enhancements were added:
  1. New parameter PMTRSTCMD (Prompt Restore Commands) in command ODSTR allows to prompt the restore commands that will be run on the target systems.
  2. Command RTVODSTR retrieves, prompts and runs a previous ODSTR command.
  3. Command RERUNODSTR re-runs a previous ODSTR command.
  4. Command ODDSPLOG has now options to run commands RTVODSTR and RERUNODSTR.
See this page for details.
November 30, 2009 XLPARSE A new release, including several fixes and enhancements, is available. Check out this page.
November 24, 2009 CGI_WRKDBF WRKDBF is now featuring a "Steady Table Headers" technique. Instead of scrolling the whole browser page, you just scroll the table rows (the records). Field headers no longer move.
This is what you have been used since ever with OS/400 subfiles.
Wow, now also available for HTML tables!
November 3, 2009 CGIDEV2 Improved support for error TCP7531 (Output buffer damaged).
November 2, 2009 ODF ODF (Object distribution Facility) is a new utility for maintaining multiple IBM System i's. Read about it at this page.
October 24, 2009 PLCHECKUP A new utility that investigates all the ILE programming pieces of an application library, finds out the relations among pieces and provides several inquiry screens that will help in your application maintenance duties. A life-saver for ILE programmers.
See this page.
September 15, 2009 CGI_WRKDBF Several fixes. See this page.
September 8, 2009 CGI_WRKDBF Improved performance about 5 times.
September 4, 2009 ZIP Bug fixed. Pgm ZIP/ZIP was accepting a max of 5 files to be zipped instead of 50.
September 1, 2009 CGI_WRKDBF New feature: Add/Remove a user-defined filter on database records.
August 16, 2009 CGI_WRKDBF The utility now supports also adding, updating and deleting database records. See this page.
August 4, 2009 CGI_WRKDBF This utility allows to browse through your Internet browser any iSeries database file. See this page.
June 30, 2009 MMAIL New MMAIL imbedded utility STRMONIFS allows to perform automated distribution of PDF stream files. See this page.
June 22, 2009 MMAIL Now supporting the V6R1 AFP to PDF transform. See this page.
June 12, 2009 CGIDEV2 & MMAIL Added commands ZIP and UNZIP - They execute in the QSHELL environment.
May 21, 2009 FUPLOAD A new file upload program ("fupload2") has been made available. Much simpler than the previous one, it can be easily customized. Oustanding performance. Multiple uploads possible in a single shot. Read about.
May 21, 2009 CGIDEV2 Added a feature that allows PC file upload with no effort. See this page.
May 2, 2009 ZIP Are you still missing ZIP and UNZIP commands on the iSeries? Get them installed in a few seconds. Check out this page.
April 22, 2009 HSSFCGI This is another utility for generating Excel spreadsheets from programs. It supports inclusion of images in a spreadsheet (the other utility, XLSCGI does not support graphics). Read about it at this page.
March 26, 2009 XLSCGI A new utility for CGIDEV2 programmers. It allows to generate and send to the remote browser Excel spreadsheets. Read about it at this page.
March 25, 2009 CGIDEV2 Added command EDBG (Enhanced debug) - Makes you faster in starting debugging CGI programs, but not only them.
March 10, 2009 XLPARSE XLPARSER4 is the name of a Scott Klement's tool for reading Excel spreadsheets with ILE-RPG. We have wrapped that ingenuous code with some interface in library XLPARSE. That makes absolutely easy for everyone to get Excel spreadsheet reading done. Read this page.
February 19, 2009 CGIDEV2 Added subprocedure UrlEscSeq, see this page.
February 19, 2009 MMAIL Taking advantage of the last CGIDEV2 release.
February 4, 2009 XLTMSGF "Translate message descriptions used in DDS" - It provides a quick way to translate to another national language the message descriptions used in display or printer files.
February , 2009 MMAIL Detachment of e-mail messages attachment is now synchronous (instead of parallel) for command PRCUSRMAIL .
January 2, 2009 MMAIL Fixed a packaging error that was causing troubles when installing on a V5R2 box.
December 18, 2008 CGIDEV2 Small enhancements:
  1. Whenever error message TCP7531, the related HTTP server PGM-QZSRCGI job is ended
  2. Error messages logged to CGIDEBUG file are now showing - if applicable - the name of the involved CGI program.
December 18, 2008 MMAIL V6R1 proof version. The only problem was with command MMAIL/MNGSPLF.
December 3, 2008 SECTCP
WSECTCP
Added a new feature to Active Defense. It allows a better defense against unauthorized FTP logon attempts.
November 6, 2008 DB2XTOOL2 This is the successor of the star-utility db2xtool which was designed to generate HTML / CSV / XML / TXT scripts from DB2 databases.
Db2xtool2 results in easier operation and more power. Minimum OS/400 release is V5R3.
October 10, 2008 SECTCP
WSECTCP
The following enhancements were added:
  • Minimum OS V5R2
  • For FTP, it is now possible to define a limited number of IP addresses allowed to logon.
  • For FTP, it is now possible to restrict given user profiles within the initially assigned current directory.
October 7, 2008 MMAIL A new parameter (PREFORM) was added to commands EMLMSG, EMLSPL, EMLSPLX, EMLSAVF, EMLSRCM. When PREFORM(Y) specified, the message body is displayed as pre-formatted text. This allows to properly align columns of embedded text-tables.
September 28, 2008 ZIPSAVE This is a new utility. It allows to perform saves and to zip the save files directly on the iSeries. A command to unzip directly on the iSeries is also available.
Documentation at this page.
September 8, 2008 MMAIL New tools to add hyperlinks to HTML stream files. See command addhyperl and subprocedure addhyper.
August 30, 2008 MMAIL Command CVTSPLFPDF now allows to specify PDF conversion parameters such as paper size, orientation and margin. Two new commands (SETSPLFPDF and SETSPLSTMF) allow to specify PDF conversion parameters for CVTSPLFPDF and CVTSPLSTMF when they are implicitly executed from EML... commands. See this page.
August 25, 2008 SECTCP
WSECTCP
The FTP logon exit program (for exit point QIBM_QTMF_SVR_LOGON) was added the feature to set
  • the initial NAMEFMT
  • the initial CURLIB or the initial HOMEDIR
for the FTP session associated to a given user profile.
This is driven by three new fields added to the FTP user profile authorization records (file SECTCP/USRPRF).
August 21, 2008 MMAIL
  • Fixed an error in the subprocedure that decodes a quoted-printable string.
  • Command EMLMSG is now supporting a null message body. In such a case, the message will contain just the subject.
  • Content-type: multipart/alternative now supported for the message body.
    That allows the message body to be available both as text/plain and as text/html. The choice is then up to the preferences specified for the receiving mailer. See subprocedure MimeImbTxtF in page http://www.easy400.net/mmailh/srvpgm.htm#P066. Most EML... commands are now using this technique.
  • Changed USER parameter in command MNGSPLF. It was defaulting to *ALL, now it defaults to *CURRENT .
August 20, 2008 IFSTOOL A new parameter - IGNSTMF(*NO/*YES) - was added to command IFSTOOL/READDIR. If IGNSTMF(*YES) specified, the generated list of IFS objects does not include the stream files. That may help, when listing complex IFS directories: just the existing subdirectories would be listed.
August 12, 2008 SECTCP
WSECTCP
Fixed displays of HTTP logs.
July 30, 2008 E-POLICE This is a new utility, that may help in controlling small emergencies on your system. Please refer to e-police main page.
July 6, 2008 CVT101 A new utility supporting conversion of IFS strings and stream files from one code page to another code page, Unicode included. Read about it on this page.
July 1, 2008 SECTCP Local installation files are no longer kept in library QUSRSYS. They are now maintained in library SECTCPDATA.
July 1, 2008 WSECTCP Same as SECTCP. Local installation files are no longer kept in library QUSRSYS. They are now maintained in library SECTCPDATA.
June 19, 2008 MMAIL It is now possible to require that any outgoing message is sent by blank (blind) copy to a given distribution list, thus implementing a potential company auditing requirement. For details, see SendMail subprocedure, note 2, Mandatory blank copies (blind copies).
June 14, 2008 XLT941 A new utility for translating HTML stream files to other national languages, see this page.
April 16, 2008 CGIDEV2 This release includes a change to subprocedure WrtHtmlToStmf, suggested to the Easy400Group in order to overcome some problems related to the new line control character.
April 2, 2008 MMAIL-AMailer Improved pgm MMAIL/PRCUSRMAIL. This program is an example of how to receive and process the incoming mail with your programs. Suggestions provided by Norbert Gaberle, Austria. See this page.
March 8, 2008 MMAIL Predefined text header for EML... commands, see command EMLHEADER.
March 3, 2008 POP3READ Doesn't need any longer to run with job CCSID 37.
March 1, 2008 MMAIL A new parameter added to command STREMLSPLF allows to select the spool files to be e-mailed from their user-data, instead of their names. See this page.
February 19, 2008 POP3READ Fixed bug. Would not write a record to file POP3MAIL if the "From:" e-mail address in the received message not within acute parenthesis < ........... >
February 12, 2008 MMAIL Command CVTSPLSTMF now provides appropriate spool file conversion to PDF also for job-CCSIDs other than 37.
December 21, 2007 MMAIL New command EMLSPLX for e-mailing spool files. It includes the same parameters as command EMLSPL. However:
  • An overall conversion to PDF option is available
  • A parameter (PDFUTILITY) is available for selecting among the available conversion utilities
  • If conversion utility CVTSPLSTMF is selected, parameters for assessing the PDF layout are also prompted.
December 15, 2007 MMAIL-AMailer Fixed some problems with multiple attachmentsand with Content-ID. Flagged incoming messages not yet completely processed.
November 14, 2007 MMAIL-AMailer
  • Footer option added to Tools
  • UTF-8 decode supported
November 3, 2007 MMAIL
  • BASIC- Predefined text footer for EML... commands, see command EMLFOOTER
  • AMailer- When receiving messages with dual presentations (text and html), the html presentation is now selected, instead of the text one.
October 30, 2007 MMAIL - AMailer This is a major release that provides far better performance in displaying message bodies.
For details see page What's New in MMAIL.
October 22, 2007 POP3READ Some fixes on POP3READ file fields: subject, from, to.
October 17, 2007 LOGINOUT LogInOut is a new utility which provides a solution for application driven Login/Logout to/from WEB sessions. In other words, it is an alternate solution to that of using HTTP directives based on user profiles or validation lists for restricting the access to sensitive applications.
October 11, 2007 IFSTOOL Fixed a potential problem with the data queue "unique" name in program READDIR.
September 14, 2007 MMAIL Added command SETMAILLIB. This command populates a user library with the objects needed for developing MMAIL-based ILE-RPG programs.
August 27, 2007 MMAIL Troubleshooting topic added to MMAIL initial page. As a troubleshooting tool, CGI program DSPQZMFDTA (Display QZMF journal entries) has been made available.
August 21, 2007 MMAIL - AMailer Added the Out-of-office tool. See this page.
August 10, 2007 MMAIL A new parameter (PDFNAME) has been added to command EMLSPL. It allows to assign the desired name to the generated PDF stream file.
July 8, 2007 MMAIL - AMailer A new large utility has been made available in MMAIL: AMailer.
AMailer is a free open-source WEB_Mail application for the iSeries.
It supports multiple users, both Local and Internet.
As with any other PC-based commercial mailer, users may receive and send mail messages, including attachments.
Please refer to the AMailer tutorial for more information.
May 31, 2007 POP3READ New release available for V5R1 - Some performance enhancements. Measurements: CPU usage 22 times lower, response time 4.5 times shorter.
May 9, 2007 MMAIL New command sendmime was made available. It allows to mail -through a single MIME message- a combination of different types of objects:
  • IFS stream files
  • Database files
  • Source file members
  • Spool files
  • Spool files converted to PDF
Up to 100 different pieces (objects) can be sent for each type of object.
The MIME message can be sent up to 100 receivers.
This command was contributed by Paul Manners, United Kingdom.
May 2, 2007 WEBSEC Application Driven Protection - Some small changes to sample program LOGON, to make it more flexible for user customization.
April 3, 2007 POP3READ It was found that some undue (control) characters were generated in the texts of the received e-mail messages. That was due to API QDCXLATE, which is no longer used.
March 1, 2007 MMAIL Fixed a bug in subprocedure MimeSplPdf (used by command EMLSPL). The bug was generated in the January 19th release. MimeSplPdf was no longer able to convert a spool file to PDF when the preferred conversion tool happened to be CVTSPLSTMF.
Besides it was found that in some cases the PDF's generated by CVTSPLSTMF within MimeSplPdf subprocedure could not be processed by Adobe (error 110). That was also fixed.
January 19, 2007 MMAIL Subprocedure MimeSplPdf can now receive an optional parameter, the name to be assigned to the PDF file. This may result to more understandable names, when spool files converted to PDF's are attached to MIME messages. The code was contributed by Carlo Arnaboldi, Italy.
January 11, 2007 MMAIL Please note that the minimum OS/400 release to install MMAIL is V5R1. In the current release a fix has been added for boxes running V5R1. Command MMAIL/CHGJOBCSID used to call API QLGRTVDC (to compute the default CCSID from system value QLANGID). However, this API was made available with V5R2. An alternate solution has now been provided for V5R1 installations.
January 8, 2007 POP3READ A fix was applied to subprocedure pop3login which was entering a never ending loop in the case where the user or the password were rejected by the pop server.
December 21, 2006 POP3READ A new open source utility, an ILE-RPG POP Client allowing to receive and store on IFS directories mail messages from any POP Server, provided you know user names and passwords. See this page.
September 25, 2006 MMAIL A more recent version of command CVTSPLFPDF was made available. Command MMAIL/CVTSPLFPDF is based on two libraries: HPT and TIFFLIB. A more recent version of those two libraries was downloaded from site UZAEMON's Homepage.
September 13, 2006 MMAIL New MimeRtnPth subprocedure allows to generate MIME header Return-path. This header allows to specify an e-mail address where error messages (bounce messages) should be returned to. See page http://www.easy400.net/mmailh/srvpgm.htm#Q04.
Warning. Programs referring service program mmail/sendmail may bump out after reinstalling library MMAIL and need to be re-compiled.
August 11, 2006 MMAIL Command MMAIL/STREMLSPLF was added two more parameters in order to support the name and the e-mail address of the sender.
August 5, 2006 MMAIL Some users found that MIME files containing just attachment(s) but no message body used to be rejected by SPAM filters of receiving mailers. This was found to be due to a flaw in subprocedure "MimeImbNul (Imbed a null body)". That subprocedure was not providing a boundary delimiter.
July 28, 2006 MMAIL Command MMAIL/RESEND was fixed. It will no longer try to resend stream files in directory /mmail/temp other than mmail-generated MIME files.
July 26, 2006 MMAIL A bug was fixed in subprocedure "MimeSplPdf" (Convert a spool file to PDF and attach it to the MIME file). This procedure used to bump out when the spool file could not be found. In such a case, now this subprocedure would return without attaching the spool file and an error message would be logged on the external message queue.
May 22, 2006 SECTCP &
WSECTCP
A design change has been implemented.
In previous releases, the only user profile allowed to define SECTCP protections was QSECOFR. In many iSeries installations, however, QSECOFR user profile is not really accessible.
In this release, the only user profile allowed to define SECTCP protections is a USRCLS(*SECOFR) user profile identified during SECTCP installation.
Please note that installation of the new release of WSECTCP has as a prerequisite the installation of the new release of SECTCP (previously installed releases of SECTCP are no good for the new release of WSECTCP).
May 2, 2006 MMAIL After the sending of an e-mail, the MMAIL service program was entering a delay job of 5 seconds. That was done to fix some unknown errors in the QTMMSENDMAIL API when subject to high frequence messaging.
That delay job has now been removed. Instead, a timestamp is saved after a message has been sent. On the next message, the service program computes the time elapsed since the last previous message, and it makes sure it is at least 5 seconds.
In this way, users sending interactive messages would experience a better response time.
February 15, 2006 MMAIL Two new WEB utilities made available. They allow a WEB user to work with spool files and writers. See this page.
February 11, 2006 MMAIL Fixes asked by some customers:
  1. Fixed the srvpgm used by the Windows utility
  2. Some EML... commands were sending messages with attachments but without message body. An empty message body is now generated when no message body requested by the user. This should take care of some odd behaviors of the receiving mailers, as an user did report.
  3. The new 5250 utility MNGSPLF did run into problems when issuing commands CHGSPLFA or WRKSPLA with an OS/400 release older than V5R1, because the CRTDATE parameter was not supported. The installed OS/400 release is now tested, and the CRTDATE parameter is now provided from V5R1 on.
January 9, 2006 MMAIL Several changes/ enhancements:
  1. Minimum OS/400 req. now V4R5 (was V5R1)
  2. PDF manual available at http://www.easy400.net/mmail/manual/MMAIL_Manual.pdf
  3. Search engine available; maybe used for other sites
  4. command SPLTOPDF to convert spool files to PDF via your favorite conversion tool
  5. command MNGSPLF similar to WRKSPLF, but providing new input parameters, and allowing for spool file e-mail, and conversion to .txt, .html, and .pdf stream files.
December 31, 2005 MMAIL "bcc" requirement.
Blank copy adressees should not be reported in the destination headers of a MIME file. They should just be mentioned to the SendMail subprocedure.
In order to explain how this can be implemented, all the programs invoked from MMAIL/EML... commands have been updated in order to fulfill such "bcc" requirement.
November 3, 2005 MMAIL
  1. On charge utility AFPTOOL is no longer distributed by MMAIL. It is still supported by MMAIL, but it should be downloaded from site BVS tools
  2. internal subprocedure rtvbndr (retrieve part boundary delimiter) was returning a blank boundary delimiter when not preceded by the internal subprocedure setbndr (set part boundary delimiter). The internal subprocedure setbndr is called by user subprocedure MimeMultiP, while the internal subprocedure rtvbndr is called by user subprocedures MimeWrtB (add a boundary record), MimeImbAtt (imbed or attach an IFS file), and MimeClose (Close a MIME file).
    This used to result to the wrong MIME files (not understandable by the receiver) whenever the process building the MIME file was not using subprocedure MimeMultiP.
    This is now fixed: in such cases a default part boundary delimiter is generated.
August 18, 2005 MMAIL In the Easy400Group, Tom Graham reported that on V5R3 command CvtSplfPdf was receiving a QwpzHostPrintTransform error.
After much investigation, he found that program HPT/SPL2STMFRP was missing to initialize some fields in a routine.
Tom Graham fix is included in this MMAIL release.
August 17, 2005 MMAIL Version 1.3.0 of the Windows utility made available. See page www.easy400.net/mmailh/wmimemenu.htm .
August 12, 2005 WEBSECURE The installation procedure now allows also for Apache HTTP directives.
August 12, 2005 EASY400APC Updated Apache HTTP directives.
August 5, 2005 MMAIL There was a problem with turkish language. In the multipart delimiter, the double quotes in BOUNDARY="..." were converted to . The result was that the receiving mailer could not understand the subsequent headers, such as "Content-type: ...".
The problem was fixed in this release.
August 3, 2005 WEBACT EASY400 user profile no longer needed to run WebAct (iSeries WEB Access Toolkit).
August 1, 2005 MMAIL Changed the multipart delimiter. It was suspected being the reason for failures of some receiving mailers. The multipart delimiter now
  • has a different layout
  • is no longer static, is dynamically built.
See procedures setBndr and rtvBndr in RPG module XXXMIME.
July 29, 2005 CGIDEV2 IBM has assigned maintenance and support of CGIDEV2 to the IBM profit center Client Technology Center.
As a consequence
  • CGIDEV2 in no longer available for download from this Easy400 site (the download page provides a link to the CTC)
  • All CGIDEV2 support should be asked to the CTC person in charge for that, Rich Diedrich.
  •  
    I was in IBM Italy for 39 years. Started with OS/360, went through 370, enjoyed System/38 and landed on AS/400. I always played two roles, manager and professional at the same time.
    In year 1997 I got a major stroke when I discovered the easy way to make WEB from some Mel Rothman's work, CGIDEV. That day I started building my mission: enabling people to reach great results through simple code delivered via WEB.
    When in year 2005 I left IBM I thought I could continue my way through a WEB site on my own expenses. I'm glad I did that, because from this I got more recognition than I ever had before.

    contact Giovanni Get in touch with Giovanni.