Exciting New SQL Features in DB2 10 for z/OS

Session Number: 1913
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Guogen Zhang [IBM Silicon Valley Lab]
Time: Nov 17, 2011 (08:30 AM - 09:30 AM)
Room: Leo

Speaker Bio: Dr. Guogen (Gene) Zhang is a Distinguished Engineer in DB2 for z/OS development at IBM Silicon Valley Lab. He is the chief architect and development lead responsible for the delivery of pureXML and SQL query technology in DB2 for z/OS, and has delivered important functionality including pureXML, complex queries and analytics features in DB2 for z/OS. He is a frequent speaker in many conferences, such as IOD and IDUG, and has been deeply involved in providing solutions to customers using pureXML.
Audience experience level: Beginner, Intermediate
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators
Technical areas this presentation will apply to: New Release (DB2 for z/OS), SQL and XML Features, Triggers, Stored Procedures, UDFs
Objective 1: SQL PL extensions for native SQL PL stored procedures, scalar UDFs and table UDFs, and XML support.
Objective 2: Bi-temporal support for historical data, system time, business time, and historical queries.
Objective 3: Fine granularity access control: row permissions and column masks, and differences from multi-level security
Objective 4: Additional OLAP functions, such as moving average, and running total.
Objective 5: Additional features, such as timestamp with more precision, timestamp with timezone, and extended implicit cast.

Abstract:  DB2 10 for z/OS introduced many exciting new SQL features that will make application development, security and regulatory compliance much easier. This presentation will give an overview and examples of these new features and how they can used to improve your development productivity and experiences. There new features include: SQL PL enhancements, bi-temporal for historical data, fine granularity access control, additional OLAP functions, timestamp with timezone, and extended implicit cast.