VS Code and IBM i: everything you probably missed

Hybrid meeting @ Papa Passero's with Liam remote
learn in person at Papa Passero's or remote on Zoom

Liam Allan

Tuesday September 26th 2023


6:30pm - Check In Idea Exchange and Networking!
7:00pm - Liam Allan - VS Code and IBM i
afterward - Cool Down Idea Exchange and Networking!


VS Code & IBM i
VS Code and IBM i: everything you probably missed
We’ve seen Visual Studio Code working with IBM i for years at this point, but there’s a load of stuff you might have missed

Details and Registration

Liam Allan Link

OMNI SPONSORS

Fresche
Profound
UCG
Vault400
LaserVault
Midrange Dynamics
imPOWER Technologies

PAST EVENTS

VS Code and IBM i: everything you probably missed

Hybrid meeting @ Papa Passero's with Liam remote
learn in person at Papa Passero's or remote on Zoom

Liam Allan

Tuesday September 26th 2023


VS Code & IBM i
VS Code and IBM i: everything you probably missed
We’ve seen Visual Studio Code working with IBM i for years at this point, but there’s a load of stuff you might have missed

...
WMCPA & OMNI - Golf Outing

**CANCELLED**

WMCPA & OMNI - Golf Outing **CANCELLED**

Wednesday August 23rd 2023

...
Celebrate IBM i at 35!
Ian Jarman & IBM i luminaries
*live* webcast from IBM

Updates on IBM i Announcements
with Mike Pavlak

in person at Papa Passero’s
and live on Zoom wherever you like

Wednesday June 21st 2023

Celebrate IBM i at 35! *live* from IBM

June 21 marks IBM i’s 35th Anniversary. What an amazing achievement this is and one that everyone in the IBM i community should celebrate! User groups, customers, and partners from around the world have helped to shape the direction of the IBM i hardware and software solutions, a group achievement that calls for celebration by everyone!

Join Ian Jarman, CTO of IBM Expert Labs, in one of three webinar events worldwide, as he engages with a panel of IBM i luminaries, influencers, and users to reflect on the achievements of the community and what they anticipate for the future. No matter what your time zone, there’s a webinar scheduled in your region. Other events around the world are also being organized; ask your local IBM or Partner team for details.

Everyone -- customers, partners and IBMers – are invited to raise a glass of champagne or a cup of coffee and join the celebration in one of these kickoff celebratory events, hosted by TechChannel and IBM.

IBM i Updates Presented by our very own Mike Pavlak

Mike Pavlak will present the current set of IBM i Updates.

...
Ask the IBM i Experts Anything!
*live* from COMMON PowerUp 2023 Denver

Mike Pavlak, Mitch Hoffman, Jeff Carey, Floyd Del Muro
will interview your choice of
the many IBM i Experts
on the COMMON PowerUp Expo Hall floor
and ask them your pressing must know questions
(submit questions ahead of time and/or live)

in person webcast at Papa Passero’s
and live on Zoom wherever you like

Tuesday April 25th 2023

Ask the IBM i Experts Anything!
*live* from COMMON PowerUp 2023 Denver


If you can't get to Colorado for COMMON's PowerUp 2023, be sure to enjoy this exciting first-time-ever collaboration between The Omni User in Chicago and IMUG Users Group in Nashville! The Midwest and Middle South team up to bring you a great IBM i Q&A opportunity from the Mountains of Colorado, *live* from COMMON PowerUp 2023’s Expo Hall Floor.

Submit your most important IBM i questions, we’ll relay them to the top IBM i expert minds, you'll hear answers directly, and be able to submit follow-up questions live in chat!

1. Register with Omni or IMUG to get the Zoom link that will allow you to attend
2. Submit any/all of your IBM i questions in advance (starting now!) by sending them to theomniuser@gmail.com and ask more things/enjoy the dialog during the live event in the Zoom meeting chat
3. Tell us who you’d like to answer your questions and our live-on-the-show-floor Omni and IMUG-TN Users Group moderators will find either that person or another expert to give you the great answers.

...
"The Importance of Modernization on Power"
WMCPA Experts Roundtable Panel

with great IBM i panelists...
Tim Rowe, Steve Wolk, Larry Bolhuis,
Justin Loeber, Brian May
moderated by
Mike Pavlak

hybrid webcast at Papa Passero’s
and live on Zoom

