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!

Type: Programming: General clear filter
arrow_back View All Dates
Tuesday, May 20
 

10:45am PDT

Fun with JSON Publishing: Letting SQL Do the Dirty Work
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

3:15pm PDT

Dueling way to prevent, find, resolve error message to your systems
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Presenters: Marina Schwenk, Shelly Petty, Simon Hutchinson

This fast paced presentation, "the duel", Marina Schwenk and Simon Hutchinson will offer methods and alternatives for the following:

How to find error messages
How to find the joblog for the job that has errored. 
Determine the cause of the error.
Demonstrate various approaches to prevent errors.
Create RPG, CL, & SQL code that is "hardened" to handle issues when they happen.

Shelly Petty will adjudicate the duel & award points to each of the presenters, & at the end of the presentation announce the winner.
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Founder & author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON Americas, awarded... Read More →
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -