**Register once to receive access to all three virtual events listed below.**
- Introduction to COMMON India and IBM i — 26 September 2023, 4:00 PM Indian Standard Time
We will discuss the partnership between COMMON North America and Infoview Systems to bring you COMMON India. Dawn May, COMMON President will provide an overview of COMMON and all the benefits this organization offers to the IBM i community. Satya Sekhar Das Manda from Infoview Systems will talk about the organization and the collaboration with COMMON. Then Tim Rowe will speak on "IBM i and its Future." Tim is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system.
- Trends in Modern Application Development — 27 September 2023, 4:00 PM Indian Standard Time
What is application development for IBM i ? Great question! There are many different views on what applications should look like. In this session we will explore what is possible when it comes to creating Modern Hybrid applications for IBM i. What is the strategy that the operating system is marching towards and how to help you in your day to day development. This presentation is delivered by Tim Rowe, the Business Architect responsible for Application Development and Systems Management for the IBM i operating system.
- Tricks with Spool Files Using SQL — 28 September 2023, 4:00 PM Indian Standard Time
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. Simon is a subject matter expert for COMMON North America and is the principal of RPGPGM.COM, the most popular blog about modern IBM i programming on the web.
Learning Objectives:
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF

Satya Sekhar Das Mandal is CTO of Infoview Systems in Hyderabad, India

Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of IBM i education, networking, and community.

Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his time also helping customers understand what is possible on our platform when it comes to modernization.

Simon has been writing his acclaimed IBM i blog, RPGPGM.COM, for almost ten years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. He has been recognized by IBM as an IBM Champion for Power (since 2021), and as an IBM i Community Advocate.