Loading…
WMCPA iCON2025
or to bookmark your favorites and sync them to your phone or calendar.
Type: Programming clear filter
Wednesday, March 12
 

8:30am PDT

IBM i Services for Developers
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 3
IBM i services provided by Db2 for i can replace CL command interface or system APIs to access and work with a lot of system information.

I will show you how to use SQL to work with data areas, review your program attributes, read and write to the IFS, and much more.
Speakers
SR
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 3
  Programming, IBM i, SQL, IFS

8:30am PDT

Simon's Favorite BiFs
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 2
Simon Hutchinson has written a lot of articles on his blog about the modern RPG programming language. This session covers a mixture of his favorite RPG Built in Functions, BiFs, and ones he thinks everyone should be using. This includes some BiFs from the latest rounds of Technology Refreshes.
Speakers
SH
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 2
  Programming, RPG

8:30am PDT

What's New with Open Source & IBM i
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 1
Join Mike as he explores the latest news regarding packages and solution features available in IBM i Open Source Package Management and beyond.
Speakers
MP
Wednesday March 12, 2025 8:30am - 9:45am PDT
Geneva 1
  Programming, IBM i

8:30am PDT

OAuth: What It Is, How It Works, and Why You Should Use It
Wednesday March 12, 2025 8:30am - 9:45am PDT
Milwaukee
Web security

API Flows and Grant types

PKCE

JWT Access Tokens

Encryption/Signatures

Scopes and OpenID Connect
Speakers
PB
Wednesday March 12, 2025 8:30am - 9:45am PDT
Milwaukee
  Security, API |   Programming, API

8:30am PDT

Introduction to ACS
Wednesday March 12, 2025 8:30am - 9:45am PDT
Courtyard 3
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.
Speakers
GS
Wednesday March 12, 2025 8:30am - 9:45am PDT
Courtyard 3
  System Administration, Tool |   Programming, Tool

8:30am PDT

Getting Started with VS Code Workshop Part 1
Wednesday March 12, 2025 8:30am - 9:45am PDT
Madison
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
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
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
  Workshop, Tool, RPG, DB2, IBM i |   Programming, Tool, RPG, DB2, IBM i

10:15am PDT

30 Python Tips in 60 Seconds on IBM i
Wednesday March 12, 2025 10:15am - 11:30am PDT
Geneva 1
Explore various tips for Python on IBM i, including best practices, IFS features, and performance improvements.
Speakers
MP
Wednesday March 12, 2025 10:15am - 11:30am PDT
Geneva 1
  Programming, Python, IBM i, IFS

10:15am PDT

IBM i Migrate While Active
Wednesday March 12, 2025 10:15am - 11:30am PDT
Geneva 3
IBM i Migrate While Active provides an easy way to securely migrate an IBM i partition. The new instance of the partition can be in the same server, same data center, or a remote location like IBM Power Virtual Sever in IBM Cloud. This session will explore how IBM i Migrate While Active works and highlight its different use cases.
Speakers
AW
Wednesday March 12, 2025 10:15am - 11:30am PDT
Geneva 3
  Programming

10:15am PDT

Visual Explain - IBM's SQL Performance Show-&-Tell
Wednesday March 12, 2025 10:15am - 11:30am PDT
Milwaukee
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
Speakers
VH
Wednesday March 12, 2025 10:15am - 11:30am PDT
Milwaukee
  Programming, SQL, Tool

10:15am PDT

Your IBM i With Power BI
Wednesday March 12, 2025 10:15am - 11:30am PDT
Courtyard 3
This presentation, which I previously delivered in February 2023, delves into integrating IBM i with Power BI to unlock powerful data insights and visualizations.
Speakers
BL
Wednesday March 12, 2025 10:15am - 11:30am PDT
Courtyard 3
  Programming, Tool, IBM i

10:15am PDT

Getting Started with VS Code Workshop Part 2
Wednesday March 12, 2025 10:15am - 11:30am PDT
Madison
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
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
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
  Workshop, Tool, RPG, DB2, IBM i |   Programming, Tool, RPG, DB2, IBM i

2:15pm PDT

What Is OpenAI and Why Should You Care?
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 1
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.
Speakers
MP
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 1
  Interpersonal, AI, Tool |   Programming, AI, Tool

2:15pm PDT

API Examples Using RPG, Node.js, PHP, and Python
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 2
APIs allow IBM i to connect with other systems safely and securely, using the languages you already know. Because IBM i has API options abound, you can use your favorite languages and tools.

This talk shows many ways to send and receive data safely, using IBM i business logic, with code examples using various free tools and languages, including RPG, PHP, Python, and Node.js. You will feel empowered to provide and consume APIs with the many examples given here.

Learning Objectives:
Understand basics of APIs and why they are helpful and secure
Learn several RPG techniques to create and call APIs
Learn several open source language ways to create and call APIs, using PHP, Python, and Node.js
Speakers
AS
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 2
  Programming, API, IBM i, RPG, Node.js, PHP, Python

