Common Sweden Conference 2024: Full Schedule

Welcome to Common Sweden Conference

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

Scott Forstie

Db2 for i Architect, IBM

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

IBM i Security cocktail with an SQL chaser Round 2 Sweden zip

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

Systems Management

17:30 CEST

Mingle

Monday September 23, 2024 17:30 - 19:00 CEST

Hotel Bar

Monday September 23, 2024 17:30 - 19:00 CEST
Hotel Bar

19:00 CEST

Dinner

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

Hotel Restaurant

We end the day with a lovely dinner.

Monday September 23, 2024 19:00 - 23:00 CEST
Hotel Restaurant

Other

07:00 CEST

Conference Welcome Desk Open

Tuesday September 24, 2024 07:00 - 08:00 CEST

Exhibitor hall

Tuesday September 24, 2024 07:00 - 08:00 CEST
Exhibitor hall

Other

08:00 CEST

Cancelled - End-to-end development: Modern IBM i development stack - Cancelled

Tuesday September 24, 2024 08:00 - 09:00 CEST

Solliden

In this talk, we’ll look at everything from development tools, build systems, to deployment methods. Finally there is a complete open source stack from IBM to use git and easily deploy ILE code (RPG, COBOL, you name it!) and this will cover them. We will look at the end-to-end lifecycle for IBM i applications when stored in git - all the way from the developers, to the end users machine automatically.

Speakers

Liam Allan

Software Advocate, IBM

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

Tuesday September 24, 2024 08:00 - 09:00 CEST
Solliden

Application Development

08:00 CEST

Generating JSON Documents with SQL (SQL and JSON – Part 1)

Tuesday September 24, 2024 08:00 - 09:00 CEST

Skansen

JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. SQL on Db2 for i includes all kinds of scalar and aggregate functions for generating JSON objects, arrays, literals and for combining JSON components into complete documents. Since Release 7.5 TR 1 it is even possible to update/modify JSON documents. The focus of this session is to generate JSON documents.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Common Sweden 2024 Generating JSON pdf

Common Sweden 2024 Generating JSON sql

Tuesday September 24, 2024 08:00 - 09:00 CEST
Skansen

Application Development

08:00 CEST

RPG array magic

Tuesday September 24, 2024 08:00 - 09:00 CEST

Seglora

(Currently short 20 - 30 mins)
Learn how the recent enhancements to RPG have added many new features & enhancements to the way you can use arrays. This will include all the new Built in Functions, Data Structure arrays, & dynamic arrays.
1. Modern ways to code arrays to include the latest features, & what stops you from using them.
2. How Data Structure arrays simplify you getting information from the database.
3. The new Built in Functions for arrays that replace a lot of the complicated coding we use to do.

Speakers

Simon Hutchinson

Author, RPGPGM.COM

Simon Hutchinson RPG array magic pdf

Simon Hutchinson Simple Ways to Convert Your DDS Files into DDL Statements pdf

Tuesday September 24, 2024 08:00 - 09:00 CEST
Seglora

Application Development

08:00 CEST

SQLRPGLE the better file Access

Tuesday September 24, 2024 08:00 - 09:00 CEST

Solliden

Abstract:

We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process by using embedded sql. We will look at how to handle sql exceptions and go through why you should convert to using embedded sql instead of record level access.

Learning Objectives:

Overview of embedding sql in your RPG programs. How to streamline sql procedures with the use of a SQL utility service program. how to modernize your current record level access to use embedded sql.

Speakers

Marina Schwenk

Innovative Software Solutions inc.

Tuesday September 24, 2024 08:00 - 09:00 CEST
Solliden

Application Development

08:00 CEST

Hidden Gems

Tuesday September 24, 2024 08:00 - 09:00 CEST

Prins Eugen

The IBM i team has been delivering new functions two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed. The IBM i team has reviewed the past releases/refreshes and have assembled some of their favorite hidden gems; things that you might have missed but should know. Everyone will leave with something new that will help them in their day to day work.

