Loading…
Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

Tuesday May 20, 2025 10:45am - 11:45am PDT
If you've ever been tasked as a developer with creating complex responses for an internal or external web service, you've likely explored multiple avenues for generating JSON from your IBM i programs. From constructing responses manually in your RPG code, to using various publicly available toolkits like YAJL, RPG NextGen, etc., there are a myriad of ways to create JSON strings with all the requisite curlies, commas, colons, quotes and hard brackets.

If you're on IBM i OS 7.2 or higher, there's yet another avenue you can explore in which you let SQL do all the JSON construction work for you. The biggest benefit of this approach becomes most apparent when your JSON response requires arrays, and especially nested subarrays. Coding such responses can be a bit tedious when done on a record-by-record basis in your program, whereas by using some nifty functions you can can let SQL assemble your JSON response automatically.

In this session we'll review the basics of JSON publishing functions such as JSON_Object, JSON_Array, JSON_ObjectAgg and JSON_ArrayAgg. We'll explore some practical use examples for publishing your business data in JSON, letting SQL do all the dirty work.
Speakers
avatar for Rob Swanson

Rob Swanson

Senior Partner, CNX Corporation
Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →
Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 4 1150 Magic Way, Anaheim, CA 92802

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

Share Modal

Share this link via

Or copy link