Oct 16, 2018 5:20 UTC
visitatori:   36
cerca con google   
Navigazione sito Easy400
Code snippets

ultimi aggiornamenti
Easy400Group forum
Su suggerimento della associazione Common Italia abbiamo pubblicato sulla rivista System i NEWS una serie di articoli che spiegano come utilizzare la utility CGIDEV2 per realizzare siti WEB a costo zero con del semplice RPG.
Puoi scaricare ed installare sul tuo System i gli articoli unitamente ad un utilissimo eserciziario di CGIDEV2, premendo questo link. Accelererai di molto il tuo apprendimento di CGIDEV2.
Per le tue domande su CGIDEV2, utilizza il forum CGIDEV2-Italia.
Utilità di Easy400.net:
ultimi principali aggiornamenti
Per informazioni dettagliate anche su aggiornamenti minori, utilizzare i collegamenti seguenti:

apiguide babel_i cgicbldev2 cgidev2 cgiwrkdbf chgpwd chkifsobj cvt101 db2xtools endjobs
epolice esectcp ezpack ez4parse ez4webserv fixhdtab fupload graphit howtoajax hssfcgi
ifstool jsdatepick killmyjobs loginout mmail odf plcheckup pop3read pwdreset sectcp
syncjob vrtsav webact websql wrkvldl wsectcp xlparse2 xlscgi zip zipsave


