COMMON POWERUp 2026

IBM i offers a wide array of SQL services to allow programmers to interact with database and system resources. In today’s modern SQL world, SQL can replace coding to many APIs, all while being more flexible and easier to use. This session will cover a wide variety of powerful SQL services, including how to view and manage data areas and data queues, an example of interacting with IFS files, running CL commands from SQL, and much more.

Learning Objectives:

`- Learn how to manage data queues and data areas with SQL - Learn to read/write from IFS files with SQL - Learn strategies for debugging SQL procedures and functions - Learn how to develop more efficiently with the help of SQL services (SPLIT, SEND_EMAIL, SPOOLED_FILE_DATA, QCMDEXC, RELATED_OBJECTS)