2022 - 30th Annual Northeast User Groups Conference

Presenter: Birgitta Hauser Modernization, Education, Consulting on IBM i

JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose, and can be parsed faster than XML. JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. With Release 7.3 TR 3, scalar and aggregate functions were integrated into SQL for generating JSON objects, arrays, and for combining JSON components into complete documents.

The JSON_TABLE tables function for consuming JSON data was introduced with Release 7.3 TR 1.With the JSON_TABLE table function, JSON documents can be parsed, converted into a relational representation, and data picked specifically. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least, IBM provides SQL http-functions for getting access to web services. In combination with the JSON_TABLE function, the JSON answers returned by web services can be consumed within a SELECT-Statement.

Learning Objectives:

· Get an introduction into JSON basics. Learn how JSON objects and arrays can be generated, concatenated, or nested and composed into JSON documents.

· Discover how JSON documents, located in either the IFS or a column of a table or JSON answers returned by web services, can be parsed with the JSON_TABLE table function, converted into a relational representation, and data specifically selected.

· You’ll also get an overview of the new http-functions and how to use them for getting access to web services.

Audience:
Developers and users who are experienced in SQL Queries and want to create JSON data with SQL. Developers and users who need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services. Everybody who simply wants to enhance his SQL know-how.

--------------------------------------------------------------------------------------------------------------

Presenter: Mike Pavlak Perforce Software

Python is a language that has been perceived as infrastructure or plumbing in the IT department, much like CL. While this is an excellent use for Python, it has emerged as a strategic language for application development, too. In this workshop, we’ll explore the implementation, syntax, and application use cases of Python on IBM i. From a fundamentals perspective, you will get hands-on experience using the command line, shell environment, script creation, storage, and execution. As we progress through the workshop, we will delve into Db2 data access and program calls using XML Service as well as a brief tour of frameworks. Then we’ll wrap things up with how open source applications built in Python can add value to your IT environment.

This session requires little to no previous experience in Python and is specifically tuned for IBM i programmers.
---------------------------------------------------------------------------------------------------------------