Common Europe Congress 2023

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