Common Sweden Conference 2024: Full Schedule

Welcome to Common Sweden Conference

arrow_back View All Dates

08:00 CEST

Conference Welcome Desk Open

Monday September 23, 2024 08:00 - 09:00 CEST

Exhibitor hall

Monday September 23, 2024 08:00 - 09:00 CEST
Exhibitor hall

Other

09:00 CEST

Opening Session - Welcome and Key Note Speakers

Monday September 23, 2024 09:00 - 10:15 CEST

Djurgårdssalen

Speakers

Scott Forstie

Db2 for i Architect, IBM

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →

Liam Allan

Software Advocate, IBM

I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :)

Mats Lidström

CPO, IBM i Cheif Architect, Apper Systems AB

I have been working with IBM i (and it predecessors) since 1987 as a Programmer, Designer, Head of development, CIO and Architect. I have been part of a number of national and international projects throughout the years. Since 2018 I work for Apper and are helping customers to take... Read More →

Monday September 23, 2024 09:00 - 10:15 CEST
Djurgårdssalen

Other

10:15 CEST

Coffee break

Monday September 23, 2024 10:15 - 10:45 CEST

Exhibitor hall

Monday September 23, 2024 10:15 - 10:45 CEST
Exhibitor hall

Break

10:45 CEST

Introduction to VS Code for IBM i

Monday September 23, 2024 10:45 - 11:45 CEST

Seglora

VS Code for IBM i is a powerful IDE that enables developers to build and deploy applications for the IBM i platform quickly and efficiently. It includes a powerful code editor that provides syntax highlighting, code completion, and code refactoring. It also includes integration n with IBM i’s database and security features, making it easier to develop secure applications. Included as well is an integrated debugger. In this session we will highlight some of its major components and discuss how it can be used for everyday development.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

Practical VS Code for IBM i pdf

Monday September 23, 2024 10:45 - 11:45 CEST
Seglora

Application Development

10:45 CEST

Options for Consuming REST APIs from RPG

Monday September 23, 2024 10:45 - 11:45 CEST

Waldemarsudde

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 & Solutions Architect, Midrange Dynamics

Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Options for Consuming REST APIs from RPG4 pdf

Monday September 23, 2024 10:45 - 11:45 CEST
Waldemarsudde

Application Development

10:45 CEST

SQL Views and UDTF (User Defined Table Functions)

Monday September 23, 2024 10:45 - 11:45 CEST

Skansen

SQL has become very powerful. It includes for example recursions, multi-dimensional grouping, OLAP specifications, IFS and Webservice access …. But not everybody will be able to code complex queries … and this is not necessary as long the programmer can easily use them.
With SQL Views complexity can be hidden. Since a SQL View can be used in a SELECT statement like a table even beginners can write reports based on complex SELECT statements.
How ever, sometimes more than one step is needed to retrieve the desired data. In this situation User Defined Functions (UDFs) or User Defined Table Functions come into play.

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 →

Common Sweden 2024 Views and UDTF Birgitta Hauser pdf

Common Sweden 2024 Views and UDTF Birgitta Hauser sql

Monday September 23, 2024 10:45 - 11:45 CEST
Skansen

Application Development

10:45 CEST

The AI Revolution: From Theory to Practice, Shaping Tomorrow's World

Monday September 23, 2024 10:45 - 11:45 CEST

Solliden

The advent of artificial intelligence (AI) marks a pivotal moment in human history, transitioning from theoretical constructs to practical applications that are rapidly transforming diverse facets of society. By analyzing case studies and real-world applications, this session provides insights into how AI is reshaping our world and offers a roadmap for navigating the opportunities and challenges that lie ahead.

Speakers

Thomas Decorte

CD-Invest

Enthusiastic PhD Researcher & Data Scientist with a passion for accounting, programming, finance, machine learning, sports analytics, and data science.

Monday September 23, 2024 10:45 - 11:45 CEST
Solliden

Application Development

10:45 CEST

BRMS - Beyond the Basics

Monday September 23, 2024 10:45 - 11:45 CEST

Saltsjöqvarn

This session will discuss some of the advanced topics in using BRMS for your back up and recovery. Featured topics will be tape and library management, BRMS Networking, control group and list controls, BRMS Policies and how they affect the overall operation of BRMS, and using SQL to manage BRMS. Recovering from a BRMS back up can be extremely easy, but it can also present some opportunities for trouble. This session will discuss some of the landmines in a BRMS recovery and how to avoid them.

