Welcome to the Online Session Guide for the COMMON 2017 Annual Meeting and Exposition. With your free account, you will be able to create a personal schedule, connect with other attendees, take session evaluations and download handouts.

Please note: the log in information for the Online Session Guide is different than your Cosmo ID and password. If you have an Online Session Guide account from a past COMMON event, please use it to log in. If you do not have an account, set up one here.
Back To Schedule
Thursday, May 9 • 3:30pm - 4:45pm
36AD Web Requests in Embedded SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

In this, you can discover how simple using embedded SQL is to add extra functionality to your existing or new RPG programs - including the use of the DB2 for i scalar functions and IBM i services to access the web.

Learning Objectives:

1. What the SQL pre-compiler is and does
2. What scalar functions, UDFs and IBM i services are.
3. Using DB2 scalar functions within your RPG programs
4. Downloading files within RPG using DB2
5. Sending web requests (SOAP, REST) within RPG using DB2
6. Parsing XML within RPG using the DB2 XMLTABLE and XMLPARSE functions. This session 170009.

avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →

Thursday May 9, 2019 3:30pm - 4:45pm EDT
Grand Caribbean 4 - 5, Lobby/Grand Caribbean Level