October 16, 2018 MMAIL New command EMLNOTE takes advantage from V7R1 API QtmdCreateSendEmail to provide a fast "create & send" of a MIME note featuring a TEXT / HTML / XML body and up to 50 stream file attachments. See this page.
October 6, 2018 MMAIL New command EMLSMTPEMM, based on system command SNDSMTPEMM, quickly sends an impropmptu e-mail message with attachments.
September 28, 2018 HSSFCGI Important updates regarding multi-spreadsheet workbooks and huge workbooks.
September 7, 2018 HSSFCGI In XLSGEN, the contents of an Excel spreadsheet cells can now be rotated using keyword "rotate", see this page.
In commands TABLEXLS and TABLEXLS2, a new parameter HDGROTATE allows to rotate vertically the columnh headers. See this page .
September 4, 2018 MMAIL All MMAIL/EML... commands are now supporting distribution lists through parameter TODSTL (To Distribution Lists).
A special WEB utility, Work With Distribution Lists (WRKDSTL), allows to create and to maintain distribution lists, see http://mmail.easy400.net/html/othutils.htm#wrkdstl.
August 13, 2018 XLPARSE2 Greatly simplified the set up of the environment for the Java Virtual Machine.
August 12, 2018 HSSFCGI Greatly simplified the set up of the environment for the Java Virtual Machine.
August 11, 2018 MMAIL-AMailer Program PRCUSRMAIL (process incoming mail in your own way) has been updated to account for incoming messages stored in pseudo directories other than the "MailReceived" one.
August 7, 2018 MMAIL-AMailer AMailer users can now define filters for their incoming mail. This is a new option in the "Tools" menu. See this page.
August 4, 2018 IFSTOOL Command MONIFS was added two new parameters (FROMTIME and TOTIME) allowing to specify the time interval for reception of journal entries.
New command ENDMONIFS allows to reschedule the ending date and time of an ongoing MONIFS atcivity.
July 28, 2018 IFSTOOL Command READDIR now supports IFS path names
  • with leading and / or trailing blanks
  • imbedding quotes (char ' )
July 11, 2018 HSSFCGI & XLPARSE2 No-operated references to options of product 5770JV1 which were detected not compatible with HSSFCGI and XLPARSE2.
See this page.
July 4, 2018 CGIDEV2 Responsive HTML Design implemented on all CGIDEV2 Basic Demos and Boats Demo.
Responsive HTML allows to automatically resize, hide, shrink, or enlarge, a website, to make it look good on all devices (desktops, tablets, and phones).
Try the following CGIDEV2 demos on your smart phone:
June 26, 2018 XLPARSE2 Some new features for CGI program UPLANDRUN (Submit a XLSTABLE or XLSTABLE2 job from a WEB browser):
  • XLSTABLE/XLSTABLE2 parameters TIMECOL and TIMESEP are now supported also on this WEB page
  • The WEB user is now enabled to inquiry about the status of the submitted XLSTABLE/XLSTABLE2 batch job and to display its joblog if something goes wrong.
June 6, 2018 HSSFCGI Null cells supported.Null cells are left vacant in the spreadsheet.
June 2, 2018 HSSFCGI No enhancements in this release. Just one fix in displayng the correct cell format when DECPOS(*NOC).
The internal architecture of all the XLSGEN programs has been improved to provide larger flexibility and a little more performance.
May 14, 2018 HSSFCGI In commands XLSGEN, XLSGEN2, XLSXGEN, XLSXGEN2, TABLEXLS and TABLEXLS2, new parameter NEGFMT supports three different formatting of negative numbers.
The same result can be obtained at single cell level with XLSGEN keyword NGFMT.
April 11, 2018 SYNCJOB New command SBMTSYNJOB makes it easier to submit a tightly synchronized job.
April 1, 2018 MMAIL-AMailer New AMailer features made available:
  1. Auto-Receive Timer for the WebMail page "Mail Received"
  2. Rerouting option for incoming mail
  3. POSTMAN non-ending job to receive mail for all users
March 18, 2018 CGIDEV2 Procedure WrtHtmlToStmf() now supports also UTF CCSIDs (1200 to 1237) for the created stream file.
March 16, 2018 WSECTCP Access restriction feature implemented for Private Allowed Directories now supported also from WSECTCP.
March 14, 2018 SECTCP Access restriction feature implemented for Private Allowed Directories.
March 9, 2018 LOGINOUT Major utility review. Changes to service program, sample programs and manual. New support for temporary and expirable cookies. PDF of its manual now available.
March 2, 2018 LOGINOUT Fixed an error in module XCRYPT which was preventing LOGINOUT installation
February 21, 2018 CGIDEV2 Module XXXCGIPARS - A piece of code was added to make it compatible with Microsoft ASP.NET .
February 16, 2018 BABEL_I This is the successor a XLT941, the utility for translating quick and easy HTML WEB pages to other national languages. BABEL_I has added a lot more instruments for supporting the translation job. Read about it.
January 10, 2018 XLT941 XLT941 is a powerful tool for translating HTML stream files to other national languages. XLT941 is especially suited for CGIDEV2-based HTML skeleton scripts. Read about it at this page.
This is a major review of the tool.
January 4, 2018 XLPARSE2 XLSTABLE2 non longer needs special authority *ALLOBJ for the job user profile.
January 1, 2018 APIGUIDE This is a new tool, intended to provide examples for using some of the IBM isystem API's. See page http://www.easy400.net/apiguide/html/page1.html.
December 11, 2017 KILLMYJOBS This is a new utility. See page http://www.easy400.net/killmyjobs/html/page1.htm.
November 1, 2017 CGIDEV2 CGIDEV2 now featuring procedures and commands to encrypt / decrypt character strings and stream files. See this page.
October 5, 2017 ZIPSAVE Major review. CL commands CPYTOARCF and CPYFRMARCF may now be used - instead of Qshell command JAR - to perform zip and unzip operations.
September 25, 2017 ZIP The ZIP utility has been added command ZIP/ZIP2.
While command ZIP/ZIP (based on QSHELL command "zip") has a limit of 2 Gigabyte for the total amount of data to be compressed, command ZIP/ZIP2 (based on QSHELL command "jar") has no such a limit.
See this page.
September 10, 2017 XLPARSE2 Commands XLSCONVERT, XLSTABLE and XLSTABLE2 are now featuring a new parameter, SBMJOB.
This parameter allows these commands to be executed in synchronized batch jobs, so that the JVM started by these commands does not conflict with any JVM in the current job.
August 6, 2017 IFSTOOL New command GETOBJATTR returns the properties (attributes)of an IFS object.
This can be very useful for periodic checks on IFS object access permissions.
July 28, 2017 WRKVLDL New look of WEB pages.
July 27, 2017 XLPARSE2 Commands XLSCONVERT. XLSTABLE and XLSTABLE2 are now able to properly convert Excel "date" cells.
  • "Unclassified" FTP IP addresses cannot even try to login.
  • "24 hrs FTP SECTCP-rejections log" provides rejection reasons.
  • a completely revisited version including management of the last SECTCP features: Allowed Private Directories, FTP login via Validation List and SECTCP Rejections Log.
June 22, 2017 SECTCP Provided support for logging on FTP from a validation list instead of using a user profile.
Check out this page .
June 17, 2017 HSSFCGI New XLSGEN and XLSXGEN feature:
  • in <data type="number" ...> and in <data type="largenumber" ...>
    the new keyword DEC-POS="n" allows to override the number of decimal positions specified in parameter DECPOS of commands XLSGEN and XLSXGEN.
    See this page .
May 20, 2017 IFSTOOL New command CPYSTMF allows to copy in a single shot multiple stream files and to optionally convert them to a different CCSID. See this page .
April 28, 2017 MMAIL It is now possible to add an icon to the subject of any EML... command. A default icon can also be defined via command DFTSICON.
April 22, 2017 HSSFCGI New command ZIPWKB (Zip Excel workbooks) allows to compress into a .zip file the Excel workbooks generated from commands XLSGEN, XLSXGEN, TABLEXLS and TABLEXLS2.
See this page.
April 10, 2017 MMAIL Improved INFOPRINT support in spooled file to PDF conversion.
April 10, 2017 IFSTOOL In command MONIFS fixed a bug causing some IFS events not to be detected.
March 30, 2017 HSSFCGI Major redesign to support generation of extremely large spreadsheets. Implemented by replacing parameter RECOVERY with parameter SHEETSIZE in commands XLSGEN, XLSXGEN, TABLEXLS and TABLEXLS2.
Read online documentation on page http://www.easy400.net/hssfcgi/html/page2.htm.
March 20, 2017 HSSFCGI V7R3 enabled.
March 20, 2017 XLPARSE2 V7R3 enabled.
February 26, 2017 MMAIL New command SETMSGLVL provides additional information for problem determination when e-mail messages are sent. See How To.
February 12, 2017 SECTCP and WSECTCP Logs lifetimes now controlled by command SECTCP/LOGPURGE. Expired logs now removed by command SECTCP/LOGFIX.
January 14, 2017 MMAIL New feature for archiving outbound e-mail messages, see this page.
Provided a default program for logging the outbound e-mail messages, see this page.
January 9, 2017 HSSFCGI Two new commands, XLSUPD and XLSXUPD, can now be used to update existing Excel spreadsheets. Individual cells can be updated and added. See this page.
January 2, 2017 IFSTOOL Added command FIND. It provides a list of IFS objects (directories and stream files) matching a given name pattern.
See this page.
December 23, 2016 ENDJOBS A new command named CHKACTJOB periodically checks the active jobs so that an user program may take actions from job information passed to it.
December 12, 2016 ez4WebServ EZ4WEBSERV (Easy400.net Web Services) is now featuring a tool to provide Web services at no cost.
November 19, 2016 HSSFCGI A new demo pgm (GOCATALOG) shows how properly handle pictures in generating Excel spreadsheets via XLSGEN.
October 21, 2016 ez4WebServ This is a new tool (WEB Services) based on Scott Klement's HTTPAPI. Documentation.
September 22, 2016 EZ4PARSE A new set of commands has been added to command XMLPARSE. Read about them.
September 8, 2016 HSSFCGI A "banner" feature just added to commands TABLEXLS and TABLEXLS2. Check out this page.
August 17, 2016 CHKIFSOBJ A command to check the existence of IFS objects.
August 8, 2016 EZ4PARSE New utility to parse XML stream files
August 5, 2016 SECTCP Fixed problems in controlling FTP allowed domains.
July 15, 2016 VRTSAV Can now run also on V5R4.
March 14, 2016 GRAPHIT Great improvements in charts presentation and a few bugs fixed after the update to the engine Chart.js .
March 13, 2016 MMAIL Several new features:
March 13, 2016 CGIDEV2 CGISRVPGM2 subprocedures DspStmf() and DnlStmf() are now able to download stream files larger than 16 MB.
January 31, 2016 ODF Major utility review. New command CVTSTMF.
January 24, 2016 HSSFCGI Two new XLSGEN features:
  • ROW level keyword ROW-HEIGHT allows to define the height of a row (in points)
  • DATA level keyword VALIGN allows to define the vertical alignment of data within a cell.
For more information see this page.
January 21, 2016 MMAIL Now compatible with system value QCCSID=65535, see FAQ # 15.
January 21, 2016 HSSFCGI Automated reformatting of XML-like input stream file now prevents XLSGEN from missing some script <...> tags.
January 16, 2016 HSSFCGI A new XLSGEN data type has been made available.
The XLSGEN tag <data type="LARGENUMBER" ... > creates a numeric cell with a font 3 times bigger than the one from tag <data type="NUMBER" ...>.
January 14, 2016 ENDJOBS New command DSPENDJOBS (Display the log of ended jobs) provides enhanced control to users of command ENDJOBS.
December 28, 2015 MMAIL A severe error in MMAIL installation procedure was fixed.
December 16, 2015 MMAIL Procedure MimeSubj() now always encodes in UTF-8 the subject of a mail message, thus lowering the message SPAM level.
December 14, 2015 ODF New command ODSTMF allows distribution of IFS stream files without using save files. Very useful when a remote system runs an OS/400 version no longer supported at the source system.
November 21, 2015 SECTCP & WSECTCP Major review of FTP and TELNET exit point programs.
October 26, 2015 GRAPHIT Added an example program that demostrates how to embed a graph in a regular CGI WEB page. See this page.
October 22, 2015 MMAIL-AMailer When defining an AMailer new Internet account for receiving and processing mail from a POP3 server, instead of entering the IP address of the POP3 server, you may now enter its host name (DNS name, example: pop.yahoo.com). This removes concerns on possible future changes of the POP3 server IP address.
October 13, 2015 SECTCP & WSECTCP Slightly modified their FTP Active Defence Strategies.
October 7, 2015 MMAIL Added procedure MimeImbBuffer() added to service program MMAIL/SENDMAIL. It allows to embed - in the body of an e-mail message - the script generated in the output buffer of a CGIDEV2-based program.
September 10, 2015 HSSFCGI Features to better control the printing of spreadsheets have been added to the XLSGEN language and to commands TABLEXLS and TABLEXLS2.
These features are related to paper size and to width/height compression.
September 4, 2015 HSSFCGI TABLEXLS2 has been given the same WEB features as TABLEXLS. See this page.
August 18, 2015 HSSFCGI A new formula command in XLSGEN language, XVSUM, allows to perform a sum of all the preceding cells in the same column that did perform a VSUM formula.
In this way, while VSUM can be used to implement multiple subtotals in a column, XVSUM can be used to implement a bottom line "grand total".
Run this example.
August 1, 2015 HSSFCGI XLSGEN formulas VSUM/HSUM/VAVG/HAVG are now 100% reliable even in spreadsheets with more than 32767 cells.
July 30, 2015 SECTCP Solved a security exposure.
Program SECTCP/SERVERREQ (used by FTP exit point QIBM_QTMF_SERVER_REQ) was not understanding and therefore not controlling requests for paths including "/.." notations, like
(which results to /home/ROBERT).
FTP sessions started from WEB browsers like Firefox do commonly use such path notations and a result SECTCP was failing its path checks, thus allowing WEB user to access non allowed directories.
That was fixed in today SECTCP release.
July 28, 2015 DB2XTOOLS Fixed severe errors in commands DB2CSV, DB2TXT, DB2HTML and DB2XML.
July 28, 2015 WEBSQL A new version provides more error detection facilities in case of failure of DB2XTOOLS commands DB2CSV, DB2TXT, DB2HTML and DB2XML.
July 18, 2015 IFSTOOL Fixed a bug detected in using parameter MASK of command READDIR.
July 11, 2015 MMAIL In all e-mail commands (e.g. EMLMSG), *BCC now replaced by *BC .
June 4, 2015 HSSFCGI Fixed program TABLEXLS2 for the case when in system value QDECFMT the decimal point is a comma instead of a period.
April 29, 2015 IFSTOOL A new command, REPLACE, allows to scan all the stream files in a given IFS directory and to substitute a given character string - whenever it is found - with another character string. See this page.
April 22, 2015 HSSFCGI New command TABLEXLS2 performs faster than XLSTABLE and does not need the ILE-RPG compiler. See this page.
April 10, 2015 MMAIL Command EMLMSG has been added a new parameter (TXTSTMF) which allows to use a stream file (instead of a source member) to make up the message body.
April 2, 2015 MMAIL MMAIL/EMLSPL... commands, when requested to perform automated conversion of a *SCS spooled file to PDF, may now also use as conversion tool the charged product SPLTOOL, produced by Bradley V. Stone.
March 21, 2015 IFSTOOL New command WRKIFSREF provides a list of all jobs referencing a given IFS object, along with the related object references. In this way you may find out which job is inhibiting access to a given IFS object.
March 19, 2015 ENDJOBS Now featuring a new command, MNGIFSLCK. This command displays a list of jobs referencing a given IFS objects. The user may then decide to end jobs, depending on their object lock types.
A unique feature, not available in any of the IBM i system commands.
March 17, 2015 Trial Versions Trial versions of CGIWRKDBF, DB2xTOOLS, IFSTOOL, HSSFCGI, MMAIL, SECTCP, XLPARSE2, ZIP and ZIPSAVE have been withdrawn, as their redemptions did not reach desired values.
March 1, 2015 IFSTOOL Command IFSTOOL/MONIFS has a new parameter (LOCKWAIT). This new parameter, if used, allows to delay the registration of an IFS object event at a time when object locks are ended.
February 6, 2015 MMAIL-AMailer MMAIL AMailer and command MMAIL/PRCUSRMAIL now sopport also the Microsoft Exchange POP3 server, in addition to the usual traditional POP3 server.
January 26, 2015 V5R2 MMAIL Though the V5R2 version of MMAIL is frozen, it was updated because of a number of V5R2 italian users who - all of a sudden - were receiving reject messages from mail boxes in domains "libero.it" and "virgilio.it".
January 11, 2015 EPOLICE Fixed a severe error on comand RCVMSGQ. It was imparing the ability to detect error messages sent to a message queue.
January 10, 2015 WRKVLDL Added some new programs able to send e-mail messages regarding user passwords (see this page).
December 6, 2014 MMAIL-AMailer AMailer is now able to process incoming mail messages larger than 16 MB.
November 23, 2014 POP3READ Enhanced POP3READ program to receive messages bigger than 16 mb.
November 22, 2014 XLPARSE Utility XLPARSE (Library Save & ZIP Facility) did undergo a major review and its manual is now available at this page.
November 16, 2014 MMAIL A new command, MRGJOBSPLF, allows to merge in a single spool file the *SCS spool files of a given job which are in *READY status.
In this way one may significantly reduce the number of spool files attached to an e-mail message.
Read about it.
November 3, 2014 XLPARSE2 A new version of command XLSTABLE has been made available and carries the name XLSTABLE2. XLSTABLE2 can be run in absence of the ILE RPG compiler and provides more flexibility on the record format fields of the physical file receiving data from the EXCEL spreadsheet. For more information see this page.
October 25, 2014 FUPLOAD A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 22, 2014 MMAIL A new command, MMAIL/CPYSPLFPDF allows to convert *SCS and *AFPDS spool files to stream file PDFs.
It requires at least V7R2 and requires option 01 (AFP to PDF Transform) of the 57xx-TS1 product be installed.
As of today this is the cheapest and easiest IBM i solution for converting spool files to PDF.
October 19, 2014 ZIP A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 19, 2014 ZIPSAVE A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 18, 2014 MMAIL A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 18, 2014 CGIWRKDBF A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 17, 2014 DB2XTOOLS A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 17, 2014 SECTCP A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 14, 2014 IFSTOOL A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 14, 2014 XLPARSE2 A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
October 13, 2014 HSSFCGI A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources not available in this version.
September 11, 2014 ZIPSAVE
  • Command UNZIPSAVE could fail when current directory was '/' .
  • Solved problems with UNZIPSAVE when the save file size exceeds 16 Mb.
September 4, 2014 HSSFCGI A new parameter, ZERODSP (Display zero values) was added to commands XLSGEN, XLSXGEN, WEBXLSGEN and TABLEXLS . A similar input variable was made available to CGI program WEBXLSTABL. When ZERODSP(*NO), the numeric cells (of a generated Excel spreadsheet) containing zero display nothing, instead of a zero. This can ease the spreadsheet reading when a large number of numeric cells contain zero.
August 28, 2014 CGIWRKDBF A new command, FRCFILTER, allows to force a database filter for all users other than the originator. See this page.
August 22, 2014 MMAIL Majour update to command SENDMIME.
August 13, 2014 PLCHECKUP Major revision of the utility. Added support for triggers.
June 24, 2014 XLPARSE2 Command XLSTABLE now enabled to process - besides stream files - also distributed stream files.
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>
  • 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
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
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
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
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
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
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
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
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 &
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.
Giovanni B. Perotti
è il proprietario del sito Easy400.net

Uscito dal liceo classico Giuseppe Parini (allora il migliore di Milano), appassionato di greco e di latino, ma altrettanto versato nelle materie scientifiche, dopo aver vinto una borsa di studio universitaria presso l' Almo Collegio Borromeo di Pavia, optai per la facoltà di Fisica. Mi laureai nel 1964. In quegli anni di crisi, mentre non mancavano gli incarichi universitari, era difficile trovar lavoro, come desideravo, in una industria. Alla fine accettai di entrare in IBM: stava nascendo l'informatica, anche se la parola ancora non era stata coniata.
Spedito di gran corsa negli Stati Uniti, partecipai alla nascita dei primi rilasci del Sistema Operativo OS/360. Rientrato in Italia, iniziai a sviluppare strumenti per la programmazione, seguendo passo passo tutti gli sviluppi nell'area mainframe.
Quando uscì il Sistema 38, mi colpì il grande salto di qualità rispetto ai mainframe e ne divenni in breve l'esperto europeo. Più tardi, quando venne alla luce l'AS/400, fui tra i primi in Italia a sostenerne la nascita ed a tentare di risolvere i problemi che aveva con l'ambiente S/36.
La mia aspirazione è sempre stata quella di far sì che gli sviluppatori avessero a loro disposizione strumenti facili e potenti. In tanti anni ho creato e diffuso svariati prodotti che hanno lasciato il segno in generazioni di programmatori.
Lasciando la IBM dopo 39 anni di lavoro interessante e divertente, ho deciso di continuare questa attività.
In questo sito trovate un buon numero di utility gratuite per l'IBM System i orientate al WEB.
Io seguo di giorno in giorno i miei utenti e fornisco risposte immediate ai loro quesiti.

contatta Giovanni Prendi contatto con Giovanni.