MAGiC Updates
We are lining up our list of fall sessions. We are going to kick off September with a presentation from Mike Larsen, Creating PDF Documents with Python. Then in October we will have Jim Buck presenting Processing JSON with DB2 and RPG.

We are putting the final touches on our Annual Conference in November. We are excited about our new format and the unique experience it will provide to all that attend! We look forward to seeing you! You can register now and registration fees are not due until Oct 23rd.

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.

If you have any suggestions for future sessions please let me know, we want to continue providing pertinent topics.
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 or events.
Upcoming Meetings
Creating PDF Documents with Python
Presented by: Mike Larsen, Central Park Data
Where: Online
When: Sept 10, 2020 @ 3:30 Eastern
Mike Larsen, Project Manager and Senior developer at Central Park Data Systems will be sharing how to create PDF Documents using Python on IBM i. You can read about this process in his recently published article and other tips and techniques on the IT Jungle website.  

Processing JSON with DB2 and RPG
Presented by: Jim Buck, imPower Technologies
Where: Online
When: Oct 15, 2020 @ 3:30 Eastern
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. 
Annual Conference
When: Nov 9-11, 2020
Where: Virginia Beach, Virginia
We have a unique learning and networking experience planned for our 5th Annual Conference in November. As always the atmosphere will be full of energy and excitement that our conferences are known for! We have expanded space and we are splitting the sessions into smaller groups to help encourage social distancing - plus we feel that the smaller sessions will increase interactions between the attendees and speakers!

We have a great conference planned and we hope to you see you there!

Register today, registration fee isn't due until October 23, 2020! 100% refund if you cannot attend due to COVID-19 or the conference is cancelled.
Other Happenings in the IBM i Community
Summit Hands-On Live! Workshop Series

In-Person, Interactive, In-Depth — Online!
Master critical IBM i development skills at record speed with the Summit's 8-hour Hands-On Live! workshops.
Teaching live via video, instructors Paul Tuohy, Jon Paris, Susan Gantner, Mike Pavlak and Doug Mack take you deep into the best ways to use your favorite technologies, cementing your knowledge with guided, hands-on labs and personal attention.
Choose from 10 different workshops to hone your skills in:
  • SQL, including SQL Procedures, Functions & Triggers
  • RPG Procedures & Service Programs
  • Building Modern RPG Applications
  • Db2 Web Query
  • Python for RPGers
  • RDi
September 14-17, 2020
oin the COMMON community online at Virtual POWERUp 2020. Due to the current climate, we are shifting your favorite conference online to provide you with the best in Power Systems and IBM i education! Check out the list of sessions, speakers, and exhibitors and browse around to see what's new.
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