WMCPA Spring Conference 2023: Full Schedule

8:30am CDT

Handling JSON with DATA-INTO and DATA-GEN in ILE RPG

Two of the most significant features added to ILE RPG recently are the DATA-INTO and DATA-GEN opcodes. The most common use case is to read and/or create JSON files. Since JSON has become crucial to IBM i businesses, these are must-know features!

Speakers

Scott Klement

Development and Solutions Architect, Midrange Dynamics

Scott Klement is a Development and Solutions Architect at Midrange Dynamics. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i... Read More →

Wednesday March 15, 2023 8:30am - 9:45am CDT
Geneva Hall 3

RPG, JSON

10:15am CDT

Streaming/Replicating Db2i Data into "The Cloud"

Another part of the company is wanting to leverage a cloud based server for some requirement - advanced analytics, pricing applications, AI/ML project, micro-services, etc. They are coming to IBM i I/T folks to ask how they can get critical data that they need from Db2 for i. This session will answer that question for you, including a couple of approaches using open source Apache Kafka.

Learning Objectives:

1. Learn about Apache Kafka as the glue to stream data
2. Understand different approaches and the advantages/disadvantages of those approaches.
3. Enhance your knowledge of the data streaming into cloud services world

Speakers

John Westcott

Analytics Consultant, Db2 for i, IBM

John Westcott is a member of the Db2 for i Database and Analytics team in IBM’s Technology Services (formerly Lab Services). A consultant with over 35 years’ experience on IBM i, his skills include Business Intelligence, Business Analytics, Database Modernization, SQL and RPG... Read More →

Wednesday March 15, 2023 10:15am - 11:30am CDT
Geneva Hall 3

Db2, Cloud

2:15pm CDT

Options for Consuming REST APIs from RPG

REST APIs have become a major part of business programming. We live in a world where virtually everything is connected to the Internet, and REST APIs are how they communicate with each other. In this session, you will learn how to call (or "consume") REST APIs from good ol' RPG. In addition to showing you the basics of how APIs work, this session explains how to use several free tools to consume them. The tools will be compared so that you can determine which one would work best for you.

Speakers

Scott Klement

Development and Solutions Architect, Midrange Dynamics

Wednesday March 15, 2023 2:15pm - 3:30pm CDT
Geneva Hall 3

API, RPG

3:45pm CDT

30 PHP tips on IBM i in 60 Minutes

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

Wednesday March 15, 2023 3:45pm - 5:00pm CDT
Geneva Hall 3

PHP

8:30am CDT

IBM and Db2 Services for the Programmer

With the latest Releases and Technology Refreshes IBM added a lot of powerful IBM and Db2 Services to Db2 for i and SQL, for example for work management, security, database, IFS … But did you expect, there are also a lot of Services that can be used by the programmer to make live easier? For example for sending or retrieving data queue entries or writing a message into the joblog or for converting a spool file into a PDF-document and much more. Additionally, there all kinds of Services that help to analyze and manage ILE Objects, such as modules, service programs (with exported procedures), programs and Binding Directories, but also activation groups.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Thursday March 16, 2023 8:30am - 9:45am CDT
Geneva Hall 3

Db2

10:15am CDT

Python APIs aka Web Services

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Thursday March 16, 2023 10:15am - 11:30am CDT
Geneva Hall 3

API

2:15pm CDT

What is Open AI and Why Should You Care?

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Thursday March 16, 2023 2:15pm - 3:30pm CDT
Geneva Hall 3

3:45pm CDT

Advanced Authentication for IBM i

Best practices recommend using more than one factor to secure logins and other critical processes. Using industry standard algorithms, two factor authentication now comes to IBM i. This session covers four of the latest tools to help secure your IBM i! (COMMON Gold medal session)

Speakers

Robert Andrews

Principal Security Consultant, IBM

Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →

Thursday March 16, 2023 3:45pm - 5:00pm CDT
Geneva Hall 3

Security