MAGiC Updates
Our next online meeting is Oct 15, 2020 @ 3:30 eastern with Jim Buck presenting Processing JSON with DB2 and RPG. Don't miss this very informative session to improve your skills using SQ/JSON/RPG and API’s.

Registration is open for our Annual Meeting 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. We have expanded space to ensure all social distancing guidelines are followed.

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.
A special thank you to our sponsors! Get to know the sponsors by visiting our Sponsor Page!
Upcoming Meetings
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 Meeting
When: Nov 9-11, 2020
Where: Virginia Beach, Virginia
Small Group - Big Impact
We have a unique learning and networking experience planned for our 5th Annual Meeting 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 ensure social distancing - plus we feel that the smaller sessions will increase interactions between the attendees and speakers!

Some highlights:
  • Open Source Transformation Series - Jose Acosta, Patrick Behr, Mike Pavlak, Alan Seiden
  • Consuming APIs with JSON and RPG 1/2 Day Workshop with Jim Buck
  • Full Day Course Connecting IBM i to all things TCP/IP with Larry Bolhuis
  • Tips and Techniques from Mike Larsen
  • and more!

We have a great event 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. Limited Capacity.
Prior 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.  

Other Happenings in the IBM i Community
October 20th – October 21st

Missing conferences this year? Here’s a chance to bring IBM i education right to you. This virtual experience is going to be as close to the real thing as possible. Sessions will surround topics such as Security, Cloud, High Availability, BRMS, Access Client Solutions, NVMe, POWER9 Hardware, Storage, and more. (And it’s free!)
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