Tuesday March 14th 2023

Experts roundtable "The Importance of Modernization on Power" WMCPA Panel Discussion Live on Zoom

The Wisconsin Midrange Computing Professionals Association (WMCPA) User Group will host their annual Technical Conference at the beautiful Lake Lawn Resort in Delavan, Wisconsin this coming Tuesday-Thursday, March 14-16. On Tuesday night, Omni President Mike Pavlak will moderate a Live Panel Discussion “The Importance of Modernization on Power” featuring some of the most knowledgeable IBM i thought leaders in our community (and the world.) With special permission from IBM and WMCPA, The Omni User will bring this special exciting evening live to all Omni members via Zoom at Papa Passero’s or remote at the location of your choosing!

The panelists include IBM Business Architect for Application Development Tim Rowe, PC Richard CTO Steve Wolk, Service Express Data Center and Cloud Engineer Larry Bolhuis, Kisco Systems IBM i Security Expert Justin Loeber, Profound Logic Product Manager Brian May, and Perforce Software Solution Engineer Mike Pavlak as Moderator.

Zoom Link: The Zoom link will be sent via email only to those who register and are paid 2023 members (Individual or Corporate.) Please register by Monday and renew your membership (if it is not current for 2023) on The Omni User Store on Square. Non-members are welcome to join for $50 and pay for their membership on the Square store in order to receive the Zoom link and attend.

...

Using SQL to pull Web Service data
into your IBM i applications

Robert Swanson

Tuesday Februrary 28th 2023

Using SQL to pull Web Service data into your IBM i applications
Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, publicly available Web Service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent global data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics, or whatever else you can think of, there is no shortage of information available on the internet that could complement certain areas of your company's business, thus adding valuable real-time information to your various user applications.

In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world API examples to demonstrate how IBM i developers using Db2 SQL can quickly access these valuable Web Service repositories and pull data into an RPG program or UI tool for their users.

Attendees will see two simple 5250-based interactive examples in action, with source code they can try on their own systems.

Learning Objectives:
1. Basic definition of a REST API, and how it differs from SOAP
2. How to find a public Web Service API and understand its inputs and outputs
3. How to structure and execute an SQL statement to pull data from the Web Service

...
Tim Rowe
- Magic of REST APIs
- IBM i Navigator: An Administrators View
FREE IN PERSON MEETING FOR MEMBERS
Renew/establish membership for this amazing experience

Tim Rowe

Tuesday January 17th 2023

Magic of REST APIs
Rest APIs are a key technology in the world of Modern Applications these days. The IBM i operating system has integrated support for easily creating Rest APIs over existing ILE programs and service programs, as well as being able to wrapper SQL statements. In Addition, you can leverage the integrated support to call Rest APIs from your native RPG / COBOL ILE code. This session will leverage live demos to show both side of the Rest API conversation on IBM i.
IBM i Navigator: An Administrators View
IBM Navigator for i is the web based interface for accessing, managing, and monitoring your IBM i. A brand new versions has been released. This session will look at how to get started, how to best leverage this interface for one users or an entire company. We will look at some of the administrative features added to New Nav to help with rolling this out to many users. This include how to set up TLS for you connections and how to limit select users from working with areas within the interface.

...
Don't lock yourself out! Securing Admin Servers

Zoom meeting

Jeff Carey

Tuesday November 15th 2022

Don't lock yourself out! Securing Admin Servers
Securing web based tools is increasingly important, even on your own network. Is your network team wanting to close all non-secure ports? IBM continues to provide function via the ADMIN servers, but by default they are not secure. Knowing what these servers do and setting them up securely is important, but care must be taken as some of them control your ability to secure them, so it is possible to lock yourself out!
Learning Objectives: What are the Admin servers and why do I need them? How to secure them and why it is important. Avoiding pitfalls.

...
Merlin and VS Code
Powerful Options
for Next Gen Apps
Hybrid meeting
Andrew at Papa Passero's with Liam remote
learn in person at Papa Passero's or remote on Zoom

Andrew Clark
with Liam Allan

Tuesday October 18th 2022

