Common Sweden Conference 2024

Attending this event?

Common Sweden Conference 2024

Welcome to Common Sweden Conference

arrow_back View All Dates

08:00 CEST

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

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

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

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

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

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

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.

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 →

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

Application Development

10:30 CEST

Cancelled - Developing for IBM i with AI tools - Cancelled

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

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

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

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 →

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

(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

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 →

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

Application Development

11:45 CEST

Tame the IFS with SQL Services

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

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

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 →

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

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.

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 →

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

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

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 →

Whats New and Exciting in RPG pdf

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

Application Development

13:45 CEST

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

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

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

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.

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 →

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

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 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 Simon’s Top Ten SQL pdf

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

Application Development

15:00 CEST

Beyond the Buzz: Practical Implementations and Concerns of AI

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

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

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 →

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

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

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