Articles & Content
Topic: 2010 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2010-5-11 (01:45 PM - 02:45 PM)
SPEAKERS: Fred Sobotka (FRS Consulting, Inc.)
Adding just a few tricks to your SQL repertoire can save a tremendous amount of time in administering and maintaining your DB2 databases. Advanced SQL techniques aren't just for developers; by combining these patterns with a solid understanding of the system catalog, DBAs can generate sophisticated sets of XML, SQL, DDL, and even programming/scripting code for other languages. Although vendor tools can generate certain types of useful data and code, DBAs also receive many "one-off" requests that may appear to require a lot of hand typing, but are actually well-suited for SQL automation. This session will introduce DBAs to powerful SQL techniques that generate data and code with minimal effort, leading to time saved and fewer errors. The examples provided come from the real-world experiences of a battle-hardened DBA.
EXP. LEVEL: Beginner,Intermediate
How to spot the SQL shortcut for a seemingly tedious task
Common table expressions, the foundation for versatile SQL that is structured and easily tested and debugged
Replacing unreliable application-based XML generators with ANSI-standard SQL-XML
Identifying the most useful parts of the system catalog
SQL functions and patterns that provide the most bang for the buck
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.