MAGiC Updates
Thank you to Mike Larsen for his presentation, Creating PDF Documents with Python. If you missed the session visit our website for the recording. Our next online meeting is Oct 15, 2020 @ 3:30 eastern with Jim Buck presenting Processing JSON with DB2 and RPG.

Registration is open for 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. If you plan on attending please register to hold your place - we are limiting to 40 attendees.

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
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
Limited to 40 Attendees
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!

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 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. Attendees are limited to 40.
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
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.
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