Articles & Content

Archives

A VIsual Tour of DB2 9.7 SQL and PL SQL Enhancements (D04)

Topic: 2010 NA

Subtopic: DB2 for LUW



DATE: 2010-5-11 (04:15 PM - 05:15 PM)
SPEAKERS: Bob Harbus (IBM)

DB2 V9.7 introduced a huge number of enhancements to the SQL language, including support for PL SQL. This session will introduce the attendee to the wealth of new features in this release and show how the PL SQL language can be used with DB2 to create triggers, procedures, functions, and anonymous blocks. Even if you don't want to develop PL SQL procedures, this session will highlight some of the other exciting features of DB2 9.7 that can improve performance, ease application development, and eliminate locking.

EXP. LEVEL: Beginner

OBJECTIVES:

Understand the capabilities of the PL SQL language within DB2

Learn when to use the new Currently Committed locking model

Know the difference between the new extended data types in DB2

Understand the use of the statement concentrator and under what circumstances to use it

Learn how to use the various tools to explore the capabilities of DB2.



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.