SQL Functions have long enabled customers to improve productivity and performance while also enabling cross platform porting and encapsulating 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). In the latest version of Db2, SQL Data Insights was introduced to allow easy, function based AI, to be applied directly to customer data. This session will cover the basics and dig deeper into how customers exploit all the Function(al) capabilities of Db2 to take SQL queries to new levels. (IDUG)
Chris Crone, Distinguished Engineer, Broadcom