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.
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 those complex queries ... and this is not necessary as long as the average programmer or analyst can easily use the queries. With SQL Views complexity can be hidden. Since a SQL View can be used in a SELECT statement like any table even beginners can write reports based on complex SELECT statements. Sometimes information has to be set in the stored SELECT statement. With SQL global variables, values can be set on a job/connection level ... and SQL global variables can be specified within SQL views. 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.
Learning Objectives:
In this session you will learn how to generate SQL Views. A lot of examples will demonstrate how even complex queries can be hidden. You will also learn how to call and write User Defined Table Functions