Learning Objectives:
1. Learn about some of the very useful but lesser known functions of IBM i.
2. Have fun with Stevee, Scott & Carol

Speakers

Scott Forstie

Db2 for i Architect, IBM

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

Steve Bradshaw

Friendly Techie, Rowton IT

Hidden Gems Data3 Sept 2024 Final pdf

Tuesday September 24, 2024 08:00 - 09:00 CEST
Prins Eugen

Other

09:15 CEST

Få bättre sömn (get better sleep)

Tuesday September 24, 2024 09:15 - 10:15 CEST

Djurgårdssalen

Speakers

Arman Shah

Tuesday September 24, 2024 09:15 - 10:15 CEST
Djurgårdssalen

Other

10:15 CEST

Coffee break

Tuesday September 24, 2024 10:15 - 10:30 CEST

Exhibitor hall

Tuesday September 24, 2024 10:15 - 10:30 CEST
Exhibitor hall

Break

10:30 CEST

Cancelled - Developing for IBM i with AI tools - Cancelled

Tuesday September 24, 2024 10:30 - 11:30 CEST

Skansen

There is so much buzz in the community about AI developer tools and I think it's finally time we show off all the options the community has. We'll look at if WatsonX is in the game, what GitHub Copilot can and cannot do, alternative tools, and of course self-hosted models with Continue. Plus, a sneak peak at the AI integration for the Db2 for IBM i database extension.

Speakers

Liam Allan

Software Advocate, IBM

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

Tuesday September 24, 2024 10:30 - 11:30 CEST
Skansen

Application Development

10:30 CEST

Experience the Wonders of AI: Come Marvel with Me!

Tuesday September 24, 2024 10:30 - 11:30 CEST

Seglora

This session explores the fascinating world of AI, demonstrates its possibilities and how it can be used to improve our lives. We will discuss some of the latest available technologies and work with them in real time. This session is perfect for anyone looking to learn more about AI and the potential it has to offer

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Come Marvel With Me pdf

Tuesday September 24, 2024 10:30 - 11:30 CEST
Seglora

Application Development

10:30 CEST

Simple ways to convert your DDS files into DDL statements

Tuesday September 24, 2024 10:30 - 11:30 CEST

Skansen

(Short session 20 - 30 mins)
Modernization is more than putting a GUI front-end on your applications. Database modernization should also be included, converting from DDS files to DDL tables, index, & views. All of the tools needed to do this is included with your IBM i & Db2 for I at no additional charge. Why use a third party tool when you can do it for free? Will also include how you can de-create various SQL objects into statements.
1. Learn what tools are available to convert DDS to DDL
2. See example of how to use them
3. Learn how to recover the SQL statement used to create various SQL objects

Speakers

Simon Hutchinson

Author, RPGPGM.COM

Tuesday September 24, 2024 10:30 - 11:30 CEST
Skansen

Application Development

10:30 CEST

Beyond PTFs - Updating HMC, FSP, SAN and more

Tuesday September 24, 2024 10:30 - 11:30 CEST

Solliden

Applying PTFs is only one part keeping your system up to date. In this session we will learn to apply updates to your hardware - the FSP, the HMC, and the SAN. We will go over the access to the FSP through ASMI as well.

Speakers

Sarah Jacob

VP of Customer Experience, Agile Technology Architects

Beyond PTFs pdf

Tuesday September 24, 2024 10:30 - 11:30 CEST
Solliden

Systems Management

10:30 CEST

StorSafe VTL Software Powers, Data protection Optimisation and Cloud Migration for IBM i, AIX, and Linux workloads

Tuesday September 24, 2024 10:30 - 11:30 CEST

Prins Eugen

Speakers

Guy Berlo

Managing Director EMEA, FalconStor Software

Guy Berlo is the Managing Director for the EMEA Region. Prior to joining Falconstor, Mr.Berlo was the VP Sales & Operations for EMEA at ProphetStor Data Services active in the AImarket space. Previously, Mr. Berlo was the Vice President and General Manager EMEAafter starting up CEMEA... Read More →

