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
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
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
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.
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.
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
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
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.
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!