Common Sweden Conference 2024

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.

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.

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!

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.

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