WMCPA Spring Conference 2017 has ended
Back To Schedule
Thursday, March 16 • 4:15pm - 5:45pm
PHP Tricks for the RPG Programmer: Graphics, Excel, PDFs, E-Mail and More

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Ever want to enhance RPG programs with PDFs, spreadsheets, charts and graphics, or connect to web services, without complicating your RPG program? Help is here from PHP and DB2. PHP not only builds web sites, but it can be called by RPG programs. Alan will show how to accomplish marvelous tasks by calling PHP from ordinary RPG programs via DB2's web service support, a fast, flexible technique that's a handy trick in itself.
Examples will include:Creating graphs and charts based on DB2 dataExcel spreadsheets from your dataPDF files from your dataConnecting to external JSON-based web services while keeping the RPG simpleSend flexible email messages, including HTML format and attachments, and using any SMTP server, including an Exchange serverYou will come away brimming with ideas to add pizzazz to your applications.

Learning objectives:
How to use SQL to call a web service, including a simple PHP-based web serviceHow RPG can use SQL to call the web service.Put it together: RPG calls PHP via a web service, creating graphical output from RPG in a simple manner


  1. Those wishing to add non-traditional functionality to RPG programs without adding proprietary or complicated tools

  2. Web developers (PHP, Ruby, etc.) who want their scripts to be accessible from RPG.

  3. Fans of DB2 who wish to see a practical use of the new web service consumption capabilities of DB2.

avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
Alan founded Seiden Group to help modernize IBM i applications using open source technologies such as PHP, Python, Node.js, and DB2 for i and RPG business logic. Recognized as an IBM Champion, Alan hosts the the CIO Summit twice per year. He and his team work with the best minds in... Read More →

Thursday March 16, 2017 4:15pm - 5:45pm CDT
Geneva 3