1. Web Development
Configuration Guide (library TCPCFG)
A guide to configure your OS/400 TCP/IP
for the Internet.
RPG CGI program development toolset (library CGIDEV2
- last release Mar 20, 2018)
A toolset, based on a service program,
which allows to write Common Gateway Interface (CGI)
RPG programs through simple functions.
This toolset has two main advantages
We teach this approach through
demos and a tutorial
with a lot of sample source code.
- you define your HTML scripts in source members or in IFS stream files.
In concepts, this techniques is similar to that
of an externally defined file, though it's much easier than using DDS.
By using this technique, your programs
are largerly independent from the specific HTML
presentation. You may change your HTML without
changing your programs.
- your RPG program, instead of invoking directly the
HTTP APIs to handle the input/output from/to
the remote browser, requests services to CGIDEV2
service program. By doing this, your programming
is much easier, requires much less testing and performs at maximum speed.
You may download all this, install it
on your iSeries 400, run it exactly as it is on our Web site,
and learn from the original source code, which is
totally delivered, inclusive of the service program!
- COBOL CGI programs development tool
(library CGICBLDEV2- last release Apr 02, 2017)
A special wrapper allows COBOL programs
to exploit the same functionalities
provided to RPG programs for the Web.
A COBOL CGI HTML tutorial is included.
To download the COBOL CGI PDF tutorial, press here.
(library JS2- last release Nov 11, 2015) that you may need further on
to provide enhanced functionalities to your HTML scripts.
- How to ... AJAX (library HOWTOAJAX -
last release Jul 13, 2011).
Our experience in using Ajax, our suggestions and a demo.
(library WRKVLDL- last release Aug 01, 2017).
A validation list maintenance utility.
Web Session Login/Logout Manager
(library LOGINOUT- last release Mar 08, 2018).
A utility to implement application controlled Web Login and Logout.
File Upload / Download Utility (library FUPLOAD - last release Jun 18, 2015)
It allows to upload / download via HTTP IFS stream files via HTTP.
GRAPHIT (library GRAPHIT - last release May 13, 2016),
where you can learn how to generate complex HTML5 graphs from your CGI programs.
Pick Dates from a Calendar (IFS directory /jsDatePick - last release Oct 16, 2012)
Use it in your Web programs to feed date input fields with a pop-up calendar.
Fixed Header Tables (IFS directory /FixedHeaderTable - last release Feb 25, 2013)
Two JQuery plugins that keeps steady the table headers while the table is being scrolled.
BABEL_I (library BABEL_I - last release Feb 23, 2018)
A tool to translate - quickly and safely - HTML pages to other national languages.
iSeries Web Access Toolkit (library WEBACT - last release Mar 22, 2013)
It provides webmasters with some facilities to maintain their
iSeries Web sites through the Web itself.
2. Web Services
IBM i Web Services
(library EZ4WEBSERV- last release Mar 11, 2018). A tool to provide and consume Web services on IBM i
using low cost CGIDEV2 techniques.
(library EZ4PARSE- last release Mar 09, 2018). A XML parser that loads XML data to a database file.
3. MS Office Interface
- Converting database files to XML, HTML, CSV or TXT format.
Utility DB2XTOOLS (library DB2XTOOLS - last release Aug 04, 2016)
by Antoon van OS
performs PC format (XML, HTML, CSV or TXT) conversions both from green-black screens and from a Web browser
and immediately displays results on your PC.
Utility WEBSQL (library WEBSQL - last release Jul 29, 2015)
also by Antoon van OS
allows through a Web browser to define and to run an SQL query over System i databases, and to display results
on your PC according to DB2XTOOLS supported formats (XML, HTML, CSV or TXT).
- Reading Excel spreadsheets with an RPG program.
Utility XLPARSE2 (library XLPARSE2, last release Mar 26, 2018),
based on the original Scott Klement's XLPARSER4 code (included), allows to read
both XLS and XLSX Excel spreadsheets with ILE-RPG.
The greatest of it is command XLSTABLE, which creates a database file from an Excel spreadsheet.
- If you ever thought that creating and Excel spreadsheet from an ILE-RPG program
and sending it to a bowser was a challenge, you may now go with no effort:
XLSCGI (library XLSCGI, last release May 14, 2016)
utility takes advantage of the Excel native support of XML documents (since MS Office 2003).
It provides a nice way to generate XML documents suited for Excel.
HSSFCGI (library HSSFCGI, last release Jun 14, 2018)
utility uses Scott Klement's HSSFR4 service program and Jacarta POI HSSF Java classes (both included in the package) to generate
native Excel spreadsheets. This can be done with a simple ILE-RPG program, all the hard things
are kept under the covers. Graphics support is included.
This utility features commmand TABLEXLS, which converts whatever database file to an Excel Spreadsheet.
POP3 Client (library POP3READ - last release Aug 08, 2015)
An ILE-RPG Pop3 Client program that would contact via socket any Pop server and
receive mail messages into IFS directories.
MIME & Mail (library MMAIL - last release Jun 08, 2018)
A service program and utilities that allow to create and send mail messages attaching
any type of objects, such as documents, printouts, images, audios, videos, save files, etc..
Download the PDF MMAIL Delveloper's Guide.
Library MMAIL includes an iSeries Webmail application, named AMailer.
IFS Tool (library IFSTOOL - last release Dec 19, 2017)
A set of programmable commands to work with IFS objects.
IFS strings and stream files conversion (library CVT101 - last release Mar 28, 2011)
Subprocedures and commands to convert strings and stream files from one code page
to another code page, Unicode included.
ZIP and UNZIP commands on the iSeries (library ZIP - last release Apr 09, 2018)
Are you one of the few left without ZIP/UNZIP commands on the iSeries?
This is your chance.
Install in a few seconds!
Save & Zip (library ZIPSAVE - last release Oct 05, 2017)
Save and zip your save files directly on the iSeries. Unzip on the iSeries.
7. System control
E-Police (library EPOLICE - last release Feb 12, 2016),
a set of utilities to help you managing small emergencies on your system.
KILLMYJOBS (library KILLMYJOBS - last release Dec 11, 2017),
a command to kill your other interactive jobs.
ENDJOBS (library ENDJOBS - last release Dec 23, 2016),
two powerful commands, one to end all jobs matching given criteria, the other to end jobs allocating a given object.
Triple A Secured TCP (library SECTCP - last release Mar 14, 2018)
It provides customized security for your FTP and TELNET servers.
It also provides logs, browsing and quering
facilities, that will make your auditing really easy.
Download the PDF SECTCP Guide.
Web Interface for SECTCP (library WSECTCP - last release Mar 16, 2018)
Once you are running SECTCP, enjoy controlling it from your Web browser.
FTP & TELNET hacking statistics (library ESECTCP - last release Dec 17, 2017)
Find out where daily hacking attempts to your IBM System i come from (requires SECTCP).
(library PWDRESET- last release Jan 28, 2015).
A standard tool to assign passwords.
(library CHGPWD- last release Jul 02, 2016).
A quick Web tool to let users change the passwords of their user profiles.
API Guide (library APIGUIDE - last release Apr 29, 2018),
a set of examples of calling system APIs from RPG programs.
PgmRegen (library PGMREGEN - last release Jun 17, 2005), a utility able to retrieve the composition
of ILE programs and to automatically regenerate both OPM and ILE programs
in all HLL languages.
PLCheckUp (library PLCHECKUP - last release Aug 13, 2014),
a 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.
CGI_WRKDBF (library CGIWRKDBF - last release Jun 01, 2017),
a utility to browse database files on your Web browser. Records can also be added, updated and deleted.
ODF (Object Distribution Facility) (library ODF - last release May 10, 2018),
a utility to distribute objects to other IBM System i's. A time saver for maintaining multiple systems.
VRTSAV (Virtual Save & Transfer) (library VRTSAV - last release Jul 15, 2016),
a utility to perform saves on virtual tapes and to transfer save data to another system,
where they can be copied to real tape volumes. Download the PDF manual.
Library ZIP-packaging (library EZPACK - last release Sep 20, 2015)
Saves IBM i libraries into a ZIP stream file along with a text file containin the installation instructions.
Very useful if you distribute IBM i application software.
- Message files.
Use of messages externally described in messages files is a common technique for developing display files and
printer files enabled to support different national languages. However, maintaining and translating message files
is a real time consuming and boring task. This is why some utility in this area is usually welcome.
The following utility is based on CGI programs (runs under WEB):
Translate message descriptions used in DDS
(library XLTMSGF, last release Oct 05, 2012).
provides a quick way to translate to another national language
the message descriptions used in display or printer files.
Synchronized jobs for parallel processing (library SYNCJOB - last release Apr 10, 2018)
An easy-to-use technique for syncrhonizing jobs. Very useful for avoiding job environment conflicts (example: JVM settings) and for boosting application performance through parallel processing.