Tuesday September 24, 2024 10:30 - 11:30 CEST
Prins Eugen

Systems Management

11:45 CEST

Tame the IFS with SQL Services

Tuesday September 24, 2024 11:45 - 12:45 CEST

Prins Eugen

In this session, you will discover how SQL and IBM i (SQL) Services can be used to bring order to the IFS. Whether you aim to further secure, manage, or utilize the IFS, SQL can help get the job done. The Db2 for i team has made consistent and noteworthy investments to bring SQL capabilities that can be used with the IFS. Come to this session to see, understand, and be ready to use SQL with the IFS.

Speakers

Scott Forstie

Db2 for i Architect, IBM

Tame the IFS pdf

Tuesday September 24, 2024 11:45 - 12:45 CEST
Prins Eugen

Application Development

11:45 CEST

Troubleshooting tips and tricks

Tuesday September 24, 2024 11:45 - 12:45 CEST

Skansen

Have you ever tried to figure out a problem and you don’t know where to begin? Have you ever received a level 1 or level 2 help desk call and want to scream? How many times have you looked at your code and wanted to figure out how to troubleshoot the problem? This session is for you. We are going to give you some tips and tricks to help you overcome most common developer and user issues.

Speakers

Marina Schwenk

Innovative Software Solutions inc.

Tuesday September 24, 2024 11:45 - 12:45 CEST
Skansen

Application Development

11:45 CEST

What's New and Exciting in RPG

Tuesday September 24, 2024 11:45 - 12:45 CEST

Seglora

With each new release of the IBM i operating system and with Technology Refreshes, IBM has given us some new features in RPG. This session tells you about the new and exciting features of RPG and how you might like to use each feature in your own applications.

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

Whats New and Exciting in RPG pdf

Tuesday September 24, 2024 11:45 - 12:45 CEST
Seglora

Application Development

11:45 CEST

Take the Guesswork out of IBM i Security with Authority Collection

Tuesday September 24, 2024 11:45 - 12:45 CEST

Solliden

Want to remove *ALLOBJ from a service account but afraid you'll break something? Can't determine where a user's authority to access a production file is coming from? Don't know how much authority is required to access files in the IFS? All of these questions can be answered using Authority Collection - a powerful feature added in V7R3 and enhanced in V7R4. During this session, Carol Woodbury will demo Authority Collection and provide you with practical ways you can use it in your organization.

Speakers

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

Take the Guesswork out of IBM i Security with Authority Collection zip

Tuesday September 24, 2024 11:45 - 12:45 CEST
Solliden

Systems Management

12:45 CEST

Lunch

Tuesday September 24, 2024 12:45 - 13:45 CEST

Exhibitor hall

Tuesday September 24, 2024 12:45 - 13:45 CEST
Exhibitor hall

Break

13:45 CEST

Cancelled - Moving into git (for RPGLE, COBOL, and more) - Cancelled

Tuesday September 24, 2024 13:45 - 14:45 CEST

Solliden

The future of writing ILE languages is with git. Whether you've not heard of git, or you're an expert, we'll cover the basic concepts of git, how to get your ILE source code into git, how to develop and compile code from repositories, and many other concepts.

Speakers

Liam Allan

Software Advocate, IBM

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

Tuesday September 24, 2024 13:45 - 14:45 CEST
Solliden

Application Development

13:45 CEST

Programming Standards and Guidelines

Tuesday September 24, 2024 13:45 - 14:45 CEST

Skansen

We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited.

1. We will look over various different recommended programming standards and guidelines.
2. we will look at bad code vs new code and make recommendations that you can take back and implement in your shop.
3. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop.

Speakers

Marina Schwenk

Innovative Software Solutions inc.

Tuesday September 24, 2024 13:45 - 14:45 CEST
Skansen

Application Development

13:45 CEST

Simon's top 10 SQL favorites

Tuesday September 24, 2024 13:45 - 14:45 CEST

