All the following is downloadable at no charge, inclusive of all the sources:

• TCP/IP 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 Aug 06, 2010)
  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
  1. 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.
  2. 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.
     
  We teach this approach through demos, tutorials, and sample source code.
  You may download all this, install it on your iSeries 400, run it exactly as in our Web site, and learn from the original source code, which is totally delivered, inclusive of the service program!
  A special tutorial is provided separately:
  • Self-study class on HTML and RPG CGI (library CGI400C2 - last release Aug 06, 2010)
  
  
• COBOL CGI programs development tool (library CGICBLDEV2- last release Aug 06, 2010)
  A special wrapper allows COBOL programs to exploit the same functionalities provided to RPG programs for the WEB.
  A COBOL CGI tutorial is included.
  
  
• A brief tutorial on JavaScript (library JS2- last release Aug 06, 2010) that you may need further on to provide enhanced functionalities to your HTML scripts.
  
  
• WRKVLDL (library WRKVLDL- last release Aug 06, 2010).
  A validation list maintenance utility.
  
  
• WEB Session Login/Logout Manager (library LOGINOUT- last release Aug 06, 2010).
  An utility to implement application controlled WEB Login and Logout.
  
  
• HTTP powered by Apache - last release Aug 06, 2010 - Some considerations for beginners
  
  
• Utilities for your Web site:
  1. Triple A Secured TCP (library SECTCP - last release Aug 06, 2010)
     It provides customized security for your FTP, WSG, and TELNET servers.
     It also provides logs, browsing and quering facilities, that will make your auditing really easy.
     Check out the IBM page on this tool.
  2. Library Compressor (library EZPACK3 - last release Aug 06, 2010)
     It allows to save OS/400 libraries as PC compressed files. It could be a valuable tool in cases where you are, say, an iSeries 400 software company and you want to enable your customers to download through the Internet the latest versions of your products.
  3. iSeries WEB Access Toolkit (library WEBACT - last release Aug 06, 2010)
     It provides webmasters with some facilities to maintain their iSeries Web sites through the Web itself.
     Read some documentation.
  4. MIME & Mail (library MMAIL - last release Sep 08, 2010)
     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..
     Read some documentation.
     Library MMAIL includes an iSeries Webmail application, named AMailer. To know more, read here.
     
  5. POP3 Client (library POP3READ - last release Aug 06, 2010)
     An ILE-RPG Pop3 Client program that would contact via socket any Pop server and receive mail messages into IFS directories. Read some documentation.
  6. IFS Tool (library IFSTOOL - last release Aug 06, 2010)
     A set of programmable commands to work with IFS objects.
     Read some documentation.
  7. IFS strings and stream files conversion (library CVT101 - last release Aug 06, 2010)
     Subprocedures and commands to convert strings and stream files from one code page to another code page, Unicode included.
     Read some documentation.
  8. File Upload / Download Utility (library FUPLOAD - last release Aug 06, 2010)
     It allows to upload / download via HTTP IFS stream files.
     Read some documentation.
  9. HTML stream file translator (library XLT941 - last release Aug 06, 2010)
     Allows for easy translation of your HTML stream files to other national languages.
     Read about it.
  10. ZIP and UNZIP commands on the iSeries (library ZIP - last release Aug 06, 2010)
      Are you one of the few left without ZIP/UNZIP commands on the iSeries? This is your chance.
      Install in a few seconds at no charge!
  11. Save & Zip (library ZIPSAVE - last release Aug 06, 2010)
      Save and zip your save files directly on the iSeries. Unzip on the iSeries.
      Read about it.
  
  
• 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 utilities are based on CGI programs (run under WEB):

  • "Translate message descriptions used in DDS" (library XLTMSGF, last release Aug 06, 2010). provides a quick way to translate to another national language the message descriptions used in display or printer files.
    See this page.
  
  
• Excel spreadsheets:

  Utilities to handle Excel spreadsheets on the iSeries.

  • For reading Excel spreadsheets:
    • XLPARSE (library XLPARSE, last release Aug 06, 2010). This utility, based on the original Scott Klement's XLPARSER4 code (included), makes reading XLS Excel spreadsheets with ILE-RPG so simple. Documentation is available at this page.
    • XLPARSE2 (library XLPARSE2, last release Aug 06, 2010). This utility, based on the original Scott Klement's XLPARSER4 code (included), allows to read both XLS and XLSX Excel spreadsheets with ILE-RPG. Documentation is available at this page.
  • 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 Aug 06, 2010) 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.
      Documentation is available at this page.
    • HSSFCGI (library HSSFCGI, last release Sep 07, 2010) 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.
      Documentation is available at this page.
  
  
• Miscellaneous:
  • PgmRegen - last release Aug 06, 2010, an utility able to retrieve the composition of ILE programs and to automatically regenerate both OPM and ILE programs in all HLL languages.
  • PLCheckUp - last release Aug 06, 2010, an 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.
  • Db2XTools - last release Sep 08, 2010, by Antoon van Os, an utility able to convert database files to PC formats (.csv, .html, .txt, .xml) and to display the results via EXCEL, Internet browser, or Notepad.
  • E-Police - last release Aug 06, 2010, a set of utilities to help you managing small emergencies on your system.
  • CGI_WRKDBF - last release Aug 06, 2010, an utility to browse database files on your Internet browser. Records can also be added, updated and deleted.
  • ODF (Object Distribution Facility) - last release Sep 08, 2010, an utility to distribute objects to other IBM System i's. A time saver for maintaining multiple systems.
  • VRTSAV (Virtual Save & Transfer) - last release Aug 06, 2010, an utility to perform saves on virtual tapes and to transfer save data to another system, where they can be copied to real tape volumes.