Loading…
Common Sweden Conference 2024
Attending this event?
Welcome to Common Sweden Conference
Simple
Expanded
Grid
By Venue
arrow_back View All Dates
Tuesday, September 24
 

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
avatar for Liam Allan

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
avatar for Birgitta Hauser

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
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
avatar for Simon Hutchinson

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
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
avatar for Marina Schwenk

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

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
avatar for Scott Forstie

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 →
avatar for Carol Woodbury

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 →
avatar for Steve Bradshaw

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 →
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
AS
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
avatar for Liam Allan

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
avatar for Charlie Guarino

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
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
avatar for Simon Hutchinson

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

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
avatar for Sarah Jacob

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 →
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
avatar for Guy Berlo

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
avatar for Scott Forstie

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
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
avatar for Marina Schwenk

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
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
avatar for Scott Klement

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

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
avatar for Carol Woodbury

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 →
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
avatar for Liam Allan

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
avatar for Marina Schwenk

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
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
avatar for Simon Hutchinson

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

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
avatar for Scott Forstie

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 →
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
avatar for Sarah Jacob

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 →
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
avatar for Charlie Guarino

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
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
avatar for Birgitta Hauser

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

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
avatar for Carol Woodbury

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 →
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
avatar for Steve Bradshaw

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 →
4.CSC 2024 i Chi The Art of System Management pdf
Tuesday September 24, 2024 15:00 - 16:00 CEST
Prins Eugen
  Systems Management

16:15 CEST

Closing session
Tuesday September 24, 2024 16:15 - 17:00 CEST
Djurgårdssalen
Speakers
avatar for Mats Lidström

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 →
Tuesday September 24, 2024 16:15 - 17:00 CEST
Djurgårdssalen
  Other