Articles & Content


Taking Advantage of DB2’s Advanced SQL Features - E14

Topic: 2012 NA

Subtopic: DB2 for z/OS

Functionality is an important part of the database engine and is key to fast application development, flexibility, and performance. DB2 offers a number of highly advanced SQL features that enable extreme functionality with minimal coding. In addition, placing data intensive code within the database engine can save shipping large quantities of data across servers, and also allow application functionality to be centralized. This presentation will explain advanced SQL features such as common table expressions, recursion, OLAP functionality, joins and anti-joins, nested table expressions, and user-defined functions. Each feature will be explained in regards to functionality, but also presented in a manner in which an application to real world situations becomes obvious.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.