Abstract:	This presentation highlights the DB2 9 for z/OS enhancements that directly impact DB2 application developers. Every release of DB2 is chock full of new features and functionality and that can make it hard to focus on those things that are most helpful for programmers. So instead of scanning volumes of manuals, attend this presentation which will distill the DB2 9 information down to cover what should be most important to programmer/analysts. If you are a programmer wanting to learn more about DB2 9, or a DBA looking for the programmer’s perspective on DB2 9, this presentation should have something to offer you.
Outline:
Experience Level:	Beginner
Presentation Category:	Implementing new DB2 releases and features
Platform:	DB2 for z/OS
Objective1:	Understand how to use the new SQL statements like INTERSECT, EXCEPT, MERGE, and TRUNCATE
Objective2:	Understand the importance of being able to SELECT FROM an UPDATE, DELETE, or MERGE statement
Objective3:	Learn about the new DB2 data types and functions
Objective4:	Learn about the improvements made to exisitng SQL statements and DB2 development capabilities (e.g. REOPT)
Objective5:	Learn about INSTEAD OF triggers including examples of how and when to use them, and hear about the changes to native SQL procedures
Event Code:	G07
Date:	Wednesday, May 13, 2009
Time:	1:30 PM - 2:30 PM