Articles & Content

Archives

Functioning with DB2 (A08)

Topic: DB2 for z/OS

Subtopic: 2009



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

OBJECTIVES:

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.



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.