WMCPA iCON2025

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

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

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.

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!