NEUGC - 2022

DEEP DIVE: Generating and Consuming JSON Documents with SQL (Workshop)
Level: Advanced
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.

We all fall into ruts. We continue to do things the same way we have always done them, why? Because it's comfortable. We tell our selfs, that learning something new will 'slow us down'. This session is aimed at breaking down the excuses and helping you see that there is a better way. We will spend most of the time doing live demos on how ACS can help change, and improve you life with the IBM i.

The IBM Navigator has been around for a very long time.... and the version that most think about, well lets say its not the best. Good news, there is a brand new version of IBM Navigator for i, built on the latest Web technologies, and levering IBM i Services and SQL as the backbone for exchanging data. This session will introduce this new interface and spend the majority of the time, showing how this interface.  We will explore areas of interest by the users.

The world of Application Development is continually changing. New technologies, tools, and methodologies are always being talked about. The good news is the IBM i continues to be reshaped and updated to help you take advantage of many of these. This session will review what is possible and ideas on how to best move from what you have been doing to what you could be doing.

When it comes to managing and monitoring the IBM i, there are a number of tools and options....and it keeps on changing and expanding. This session will a brief look at some of the more popular options (like Nagios, Anisble, Instana, IBM Navigator, ACS) and how IBM i fits into these tools. Of course, Demos are a must where ever possible.

There has been a significant strategic  shift in how IBM i exposes data and how you can access and leverage that data.  No longer are CL command and APIs the best way. Today, its all about SQL.  You may go, great… I know nothing about SQL… no worries, neither do I!  This sessions is about equipping you with some useful activities, and resources so that even if you are a novice, you can be successful with SQL Services to manage your IBM i today.

Rest APIs are a key part of todays applications. The integrated Rest api engine within IBM i provides a simple way to create and host Rest APIs for ILE applications as well as direct SQL calls. This session will do live demo on how to create Rest APIs for multiple backend connections.

In this session, we’ll discuss how you can build innovative, multiplatform applications around a strong and secure foundation, your IBM i, and deliver value to your business stakeholders.
›› Integrate with leading CI/CD solutions
›› Deliver DevOps across your organization
›› Deploy database file changes in seconds
Learn about advanced tools that support concurrent development, sophisticated deployment, automated rollback, and API creation.

NVMe is the latest “disk” technology, and you will be amazed at the performance. Configuring them is entirely different. In this session, we will cover the different types of NVMe adapters, how to configure the name spaces, protection, and recommendations on sizes for each name space.