In this award-winning session, in addition to showing a lot of the functionality within ACS, I will demonstrate some of the cool ways I customize it to increase my productivity. Whether you are new to ACS or a long-time user, chances are, you’ll come away with some tips and tricks you’ll want to take home and implement.
Getting Started VS Code Workshop This is a great opportunity to get started with VS Code and the IBM i extensions. Many RPG developers have never used VS Code and getting started with the IDE can be frustrating. This lab will introduce the attendees to VS Code and IBM i development environment
Attendees will need a laptop and will be provided with a login to an IBM i system. Allowing them to work through some simple tasks. At the end of the Lab, you will have an understanding of the following topics.
Topics covered will include:
Overview of VS Code Introduction to the VS Code IDE Installing IBM i extensions Connecting to the IBM i system Editing and compiling modules, service programs and creating runnable RPG objects Running and debugging a program Using DB2 in VS code
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Wednesday March 12, 2025 8:30am - 9:45am PDT
Madison
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
This presentation, which I previously delivered in February 2023, delves into integrating IBM i with Power BI to unlock powerful data insights and visualizations.
Getting Started VS Code Workshop This is a great opportunity to get started with VS Code and the IBM i extensions. Many RPG developers have never used VS Code and getting started with the IDE can be frustrating. This lab will introduce the attendees to VS Code and IBM i development environment
Attendees will need a laptop and will be provided with a login to an IBM i system. Allowing them to work through some simple tasks. At the end of the Lab, you will have an understanding of the following topics.
Topics covered will include:
Overview of VS Code Introduction to the VS Code IDE Installing IBM i extensions Connecting to the IBM i system Editing and compiling modules, service programs and creating runnable RPG objects Running and debugging a program Using DB2 in VS code
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Wednesday March 12, 2025 10:15am - 11:30am PDT
Madison
In this session we will discuss the history of Open AI, its maturity, and potential impacts on sectors like education, finance, and Information Technology. A live demo of the Copilot application is included.
This year IBM created data marts that allow us more control over the way we can monitor data from the system audit journal and special authorities. Learn how to create and use these data marts, and how it becomes an easy way to gather and store this information for your LPAR.
With the announcement of IBM Rational Open Access: RPG Edition, the capabilities of native RPG have been expanded significantly. But setting out to write an OAR handler can look daunting at first. This session will look at what Open Access: RPG Edition is, and at how to use it to work with data in remote database systems using familiar file operations. Understand the basics of Open Access: RPG Edition Learn about designing an Open Access application and an Open Access handler See how to it all goes together to work with remote non-i5 data sources
SQL Error Logging Feature, SELF, is one of those Db2 tools that few know about, and even less use. Learn about Simon Hutchinson’s experiences in setting up SELF, “turning” it on, and what he discovered using it.