2:15pm PDT

Getting Started With JSON in SQL
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 3
JSON is a popular format for exchanging structured data. In this session, we will learn how SQL can shred a JSON document so it can be treated like relational data. Then we will see how easy it is to generate JSON by using the functions provided by SQL.
Speakers
SR
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Geneva 3
  Programming, JSON, SQL

2:15pm PDT

Procedure Driven RPG
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Courtyard 3
In this session, I will demonstrate the benefits of procedure driven RPG. Together, we’ll explore real world examples of how this mindset has improved code written by myself and my team with regards to three facets: Readability, maintainability and reusability. All three of these benefits translate into a more efficient development team. What if I told you some of your procedures can even be written by your AI code assistant? I’ll show you some fabulous examples!
Speakers
GS
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Courtyard 3
  Programming, RPG, AI

2:15pm PDT

Web Services: A RESTful Introduction
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Milwaukee
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.
Speakers
PB
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Milwaukee
  Programming, API, JSON, IBM i

2:15pm PDT

SQL Data Marts
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Madison
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.
Speakers
SH
Wednesday March 12, 2025 2:15pm - 3:30pm PDT
Madison
  System Administration, SQL, Tool |   Programming, SQL, Tool

3:45pm PDT

Copilot - Microsoft’s Newest Shiny Tool
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Courtyard 3
An engaging session on Microsoft Copilot, highlighting its features and capabilities. This presentation is also not specifically focused on IBM i.
Speakers
BL
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Courtyard 3
  Programming, AI, Tool

3:45pm PDT

Extend Your Reach to Remote Data With Open Access RPG Edition
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Chicago
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
Speakers
VH
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Chicago
  Programming, RPG, Tool

3:45pm PDT

Stored Procedures For Hybrid Development
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Geneva 1
Accessing business logic from Open Source application and off platform has evolved a great deal over the years.
In this session we’ll look at some of the reasons for centralizing this business logic in the database via Db2 Stored
procedures. We’ll look at RPG and SQL procedures and work through examples of how these are used from
exhibit languages like PHP and Python.
Learning Objectives:
1) Learn how to create and execute stored procedures in SQL and HLL (RPG).
2) See examples of how to use Db2 Stored Procedures in OSS languages.
3) Review tips and best practices when working with Db2 Stored Procedures.
Speakers
MP
Wednesday March 12, 2025 3:45pm - 5:00pm PDT
Geneva 1
  Programming, DB2, RPG, SQL, PHP, Python
 
Thursday, March 13
 

8:30am PDT

No Limits Modern Excel Reports Using RPG – Basic Topics
Thursday March 13, 2025 8:30am - 9:45am PDT
Chicago
Our businesses often want reports delivered in Excel format. While there are several ways to create these spreadsheets using RPG, they all have some drawbacks. Writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge, but we will see that the prospect of success is better than it might seem at first. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets. This is the first of 2 sessions, presenting the basic information needed to accomplish this task. The "advanced topics" session presents some interesting things that can be done using this methodology.
Understand the internal structure of modern Excel (XLSX) files
Identify various reporting scenarios, such as multiple sheets, static informational sheets, etc.
Understand how to design and implement an Excel (XLSX) application
Speakers
VH
Thursday March 13, 2025 8:30am - 9:45am PDT
Chicago
  Programming, RPG, Excel

8:30am PDT

SELF: Simon’s Experiences Learning This Feature
Thursday March 13, 2025 8:30am - 9:45am PDT
Geneva 3
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.
Speakers
SH
Thursday March 13, 2025 8:30am - 9:45am PDT
Geneva 3
  Programming, SQL, IBM i, Tool

8:30am PDT

The Awesomeness of Service Programs (and the Truth About Binder Source)
Thursday March 13, 2025 8:30am - 9:45am PDT
Milwaukee
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
Speakers
PB
Thursday March 13, 2025 8:30am - 9:45am PDT
Milwaukee
  Programming, RPG

8:30am PDT

Modern CL Programming
Thursday March 13, 2025 8:30am - 9:45am PDT
Madison
Session Abstract:
Get a detailed look at the enhancements brought to the CL language from i5/OS V5R3 through IBM i 7.1.
See examples of the new functions like DOFOR, DOWHILE, DOUNTIL and SELECT, and how they allow programming CL in a much more structured format.
Learn about the many new process flow options and variable types in the CL language such as integer, signed integer, and pointer variables and how to use them.
Get tips on how to simplify the compiling of CL programs and command objects.
Find out how to provide direct feedback to IBM on your needs for the CL language -- they want to know if these changes are helping you and what to enhance next.
Learning Objectives:
What IBM has added to the language in the last several releases.
How to leverage some of these enhancements to better access user spaces and APIs
What IBM has added to Command objects in recent releases.
Audience:
IBM i Developers and System Administrators.
Speakers
LB
Thursday March 13, 2025 8:30am - 9:45am PDT
Madison
  Programming, CL |   System Administration, CL

10:15am PDT