Merlin and VS Code: Powerful Options for Next Gen Apps
What exactly is all of this hype around Merlin, VS Code, and Next Gen Apps? Are you confused about what exactly "Next Gen Apps" really means, how your existing development fits into this new paradigm, and whether you should consider embracing one or more of these new tools? Compare and contrast your development environment(s): SEU, RDi, VS Code, Merlin (and others??) to see what your different options are - then consider each package's inherent strengths and weaknesses as you start to move down the Next Gen path.

...
IBM i Performance Tools for Application Developers
remote on Zoom

Dawn May

Tuesday September 27th 2022

IBM i Performance Tools for Application Developers
Application developers should consider the performance characteristics of new and changed applications as part of the development process. After all, finding a performance problem during the test phase is far better than having an issue occur on production. This presentation will review the primary tools IBM i developers have available to them to understand the performance of their applications.

This session will review Wait Accounting, Job Watcher, and Performance Explorer and how these tools can be used to understand the performance characteristics of your applications.

...
Recent additions to modern RPG language
Look at your data from a different (SQL)view-point

Simon Hutchinson

Tuesday August 16th 2022

Recent additions to modern RPG language
Over the past ten years RPG has transformed itself into a modern free form language. In recent the recent releases, 7.4 and 7.5, there have been additions there have been enhancements made that have passed many people by. Simon will demonstrate these features and explain why he thinks these are worth incorporating into your work.

Look at your data from a different (SQL)view-point
Simon will explain how building SQL Views should become a part of your development strategy. He will give examples of the common ways he builds and uses Views to make his own and that of his team easier and simpler. Why do the hard work yourself when something else can do it for you?

...
IBM i Performance Tools for Application Developers
remote on Zoom

Dawn May

Tuesday June 21st 2022

IBM i Performance Tools for Application Developers
Application developers should consider the performance characteristics of new and changed applications as part of the development process. After all, finding a performance problem during the test phase is far better than having an issue occur on production. This presentation will review the primary tools IBM i developers have available to them to understand the performance of their applications.

This session will review Wait Accounting, Job Watcher, and Performance Explorer and how these tools can be used to understand the performance characteristics of your applications.

...
IBM i Updates in 60 mins (more or less)
remote on Zoom

Mike Pavlak

Tuesday May 17th 2022

IBM i Updates in 60 mins (more or less)
IBM has recently delivered several hours of updates in their spring marketing cycle.
If you’ve missed some or all of them, rest assured we have a solution.
OMNI’s own Mike Pavlak has nothing better to do than watch countless hours of video content from IBM and has distilled the announcements down to about an hour of content. If you have a really busy schedule or just simply don’t want to burn a lot of time watching each message of IBM i goodness then this session is for you!
Mike will be covering everything at his usual breakneck pace. For those who might want to drill down into greater detail Mike will be including a TON of links littered through the presentation for more information.

...
Dr. Alan's IBM i Web Checkup
in person @ Papa Passero’s or remote on Zoom

Alan Seiden

Tuesday April 19th 2022

Dr. Alan's IBM i Web Checkup
IBM i web expert Alan Seiden is here to dispense advice and good IBM i development medicine for Web Applications on IBM i.
Learn from Alan's prescription for fast, future-proof web and API development on IBM i, based on years of experience helping companies worldwide to implement web applications and APIs on IBM i. Alan will explore aspects of web application development that he has encountered including tips on performance, security, language choices and much more.
Alan's unique position of building web applications on IBM i for over 20 years makes him the de facto authority on solutions to the challenges that face the typical IBM i developer as they explore the WWW or "weird world of the web" and work to bring order to what can sometimes appear to be abject chaos.

...
“Business Value of IBM i”
WMCPA Panel Discussion
Live on Zoom

Charlie Guarino, Pete Massiello,
Tim Rowe, Alison Butterill,
and Simon Hutchinson
moderated by Mike Pavlak

Tuesday March 15th 2022

“Business Value of IBM i” WMCPA Panel Discussion Live on Zoom

The Wisconsin Midrange Computing Professionals Association (WMCPA) User Group will host their annual Technical Conference at the beautiful Lake Lawn Resort in Delavan, Wisconsin this coming Tuesday-Thursday, March 15-17. On Tuesday night, Omni President Mike Pavlak will moderate a Live Panel Discussion on “Business Value of the IBM i” featuring some of the most knowledgeable IBM i thought leaders in our community (and the world.) With special permission from IBM and WMCPA, The Omni User will bring this special exciting evening live to all Omni members via Zoom!

