Common Sweden Conference 2024

Common Sweden Conference 2024

Welcome to Common Sweden Conference

arrow_back View All Dates

10:45 CEST

Introduction to VS Code for IBM i

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

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

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

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

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

12:00 CEST

Debugging with VS Code

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

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

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 →

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

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

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

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

14:00 CEST

BI & AI on the IBM i

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

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

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

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 :)

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

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

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 →

IBM i Modernization pdf

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

Application Development

15:15 CEST

A Modernization Project from a Technical Perspective - Customer Case

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

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

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 →

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

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

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 →

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

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

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 →

What's New in Db2 for i Sept 2024 pdf

What's New in Db2 for i Sept 2024 pdf

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

Application Development

16:30 CEST

Analyzing ILE Objects with SQL respective Db2 and IBM i Services

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

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

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

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 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 Maximizing the benefits of embedding SQL in your RPG code pdf

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

Application Development