Articles & Content
Topic: 2007 NA
Subtopic: DB2 for z/OS
DATE: 2007-5-7 (01:40 PM - 02:40 PM)
SPEAKERS: Michael Hannan (CPT Global)
New releases of DB2 have unveiled a sometimes baffling array of new SQL features.How they can be used efficiently and how they can interact with each other is often a source of confusion leading to in-appropriate use by some but minimal use by others who have not been shown the safe usage capabilities.Are these solutions looking for problems, or are they indeed powerful features?
EXP. LEVEL: Beginner
Understand what things can be achieved with the SQL Language DB2 V8 for z/OS
Understand the limitations of SQL for set and procedural oriented processing
Clear up confusion of the capabilities, interaction, and performance of SQL Functions, User Defined Functions, User Defined Data Types, Triggers, Stored procedures, Temporary Tables, Recursive SQL, DB2 Generated Keys, LOBs, XML Functions,and MQTs
Using SQL as a generator of: Data Denormalised for Performance, Control Statements, Commands, Data Fixes, Unload Extracts,Incremental Extracts, XML, and Reports
Answer most of the questions on how to use all these SQL features through informative, but not trivial, examples
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.