POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Tuesday, May 21 • 10:30am - 11:30am
33AK Extending RPG with Db2 for i Functions

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 like the HTTP functions, XML parsing functions and now the JSON generation/parsing functions too.

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.
7. Parsing and generating JSON using Db2 JSON_* functions.

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 →

Tuesday May 21, 2019 10:30am - 11:30am PDT
Fantasy Tower North Ballroom B