The panelists include previous WMCPA speakers and IBM Champions Charlie Guarino & Pete Massiello, IBMers Tim Rowe (Business Architect of Application Development) and Alison Butterill (Offering Manager for IBM i.) New to WMCPA is IBM Champion Simon Hutchinson, who runs the recently formed Central Texas IBM i User Group and hosts the popular RPGPGM.com site.

“Business Value” has been a central focus since the IBM i platform came into existence as the AS/400 and even earlier in the System/3x. All of that is ancient history, as today’s IBM i has so many modern and powerful features that the Business Value provided might sometimes get a little lost amid the speeds and feeds. In this panel, Mike will solicit questions from both the live audience and remote Omni User attendees to sort through the hype, find the reality, and bring us all back to the core Business Value of one of the greatest computing platforms ever conceived.

Zoom Link: The Zoom link will be sent via email only to those who register and are paid 2022 members (Individual or Corporate.) Please register by Monday and renew your membership (if it is not current for 2022) on The Omni User Store on Square. Non-members are welcome to join for $50 and pay for their membership on the Square store in order to receive the Zoom link and attend.

...
Hybrid Meeting!
Remote on Zoom
Or
In Person @ Papa Passero’s



Uh Oh, I think my IBM i has been breached

Steve Pitcher

Tuesday February 15th 2022



