Articles & Content


Functioning with DB2 (A08)

Topic: 2009 EU

Subtopic: DB2 for z/OS

DATE: 2009-10-6 (15:45 - 16:45)
SPEAKERS: Christopher J. Crone (IBM Silicon Valley Lab)

Built-In-Functions (BIFs) help customers port applications, improve productivity, performance, and ease of use, and accomplish things that required code previously - either in the form of an application or User Defined Function (UDF).DB2 9 introduced over 40 new BIFs. Find out why were they added and what problems they solve, and how your shop can take advantage of the capabilities they provide.SQL Scalar functions will also be discussed. Although SQL Scalar functions have been around for some time, many customers are not aware of the power of SQL Scalar functions and how they can be used to extend the capabilities of DB2.The goal of this session is to bring you up to speed on the new DB2 9 functions so that you can start thinking about how your shop can exploit this capability. Improve your performance and reduce costs by replacing the application code or UDF that you used previously.

EXP. LEVEL: Beginner,Intermediate,Advanced


Understand the BIFs added to DB2 9.

Obtain a basic understanding of new DB2 9 datatypes and BIFs added to support them.

Understand how BIFs can be used with new DB2 9 functionality like INDEX on expression to solve common problems.

Acquire an understanding of how SQL Scalar functions can be used to extend the capabilities of DB2.

Understand how new DB2 9 Functions can benefit your environment.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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