Front Cover -- Title Page -- Copyright -- Dedication -- Acknowledgments -- Contents -- Introduction -- Book Structure and Organization -- Naming Conventions -- Generic Compilation Instructions -- Open Source Tools Used in This Book -- Part 1: Flexible Input -- Chapter 1: Automate Data Transfers Using FTP -- Authorization Lists -- The Authority-Checking Process for Objects Using Authorization Lists -- Selling It to Your SysAdmin -- Chapter 2: Automate FTP in "Real Life" via LotusScript -- The Lotus Domino Agent -- RMTCMD and REXEC -- Chapter 3: Transfer a PC Text File to an IBM i Physical File in One or Two Easy Steps -- In One Step ... -- Or Two -- Drawbacks to FTP -- Chapter 4: Get Real-Time Integration Between Your PC Application and IBM i -- The VB Side of the Interface -- And the RPG Side -- Chapter 5: Import CSV Files with File Correcting -- Main Program Analysis -- The DBH_INV Service Program -- The CSVPRC Service Program -- The SQLPRC Service Program -- Chapter 6: Send Email from an RPG Program -- Requirements -- Other Procedures -- Email Address-Related Procedures -- Mime & Mail Sending Procedures -- Miscellaneous Procedures -- How to Configure Your IBM i to Send Email -- Where to Go from Here -- Part 2: Dazzling Output -- Chapter 7: Easily Transform Legacy Printouts into Excel Files -- A Quick Java Rundown -- RPG Support for Java -- Now That You Know a Little About Java, We Can Continue -- The Hard Way -- The Easy Way -- Wow, That Was Easy! But How Does It Work? -- The Even Easier Way -- Easy, But ... -- Easy, Easy, Easy -- Chapter 8: Generate Professional Charts in Real T ime -- The Pie Chart -- The Bar Chart -- The Geo Map Chart (Location Name Mode) -- The Geo Map (GPS Mode) -- The Gauge Chart -- The Column, Line, and Area Charts -- The Intensity Map Chart -- The Combo Chart -- The "Bars of Stuff" and "Piles of Money" Charts.

The Table API and Chart Interactions -- The Tree Map Chart -- Final Thoughts on Google's Chart APIs -- Chapter 9: BLOBs Keep PDF, XLS, and Other Reports Safe in DB2 -- What's a BLOB and What Can You Use It For? -- Now That You Know What It Is, Here's How to Use It! -- Final Thoughts -- Part 3: Going Global -- Chapter 10: GPS-Enable Your Database! -- Implementing the Steps -- A Quality Issue -- Multiple Results -- Final Thoughts -- Chapter 11: Using GeoNames Web Services to Collect Geo-Related Data -- The Time Zone Web Service -- The Country Code and Country Info Web Services -- The Find Nearby Points of Interest Web Service -- The Find Nearby Wikipedia Entries Web Service -- Final Thoughts -- Index.