2024-11-18, 10:00–13:00, Cipress
SQL is used on every platform. Everybody knows SQL. But how can you get the most out of the data centric language behind? The SQL-PL language is extremely powerful and can be accessed from almost any platform and integrated in all IBM i languages: RPG, Node.js, Python. This is why SQL-PL these years are used more and more as the preferred universal language in IT transformation projects.
The first part of this session we will cover the basics from simple functions and procedures and move forward with advanced features like table functions (UDTF) that produces and consumes JSON and using the build in API’s on IBM i – the SQL services.
We continue with stored procedures and UDTF. They are gaining more and more attraction from companies around the world – Why? Because it runs on basically any platform and makes life much easier for modernizing and integration to legacy systems. Everybody knows SQL more or less – it is an Esperanto for any generation and it is quite natural to extend knowledge based on this design pattern.
Agile development, Modernization, IT transformation. Using the full potential of Db2
Niels has developed IBM i middleware used in numerous applications worldwide. He is the architect of the IceBreak application server for IBM i. Over the years he has contributed to the IBM i community with presentations, demos, and loads of open source: ILEastic and noxDB to name a few projects. IT Transformation, modernization and tools around this process is his passion and he moves anything from 5250 into an era of microservices and containers. At the same time, he is also a member of CEAC and is an IBM Champion – 2019, 2020, 2021, 2022, 2023