Speakers

Sarah Jacob

VP of Customer Experience, Agile Technology Architects

Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →

BRMS Beyond Basics pdf

Monday September 23, 2024 10:45 - 11:45 CEST
Saltsjöqvarn

Systems Management

12:00 CEST

Debugging with VS Code

Monday September 23, 2024 12:00 - 13:00 CEST

Solliden

VS Code for IBM i is a powerful IDE that enables developers to quickly and efficiently build, and deploy applications for the IBM i platform. It includes a powerful code editor that provides syntax highlighting, code completion, and code refactoring. It also includes integration with IBM i’s database and security features, making it easier to develop secure applications. It also includes an integrated debugger. In this session we will highlight some of the major components and discuss how it can be used for everyday development.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Liam Allan

Software Advocate, IBM

I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :)

Debugging with VS Code for IBM i pdf

Monday September 23, 2024 12:00 - 13:00 CEST
Solliden

Application Development

12:00 CEST

Looking at your data from a different View point

Monday September 23, 2024 12:00 - 13:00 CEST

Waldemarsudde

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?
1. Why use Views
2. How to create a View
3. Deformalize your data for easy access
4. Create new derived & calculated data within the View

Speakers

Simon Hutchinson

Author, RPGPGM.COM

Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America, awarded... Read More →

Simon Hutchinson Looking at Your Data From a Different View Point pdf

Monday September 23, 2024 12:00 - 13:00 CEST
Waldemarsudde

Application Development

12:00 CEST

Service Programs and Unit Testing – The perfect pair

Monday September 23, 2024 12:00 - 13:00 CEST

Skansen

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.

Speakers

Marina Schwenk

Innovative Software Solutions inc.

Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Monday September 23, 2024 12:00 - 13:00 CEST
Skansen

Application Development

12:00 CEST

Simplify your life with SQL services

Monday September 23, 2024 12:00 - 13:00 CEST

Seglora

There are so many services in SQL on our platform. They can make your life a bit simpler. I will show a few services and show how they are done within SQL.

Learning Objectives:
will leave with new ideas about how they can try new services when they get home.

Speakers

Sven Jansson

Senior developer, Apper Systems AB

I have worked on the IBM i platform since 1995. My technical roles include developer, analyst, database specialist, application security, and communications. I also worked on IBMz for a few years, and I serve on the COMMON Sweden board. I'm a curious person who always wants to learn... Read More →

sql servicar sql

sendToDataqueueUsingSQL txt

sendToDataqueue txt

updateDataareaUsingSQL txt

DB2 SQL services Apper pptx

Monday September 23, 2024 12:00 - 13:00 CEST
Seglora

Application Development

12:00 CEST

How Healthy is your IBM i?

Monday September 23, 2024 12:00 - 13:00 CEST

Saltsjöqvarn

We all know our favourite system is a tough cookie, it soldiers on day in day out with little support from us but how can you actually tell howhealthy it really is?
In this session, we run you through a series of simple ideas that you can take away and try on your system. They will not only help you quickly gauge the current health of your system but also allow you to track changes in behaviour and help you to detect changes early and plan your future needs with confidence. In most cases we find that following these simple steps will not only improve the performance of your server but extend it's working life and reduce the need for upgrades.

Speakers

Steve Bradshaw

Friendly Techie, Rowton IT

I've worked in the IBM Business Partner world for over thirty years now and despite IBM's best attempts I still love them ;-)In 2008 I set up my practice (Rowton) and now spend my time supporting clients or designing new IT solutions using a combination of Power servers, Intel and... Read More →

1.How Healthy is your IBM i Server v2.1 pdf

Monday September 23, 2024 12:00 - 13:00 CEST
Saltsjöqvarn

Systems Management

13:00 CEST

Lunch

Monday September 23, 2024 13:00 - 14:00 CEST

Exhibitor hall

Monday September 23, 2024 13:00 - 14:00 CEST
Exhibitor hall

Break

14:00 CEST

BI & AI on the IBM i

Monday September 23, 2024 14:00 - 15:00 CEST

Waldemarsudde

