04846nam 2200673 450 991046369020332120200520144314.01-58347-832-91-58347-835-3(CKB)2670000000570407(EBL)1811234(SSID)ssj0001399068(PQKBManifestationID)11799580(PQKBTitleCode)TC0001399068(PQKBWorkID)11452042(PQKB)11476428(MiAaPQ)EBC1811234(Au-PeEL)EBL1811234(CaPaEBR)ebr10953375(CaONFJC)MIL649494(OCoLC)892799372(EXLCZ)99267000000057040720141022h20142014 uy 0engur|n|---|||||txtccrFlexible input, dazzling output with ibm i /Rafael Victória-PereiraBoise, Idaho :MC Press,2014.©20141 online resource (445 p.)Includes index.1-322-18230-2 1-58347-833-7 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 StepsIn 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 OutputChapter 7: Easily Transform Legacy Printouts into Excel FilesA 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" ChartsThe Table API and Chart InteractionsThe 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 ServiceThe Find Nearby Wikipedia Entries Web ServiceFinal Thoughts; IndexLink your IBM i system to the modern business server world! This book presents easier and more flexible ways to get data into your IBM i system, along with rather surprising methods to export and present the vital business data it contains. You''ll learn how to automate file transfers, seamlessly connect PC applications with your RPG programs, and much more. Input operations will become more flexible and user-proof, with self-correcting import processes and direct file transfers that require a minimum of user intervention. Also learn novel ways to present information: your DB2 data will look gComputer architectureIBM computersProgrammingOperating systems (Computers)Virtual computer systemsElectronic books.Computer architecture.IBM computersProgramming.Operating systems (Computers)Virtual computer systems.004.22Victória-Pereira Rafael898387MiAaPQMiAaPQMiAaPQBOOK9910463690203321Flexible input, dazzling output with ibm i2007237UNINA