Title: Uh Oh, I think my IBM i has been breached

  • Abstract: Steve will take you through real-world examples of IBM i shops being the victims of ransomware attacks. You will learn how to identify, recover and reduce the risk of this happening to you.


  • Expanded Abstract: What is Ransomware and why do you need to know what can be done about it? Oxford Languages defines "Ransomware" as "a type of malicious software designed to block access to a computer system until a sum of money is paid." You need to know about Ransomware because it can impact your company's bottom line and impact the reputation of your IT department. Steve Pitcher will walk attendees through real-world examples of IBM i shops being the victims of ransomware attacks. You will learn how to identify, recover and reduce the risk of Ransomware happening to your shop.

    ...
    Hybrid Meeting!
    Remote on Zoom (GrubHub card mailed)
    Or
    In Person @ Papa Passero’s (Buffet Dinner free)

    First face to face meeting in 2 years

    Complementary for paid 2022 Members!

    Every database feature explained and demonstrated
    *and*
    The Db2 for i SQL Tutor
    On display

    Scott Forstie

    Tuesday January 18th 2022



    Check out Scott Forstie's - GIST @ GitHub

    IBM i Access Client Solutions (ACS) - Every database feature explained and demonstrated

  • ACS contains a bevy of Db2 for i features and functions. Scott had a hand in dreaming up and establishing most of these features.
  • In this live and interactive session, Scott will attempt to cover every single Database feature found within ACS. Start the year right by getting a fire hose sized dose of can-do knowledge and know-how.


  • The Db2 for i SQL Tutor - On display

  • Scott has spent a good portion of his 33 year career at IBM building working SQL for clients, partners, and colleagues.
  • Scott is the author of IBM i Access Client Solutions's well regarded Insert from Examples.
  • In this session, Scott will revisit some of the previously published and shared working SQL, and explain how they work.
  • By the end of the session, you will have sharpened your SQL cue and be ready to easily bank in that eight ball.
  • ...
    Use Native IBM i SQL
    to Retrieve Web Service API Data
    &
    Debug in the Browser:
    Intro to Chrome DevTools

    Robert Swanson

    Tuesday November 16th 2021



    Use Native IBM i SQL to Retrieve Web Service API Data

    Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, publicly available Web Service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent global data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics or whatever else you can think of, there is no shortage of information available on the internet that could complement certain areas of your company's business, thus adding valuable real-time information to your various user applications.

    In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world API examples to demonstrate how developers, using Native IBM i Db2 SQL, can quickly access this valuable web service repositories and pull data into an RPG program or UI tool for their users. Attendees will see two simple 5250-based interactive examples in action, with source code they can try on their own systems.

    Learning Objectives:

  • Basic definition of a REST API, and how it differs from SOAP
  • How to find a public web service API and understand its inputs and outputs
  • How to structure and execute an SQL statement to pull data from the web service


  • Debug in the Browser: Intro to Chrome DevTools

    Included in the popular (and free!) Google Chrome web browser are some of the most useful front-end development and debugging tools you'll ever need. Even IBM i programmers with little or no background in web development can find useful elements in these tools, as they provide a mechanism for understanding what's happening with any element on a web page communicating with their IBM i server. The tools also provide an effective playground for experimenting with HTML, CSS and JavaScript concepts.

    In this short session Rob will introduce Chrome's integrated DevTools, demonstrating how they can be used to interrogate data going between an IBM i back-end and a front-end web application, view source code, analyze visual elements and dig into other common aspects of a typical web page. The focus will be on items that would be most pertinent to RPG developers who may have little or no prior experience in programming involving web pages.

    Learning Objectives:
  • Learn how to access Chrome DevTools from Windows or Mac, and navigate to the most commonly used elements
  • Become familiar with basic concepts behind JSON, JavaScript and the DOM, all of which can be inspected and tweaked in DevTools
  • See how to use DevTools to understand where data in a business app is coming from - essential information for debugging a problem
  • ...
    Introduction to Node.js with Db2
    and live API Demo

    Liam Allan

    Tuesday October 19th 2021

    Introduction to Node.js with Db2 and live API Demo

    Liam will talk about Node.js fundamentals and how ODBC is leveraged to access Db2 content at the application level.
    After a short presentation, Liam will walk us through several aspects of the Node.js environment.
    Then, he'll drive all the key points home while showing us how to build RESTful APIs that adhere to OpenAPI Initiative standards that can truly unlock IBM i business logic and provision Db2 content using Web Services.

    ...
    Service Programs and Unit Testing
    The Perfect Pair

    Marina Schwenk

    Tuesday September 21st 2021

    Service Programs and Unit Testing - The Perfect Pair

    Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start?

    This session is meant for you. We will work through the benefits to modernizing your code and why you want to adopt unit testing. We will work through breaking apart monolithic programs and how to write their respective unit tests. We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.

    ...
    Choosing the Right Open Source Language for IBM i

    Dan Magid

    Tuesday August 24th 2021

    Choosing the Right Open Source Language for IBM i
    Have you been thinking about taking advantage of Open Source on your IBM i?
    Have you been struggling with all of the technology options and wondering which is right for you?
    In this Webinar session we will cover the particular strengths of different Open Source languages on the IBM i.

  • We will look at languages like Node.js/JavaScript, .Net/C#, Python, PHP. (including some of the recent exciting new PHP announcements), and Java.
  • We will discuss how to use these languages to effectively extend the capabilities of your IBM i RPG/COBOL/CL/DB2 applications.
  • ...
    Darn... Cursored Again!
    Using SQL & Cursors in Your Programs

    Jim Buck

    Tuesday June 22nd 2021

    Darn... Cursored Again!
    Using SQL & Cursors in Your Programs
    This session demonstrates the use of SQL in your programs. After a short discussion of the differences between Dynamic and Static SQL in your programs, we demonstrate the important concepts in creating a robust SQL program. Topics include host variables, data structures, error trapping and using tables with SQL. • Internalize the benefits of using SQL in your programs. • Correct use of SQL and Cursors in your RPG Programs. • Understand error handling in SQL subprocedures and service programs.

    ...

    (IBM) i Want to Be Everywhere!

    by Georgia Killen, Evan Wang, Mary Bentley

    Chris Rosen / Erin Jurgens / Dan Waugh

    Thursday June 10th 2021

    Build faster. Securely. Anywhere. About this event IBM Cloud Satellite, our distributed cloud solution, enables teams like yours, to launch consistent cloud services anywhere — across all on-premises, edge computing and public cloud environments from any cloud vendor. Our distributed cloud provides consistent security and services across environments, centralized workload visibility, reduced latency, easier compliance and higher application development velocity. Learn about an overview of IBM Cloud Satellite, Cloud Satellite use-cases, and a discussion of special promotions, along with a live Q&A! (IBM) i Want to Be Everywhere!

    ...

    The Omni User is Chicagoland's largest and oldest association of computer users.

    We specialize in the IBM midrange platform and associated computing devices.

    Omni's dinner meeting is held monthly to share educational and practical experiences.

    IBM i Series

    IBM is a registered trademark of IBM Corporation

    2021 Midwest Road Suite 200 Oak Brook IL 60523

    www.omniuser.org

    Opinions craved! email webmaster © The Omni User Back to top