Join us in New Orleans, Louisiana for POWERUp 2026, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!
Sign up or log in to add sessions to your schedule and sync them to your phone or calendar.
With the last releases and technology refreshes IBM provided a bunch of new IBM i and Db2 Services. A lot of these Services provide functionalities that are not directly available in RPG or can only be implemented in RPG by calling complex System APIs and/or by using pointer handling for accessing the data. However, IBM provides new SQL services mostly located in the SYSTOOLS schema that can write data into the IFS, delete old spool files and even transform a spool file into a PDF document. With other services the SQL queries can be executed and the result saved as Excel-Sheets or *.csv files. Even eMails can be easily sent with the aid of an IBM i service. And the best, we can put all together This session will show a sub-set of SQL and IBM Services which can easily be embedded in any programming language that supports SQL and, in this way, can make live much easier.
Learning Objectives:
In this session you’ll learn how specific SQL Services can be implemented with embedded SQL in RPG or Cobol and how the formerly complex source code can be reduced.
