Thursday, October 8, 2020 from 4:30 PM to 7:00 PM CDT
Add to Calendar 


This is an online event. 



Lynell Constantine 
Wisconsin Midrange Computer Professional Association 

WMCPA 2020 October Meeting 

Please join our October 2020 meeting featuring IBMi Champion Jim Buck. Meeting is free for members and will be done via webex.

Session 1: Failure to Modernize - The Real Cost

Session 2: Processing JSON with DB2 and RPG


Failure to Modernize - The Real Cost

In 2008; Jim wrote an article for COMMON called the “A Perfect Storm” This article discussed the low enrollment rates for Information Technologies classes in the United States. Fast forward to 2016, Information Technology education in colleges has made a comeback. Now there is a shortage of qualified young IT professionals with enterprise skills.

The shortage of young IBM i Professionals will be a significant challenge to you and your company. Learn what your company needs to do assure access to the next generation of IBM i Professionals. Jim will discuss what will attract young IT professionals to your company and how your company can be assured that there are young people trained in the technologies needed for the future of your company. This shortage will affect careers and bottom lines companies.

Learning Objectives:

  • Understand the current and future IT job market
  • Understand the college environment
  • Understand what young IT professionals are looking for
  • What your company needs to do to attract the next generation of IT professionals

Processing JSON with DB2 and RPG

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