Seglora

IBM Champion Simon Hutchinson has written a lot about modern Db2 for i and SQL on his blog for the past nine years. In this session he will take you through his top 10 favorites. You will have to attend to learn what these cool SQL tricks and tips are!
(Constantly revised for each release & TR. Different from what I showed last year)

Speakers

Simon Hutchinson

Author, RPGPGM.COM

Simon Hutchinson Simon’s Top Ten SQL pdf

Tuesday September 24, 2024 13:45 - 14:45 CEST
Seglora

Application Development

13:45 CEST

Inject more security into Db2 for i

Tuesday September 24, 2024 13:45 - 14:45 CEST

Solliden

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!

Speakers

Scott Forstie

Db2 for i Architect, IBM

Inject more security into Db2 for i Sept 2024 pdf

Tuesday September 24, 2024 13:45 - 14:45 CEST
Solliden

Systems Management

13:45 CEST

Work Management Optimization

Tuesday September 24, 2024 13:45 - 14:45 CEST

Prins Eugen

This session will introduce IBM i Work Management to the developer and other new system administrators. We will explore how the system is configured and managed using IBM i Navigator for i, with examples from ACS, SQL Services, and the traditional character based interface as well. As delivered your IBM i installation work, but it is not optimized for your environment. All too often the performance of your system is impacted by poor work management practices. Learn how to take the first steps to optimizing your IBM i Work Management.

Speakers

Sarah Jacob

VP of Customer Experience, Agile Technology Architects

Work Management pdf

Tuesday September 24, 2024 13:45 - 14:45 CEST
Prins Eugen

Systems Management

14:45 CEST

Coffee break

Tuesday September 24, 2024 14:45 - 15:00 CEST

Exhibitor hall

Tuesday September 24, 2024 14:45 - 15:00 CEST
Exhibitor hall

Break

15:00 CEST

Beyond the Buzz: Practical Implementations and Concerns of AI

Tuesday September 24, 2024 15:00 - 16:00 CEST

Seglora

A discussion about the rapidly evolving landscape of artificial intelligence, where we'll explore the latest advancements,

ethical challenges, and how AI is used in various industries.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Tuesday September 24, 2024 15:00 - 16:00 CEST
Seglora

Application Development

15:00 CEST

Consuming JSON Documents and Web Services with SQL (SQL and JSON – Part 2)

Tuesday September 24, 2024 15:00 - 16:00 CEST

Skansen

JSON becomes more and more important especially in RESTful web services the, use of XML declines in favor of JSON.
With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out.
Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON responses returned by web services can be consumed

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant

Common Sweden 2024 Consuming JSON Birgitta Hauser pdf

Common Sweden 2024 Consuming JSON Birgitta Hauser sql

Tuesday September 24, 2024 15:00 - 16:00 CEST
Skansen

Application Development

15:00 CEST

Getting the Most out of your IBM i Audit Journal

Tuesday September 24, 2024 15:00 - 16:00 CEST

Solliden

The audit journal contains so much information but has not been easy to access … until now. During this session Carol Woodbury will discuss the modern ways to access the IBM i audit journal, as well as the most recent audit enhancements. She will also discuss how the information can be used as an early warning signal of an attack on your organization.

Speakers

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

Getting the Most Out of Your Audit Journal COMMON Sweden 2024 zip

Tuesday September 24, 2024 15:00 - 16:00 CEST
Solliden

Systems Management

15:00 CEST

i Chi - The Art of System Management

Tuesday September 24, 2024 15:00 - 16:00 CEST

Prins Eugen

What is i-Chi?

It is about thinking differently about IBM i System Management, Embracing new ideas , Automating processes and monitoring, Using IBM i functions in ACS, Nav4i, ARE, IBM i Services, Integrating IBM i SysAdmin with other platforms and Reducing your reliance on the 5250 command line. In this session we give practical examples of how to do this that you can start to use today on your systems using tools that are free to use, already installed on your systems and all without the use of the 5250 green screen.

Speakers