Please share this newsletter with your colleagues and join us on social media. As always if you are interested in an event if you can RSVP. This lets us know that the topic is of interest. We do not share this list with anyone, we use it only to see interest and send a reminder prior to the session.

As always if you have any questions or comments please let us know by sending us an email at admin@magic-ug.org
Not a member? Learn more about the MAGiC Group
Did you receive this from a colleague? Subscribe here.
RSVP to any of our online sessions.
Upcoming Meetings
Session: Tricks with Spoolfiles using SQL
When: Feb 9, 2023
Where: online
Speaker: Simon Hutchinson
Tricks with Spool Files using SQL

In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements.
Past Meetings
Session: Temporal Tables – Looking Back Into Your Data’s Past
When: Sept 15, 2022 @ 3:30 Eastern
Presented by: Simon Hutchinson
We all work in environments where data is changing, often rapidly. At times it would be nice to know what the data looked like an hour, a day, or even a week ago. With conventional files and tables this is hard, that might even involve restoring data from journals. SQL Temporal Tables alleviates all of that work. They allow you to view the data as it was at any time, and allows many people to view the data at different times all at the same time. Learn how to create a Temporal Table, how to view the data as it was at different times, and even use it to recreate accidentally deleted records.
Upcoming User Group Events
Thank You to Our Sponsors
If you have any questions or comments please email us! We strive to make this group as successful as possible for you, and we encourage any feedback you have. Email Us