How AI and BI will bring the next generation of business analytics.
If you’ve spent any time online in the last few months, you likely saw the buzz around ChatGPT, a new chatbot developed by OpenAI. Suddenly, the capabilities of artificial intelligence and machine learning (AI/ML) are democratized, their insights and guidance no longer exclusively available for data scientists. While the breadth and depth are unclear, it is certain they will have an impact for years to come. AI/ML will play a pivotal role in providing leaders the information, insight, and recommendations as to how best to optimize and modernize their IT environments. We will show how to take BI a step further with AI capabilities that not only bring an accurate, trusted and complete picture of your business, but forecast what’s coming in the future, predict outcomes and explain why they may happen. Alongside, we will highlight AI/data science project structures and concrete examples how these are implemented in businesses.

Speakers

Thomas Decorte

CD-Invest

Enthusiastic PhD Researcher & Data Scientist with a passion for accounting, programming, finance, machine learning, sports analytics, and data science.

Monday September 23, 2024 14:00 - 15:00 CEST
Waldemarsudde

Application Development

14:00 CEST

Db2 for i inside of VS Code

Monday September 23, 2024 14:00 - 15:00 CEST

Skansen

VS Code is really built with developers in mind. IBM has been building a neat Visual Studio Code extensions that makes accessing and working with the database much simpler for developers. Not only can VS Code be used for writing in many different languages, but now it has great tools for working with Db2 for i. You might see exporting data, working with examples, browsing your schemas, or even managing multiple database configurations. There's a lot to see!

Speakers

Scott Forstie

Db2 for i Architect, IBM

Liam Allan

Software Advocate, IBM

I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :)

Db2 for i Inside of VSCode pdf

Monday September 23, 2024 14:00 - 15:00 CEST
Skansen

Application Development

14:00 CEST

IBM i Modernization – The Key to a Brighter Future

Monday September 23, 2024 14:00 - 15:00 CEST

Seglora

This presentation aims to unravel the importance of modernizing IBM i systems and how it paves the way for a more innovative and efficient future in technology. We will explore the latest trends, tools, and strategies essential for modernizing applications, infrastructure, and development practices on the IBM i platform. Learn how embracing modernization can enhance performance, increase competitiveness, and ensure the longevity of your IT investments.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

IBM i Modernization pdf

Monday September 23, 2024 14:00 - 15:00 CEST
Seglora

Application Development

14:00 CEST

PTF Management

Monday September 23, 2024 14:00 - 15:00 CEST

Saltsjöqvarn

Keeping your system up to date and secure requires knowledge of the PTFs. Here will will discuss what the PTFs are, how to get them, and how to apply them. We will also discuss the different types of PTFs and how to develop a PTF strategy for your organization.

Speakers

Sarah Jacob

VP of Customer Experience, Agile Technology Architects

PTF Management pdf

Monday September 23, 2024 14:00 - 15:00 CEST
Saltsjöqvarn

Systems Management

14:00 CEST

Securing the IFS

Monday September 23, 2024 14:00 - 15:00 CEST

Solliden

Securing the IFS remains a mystery to many administrators. Different authorities and the need to use different commands can be confusing! In this session Carol Woodbury will explain how security works in the IFS and provide techniques for securing it. She will also describe enhancements made in IBM i 7.5 that have made securing the IFS even easier as well as techniques for avoiding ransomware and other malware attacks.

Speakers

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →

Securing the IFS COMMON Sweden zip

Monday September 23, 2024 14:00 - 15:00 CEST
Solliden

Systems Management

15:00 CEST

Coffee break

Monday September 23, 2024 15:00 - 15:15 CEST

Exhibitor hall

Monday September 23, 2024 15:00 - 15:15 CEST
Exhibitor hall

Break

15:15 CEST

A Modernization Project from a Technical Perspective - Customer Case

Monday September 23, 2024 15:15 - 16:15 CEST

Seglora

I will in this session go through some important parts of a modernizartion project where the customer, the architecture, the technology and the legacy are the base of how the new solutions are made.

Speakers

Mats Lidström

CPO, IBM i Cheif Architect, Apper Systems AB

CSC2024 A Modernization Project from a Technical Perspective Customer Case pdf

Monday September 23, 2024 15:15 - 16:15 CEST
Seglora

Application Development

15:15 CEST

How Do I Improve Software Quality?