Embedding SQL Into Legacy Code
Thursday March 13, 2025 10:15am - 11:30am PDT
Milwaukee
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
Speakers
GS
Thursday March 13, 2025 10:15am - 11:30am PDT
Milwaukee
  Programming, RPG, SQL, IBM i

10:15am PDT

GROK Magic: Turning IT Problems into Possibilities
Thursday March 13, 2025 10:15am - 11:30am PDT
Madison
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
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 →
Thursday March 13, 2025 10:15am - 11:30am PDT
Madison
  Programming, IBM i, API, RPG, SQL, PHP

10:15am PDT

No Limits Modern Excel Reports Using RPG – Advanced Topics
Thursday March 13, 2025 10:15am - 11:30am PDT
Chicago
Our businesses often want reports in Excel format. There are several ways to create these spreadsheets using RPG, but they all have some drawbacks. While writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge at first, we will see that things are not so bad as they might seem. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets. This is the second of 2 sessions that looks at more interesting things that can be done using this methodology.
Understand challenges and opportunities when creating spreadsheets
Understand the use of shared strings and learn how to implement them
Understand grouping and outlining and learn how to implement them
Speakers
VH
Thursday March 13, 2025 10:15am - 11:30am PDT
Chicago
  Programming, RPG, Excel

10:15am PDT

Monitor and Manage IBM i With SQL Services
Thursday March 13, 2025 10:15am - 11:30am PDT
Geneva 1
IBM i Services are provided by Db2 for i and can be used to access and manage the IBM i operating system. This session will include many examples of how to use IBM i Services to modernize administration on IBM i. Invest in understanding this alternative to existing IBM i APIs and commands.
Speakers
SR
Thursday March 13, 2025 10:15am - 11:30am PDT
Geneva 1
  System Administration, IBM i, SQL, DB2 |   Programming, IBM i, SQL, DB2

2:15pm PDT

Inject More Stability Into DB2 for i
Thursday March 13, 2025 2:15pm - 3:30pm PDT
Geneva 2
In this new session, Scott will explore the many ways that “bad actors” can attempt to subvert the security on IBM i. Whether the topic is protecting against SQL Injection, closing doors to acquiring elevated privileges, or attempting to discover unprotected objects, this session will include techniques for evaluation and protection of your IBM i. Attend this session to take a big step towards discovering and eliminating attack vectors within Db2 for i!
Speakers
SF
Thursday March 13, 2025 2:15pm - 3:30pm PDT
Geneva 2
  Security, IBM i, SQL, DB2 |   Programming, IBM i, SQL, DB2

3:45pm PDT

Getting Started With SQL Functions and Procedures
Thursday March 13, 2025 3:45pm - 5:00pm PDT
Geneva 1
SQL includes a full-fledged programming language, SQL PL. Come learn about the programming constructs, including error handling, that this language contains. You will leave with all the knowledge you need to start writing your own SQL functions and procedures.
Speakers
SR
Thursday March 13, 2025 3:45pm - 5:00pm PDT
Geneva 1
  Programming, SQL

3:45pm PDT

Let's Learn Linux!
Thursday March 13, 2025 3:45pm - 5:00pm PDT
Chicago
Linux, AIX, UNIX - we hear about them everywhere these days. But what does it all mean? Linux skills are important to everyone working in the technology field. The days of running everything on just one platform are behind us, so it's important to be familiar with Linux. But you probably don't have a spare Linux server sitting around, just waiting for you tinker with, right? Well, you don't need one! Can you replace Windows with Linux? Even if you can, should you? What are the advantages and disadvantages? How do you get, install, and use Linux? Is it really all free? What can you do with a Linux command line, and is it really as powerful as you've heard? Attend this session to learn the answers to these questions and much more. See step by step instructions for safely installing Linux on your PC while still running Windows or Mac OS! We'll cover a number of powerful commands that can be executed from a Linux environment on your PC, within Windows 10, your X86 servers, or even on your IBM i!
Learning objectives - After participating in this session, attendees should have the skills to:
Identify the best way to get started with a Linux environment
Install and set up Linux on their personal PC in a safe way
Use a Linux desktop for productivity and learning
Apply skills learned to a production server environment
Take full advantage of the power of the Linux command line in multiple environments, even on your IBM i!
Audience:
Anyone new to Linux who would like to quickly get started in a fun, safe, and productive way.
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
Thursday March 13, 2025 3:45pm - 5:00pm PDT
Chicago
  Programming, Linux |   System Administration, Linux
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Tuesday, March 11
Wednesday, March 12
Thursday, March 13
Chicago
Club Room
Courtyard 1
Courtyard 2
Courtyard 3
Geneva 1
Geneva 2
Geneva 3
Halls
Lake Lawn Room
Madison
Main Hall
Milwaukee
Registration Booth
TBD
Upstairs Hall
  • Break
  • General
  • Interpersonal
  • Keynote
  • Meal
  • Programming
  • Security
  • System Administration
  • TBD
  • Workshop
  • Popular