For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface.
We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries.
Learning Objectives: A brief description of optimization with SQL The several ways of invoking Visual Explain The various panes of the Visual Explain window Some features of Visual Explain for managing how it behaves Examples of improved performance after using suggested changes
We'll introduce the basics of web services, with a focus on HTTP, JSON, and RESTful principles, and demonstrate how to consume and provide APIs from IBM i.
Learn why service programs are so awesome. We will weigh the pros and cons of different options we have for creating shared routines. We’ll learn how to create a service program and how easy it is to use these shared procedures in our applications. We will discuss the importance of binder source and how using it can make updating our service programs painless. 1. What is a service program 2. How to create a service program 3. How to use a service program
Whether your team admits it or not, we all have legacy code. In this session, we will explore easy ways to modernize these programs and improve performance. We will delve into these 3 specific situations: Converting RPG programs to SQLRPGLE Using SQL when multi-member files are in use Converting PF files to SQL tables
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →
Join Alan Seiden, a renowned expert in the IBM i community, for an open and engaging Q&A session designed to address your most pressing questions about IBM i development, modernization, performance tuning, and integration strategies. Whether you’re a seasoned IBM i professional or just starting your journey, this interactive session is your opportunity to gain insight, best practices, and expert advice directly from one of the industry’s most respected voices.
Alan will cover topics such as RPG, SQL, open-source tools, APIs, and performance optimization, while also diving into modern approaches like DevOps, cloud integration, and security best practices. Bring your questions, challenges, and ideas—Alan is here to help you solve problems, explore new possibilities, and empower your IBM i environment.
Come prepared to ask anything—and leave with solutions and inspiration for your IBM i journey!
