When: Oct 15, 2020 @ 3:30 eastern
Where: On-line
Presented By: Jim Buck, imPower Technologies
IBM has done some great things that allow DB2 to process JSON objects. This session shows you “Tips and 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 SYSTOOLS and how they can be used with the JSON_TABLE Function, Jim shows the attendee how to work with the SYSTOOLS.HTTPGETCLOB 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 needing 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 SYSTOOLS
- Improve developers understanding of how to use JSON_TABLE functions
Audience
IBM i Developers wanting to get started with or improve their programming skills using SQ/JSON/RPG and API’s
Why Should you attend the session?
- Want working examples of using DB2 Tools to process JSON
- You’ve struggled with the available JSON documentation
- Want clear examples of SQL/JSON path expressions with DB2
Topics covered
- Free formatting and validation JSON tools
- Using the JSON_TABLE Function
- Using the SYSTOOLS.HTTPGETCLOB Function
Jim is the president and founder of imPower Technologies where he provides professional IBM i online/onsite training (imPowerTechnologies.com). He is active in the IBM i community working to help companies train their employees in the latest IBM technologies and helps companies develop the next generation of IBM i professionals.
Jim Buck’s career in IT has spanned more than 36 years, primarily in college education, manufacturing, andchealthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Associationcc(www.wmcpa.org) and has served on several teams developing IBM and COMMON certification tests. Jim has co-authored several IBM i books with Bryan Meyers that are used by many companies and in colleges worldwide, "Programming in ILE RPG" 5th Edition being the latest in 2015. Other accomplishments include; recipient of the 2007 IBM System i Innovation – Education Excellence Award, 2014 COMMON Presidents Award and named 2013/2016/2017/2018 IBM Champion - Power Systems.
