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

Join us in New Orleans, Louisiana for POWERUp 2026, 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: RPG clear filter
Wednesday, April 29
 

3:45pm CDT

Processing JSON with DB2 and RPG
Wednesday April 29, 2026 3:45pm - 4:45pm CDT
Tricks” to make your life easier when you start working with JSON data. After a short discussion of the HTTP functions that have been added to QSYS2 and how they can be used with the JSON_TABLE Function, Jim shows the attendee how to work with the QSYS2.HTTP_GET and JSON_TABLE Functions to consume an API returning a JSON object. If you have tried using these functions many have problems writing the correct SQL/JSON path expressions to extract the data and represent it in a relational table. Jim will help the attendee understand this process with solid examples.

Learning Objectives:

Developers looking for clear examples of SQL/JSON path expressions with DB2. Improve developers’ understanding of SQL/JSON path expressions with DB2 and JSON. Improve developers’ understanding of how to use HTTP functions in QSYS2. Improve developers’ understanding of how to use JSON_TABLE functions.
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies

Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Wednesday April 29, 2026 3:45pm - 4:45pm CDT
Studio 1-2
 

Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
  • Artificial Intelligence (AI)
  • Client Connectivity
  • Conference Events
  • Database
  • Developing Business Skills
  • Frameworks
  • General Programming
  • Hardware
  • High Availability Resilience
  • IBM Event
  • IFS
  • IT Leadership and Management
  • IT Strategy
  • NDA
  • Networking
  • PHP
  • Program Testing
  • Programmer Tools
  • Python
  • RPG
  • Security
  • Systems Management
  • Technologies Integrated with IBM i
  • UI
  • Virtualization