Chris Crone, Broadcom

Download PDF

SQL Functions enable customers to improve productivity, performance, enable cross platform porting, and encapsulate application logic in the database. Db2 for z/OS supports Built-in Functions that Aggregate data, operate on scalar data, as well as materialize data as a table. Db2 also enables customers to create functions in Host languages (such as COBOL or C/C++) or in SQL PL (The ANSI compatible SQL Procedures Language). Finally, Db2 13 also introduced SQL Data Insights which allows easy, function based AI, to be applied to customer data. This session will cover the basics, as well as dig deeper into how to exploit all the Function(al) capabilities of Db2 to take your SQL queries to new levels.