Articles & Content

Archives

SQL Power to Minimize Programming (G03)

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

OBJECTIVES:

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!

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.