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
Audience:
- Those wishing to add non-traditional functionality to RPG programs without adding proprietary or complicated tools
- Web developers (PHP, Ruby, etc.) who want their scripts to be accessible from RPG.
- Fans of DB2 who wish to see a practical use of the new web service consumption capabilities of DB2.