Monday September 23, 2024 15:15 - 16:15 CEST

Saltsjöqvarn

Every programmer wants to do the best job. How do you test your program and ensure that you aren't missing anything? From the simplest bug fix to large complex projects, there are key concepts that you can use to ensure that your program is properly tested. This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman so that you can see things from both a developer and tester's perspective.

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services

Improving Software Quality via Development and Testing pdf

Monday September 23, 2024 15:15 - 16:15 CEST
Saltsjöqvarn

Application Development

15:15 CEST

What's New in Db2 for i

Monday September 23, 2024 15:15 - 16:15 CEST

Solliden

In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.

This session will include something for everyone and anyone who uses the IBM i.

Resources: https://www.ibm.com/support/pages/node/1119129 and http://ibm.biz/Db2foriSQLTutor

Speakers

Scott Forstie

Db2 for i Architect, IBM

What's New in Db2 for i Sept 2024 pdf

Monday September 23, 2024 15:15 - 16:15 CEST
Solliden

Application Development

15:15 CEST

IBM i Services the Future of Systems Management

Monday September 23, 2024 15:15 - 16:15 CEST

Skansen

For too long IBM i Services were the best-kept secret of managing and monitoring IBM i. Relatively few users of our favourite platform know what they are and even fewer use them regularly. This is a crying shame as they are truly remarkable. IBM i Services can tell you in seconds what it takes a skilled system operator minutes or even hours to discover.
This session is designed to give an introduction to IBM i Services, show you how to use them and share some examples of just how useful they can be. The session includes dozens of examples of services that you can start to use on your systems today.

Speakers

Steve Bradshaw

Friendly Techie, Rowton IT

2.IBM i Services the future of systems management pdf

Monday September 23, 2024 15:15 - 16:15 CEST
Skansen

Systems Management

16:30 CEST

Analyzing ILE Objects with SQL respective Db2 and IBM i Services

Monday September 23, 2024 16:30 - 17:30 CEST

Skansen

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 there are also all kinds of Services that help to analyze and manage ILE Objects, such as modules, service programs (with exported procedures), programs and Binding Directories.
This session combines an introduction into the ILE Concepts and shows what services are available for analyzing the ILE Objects (modules, programs, service programs, modules …)

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Common Sweden 2024 IBM Services for ILE Birgitta Hauser sql

Common Sweden 2024 IBM Services for ILE Birgitta Hauser pdf

Monday September 23, 2024 16:30 - 17:30 CEST
Skansen

Application Development

16:30 CEST

Maximizing the benefits of embedding SQL in your RPG code

Monday September 23, 2024 16:30 - 17:30 CEST

Seglora

Many people are now integrating SQL into RPG programs & procedures. Simon will give practical examples of how you can optimize the performance of your statements & simply diagnose the feedback returned from Db2. Will include mentions of how using Views enhances this optimization process.
1. SQL I/O methods to get data from the database faster
2. Better method to capture errors, or what happened with your SQL statements

Speakers

Simon Hutchinson

Author, RPGPGM.COM

Simon Hutchinson Maximizing the benefits of embedding SQL in your RPG code pdf

Monday September 23, 2024 16:30 - 17:30 CEST
Seglora

Application Development

16:30 CEST

My Vision For the Future

Monday September 23, 2024 16:30 - 17:30 CEST

Saltsjöqvarn

The world is changing. You can see it if you look around you... computers understand your voice, cars drive themselves, and so much more! What will things look like in 10 or 20 years? How will the world change? And, most importantly, how can we be ready for it?

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

My Vision For The Future pdf

Monday September 23, 2024 16:30 - 17:30 CEST
Saltsjöqvarn

Other

16:30 CEST

IBM i Security with an SQL Chaser

Monday September 23, 2024 16:30 - 17:30 CEST

Solliden

In this award-winning session, be prepared to hear Scott Forstie and Carol Woodbury shake up the world of IBM i Security, mixing up new SQL concoctions to bedazzle the otherwise boring world of IBM i Security. This menu includes examples of using SQL to find vulnerabilities in your code (aka penetration testing) as well as new (but practical!) ways to use SQL services to discover and fix your security out your current processes that have reached their ‘consume by’ date. A note of caution, however. You may leave a bit shaken (but not stirred).

Speakers