MAGiC Updates
Thanks to Jim Buck for presenting Processing JSON with DB2 and RPG. It was a great session and Jim shared some great information 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
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
  • Larry Bolhuis and Larry Amond - Managing IBM i Startup and Shut down
  • Charlie Guarino - Code Refactoring
  • Floyd Del Muro - Devops
  • 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
Processing JSON with DB2 and RPG
Presented by: Jim Buck, imPower Technologies

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.
Creating PDF Documents with Python
Presented by: Mike Larsen, Central Park Data

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.  

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