TUG Buzz! for Tuesday May 17, 2022

📣 Reminder! TUG's next MoM is:

Thursday, May 26th (4:00 PM)

(Note that the May meeting is on a THURSDAY rather than the usual Wednesday.)

"SQL With Birgitta Hauser" 

This is an in-person dinner meeting at:
DOUBLETREE BY HILTON TORONTO AIRPORT WEST
5444 DIXIE RD, MISSISSAUGA, ONTARIO L4W2L2
with live-streaming on Zoom!

We will be following all health department mandated protocols. The continued use of properly fitting masks is not required but recommended.

* Note: An MP4 recording of this meeting will be available to download for TUG members in good standing, by email request to admin@tug.ca.

SPEAKER BIO: 

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application and database modernization. Currently she is an independent consultant and works in Consulting, Application Modernization on IBM i and especially Database Modernization on Db2 for i.

Birgitta also provides individual programming on IBM i to her customers.
Additionally, she also works in education as a trainer for RPG and SQL developers.
Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences in Germany, other European Countries, USA and Canada.
In addition, she is co-author of two IBM Redbooks and also the author of several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru and IBM DeveloperWorks.
In 2015 she received the John Earl Speaker Scholarship Award. In 2018 she received the Al Barsa Memorial Scholarship Award.
And since 2020 she is an IBM Champion.

ABSTRACTS: 

4:00 PM (2-hour) Session:
Generate and Consume JSON with SQL

JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way 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 the latest Releases and Technology Refreshes (TR) a bunch of scalar and aggregate functions for generating JSON objects, arrays and for combining JSON components into complete documents were integrated into SQL on Db2 for i.

With the JSON_TABLE table function JSON data can be parsed, decomposed and also data picked specifically out.

Additional scalar functions allow SQL to directly access JSON data located within the IFS (Integrated File System) but also in source physical file members.
Last but not least IBM provides in SQL http-functions for getting access to RESTful web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.

7:00 PM (1-hour) Session:
Group By, Having, and Multi-Dimensional Grouping

An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value.

The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with a SQL GROUP BY?

Back To Top

Future TUG MoM Calendar:

Back To Top

Browse our
Articles & Downloads archives

Browse our
TUG Buzz! archives

Browse our
eZine archives