Articles & Content

Archives

(Not So) Stupid SQL Tricks Or "My SPUFI writes JCL—Yours Can Too!" (F05)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-8 (09:20 AM - 10:20 AM)
SPEAKERS: Mark Doyle (Winterthur U.S. Holdings)

DBAs now are expected to manage more information, in more environments, with less down time and fewer resources. Third-party tools have helped, but they can't keep pace with the ever-growing list of new business requirements. This presentation will discuss a set of techniques, constructs and "tricks" -- a.k.a. "Smart SQL" -- that will allow DBAs to build their own tools, and build tools that build tools, based on their own environment and the constraints they face. "Smart" SQL can make DBAs (and others) more productive and better able to handle the challenges put before them.Although "smart" SQL is presented in the context of DB2 on a z/OS mainframe computer with emphasis on DBA tasks, The techniques presented here are usable in ANY relational database management system, on ANY hardware platform, and for ANY set of tasks.Attendees are invited to bring their hardest database administration challenges, to see if these techniques can assist them in overcoming those challenges.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

We will discuss the theory behind "smart" SQL; and why it works the way it does

We will look at the various TSO, ISPF, DB2I & SPUFI defaults that make creating & using "smart" SQL easy

We will look at the various SQL features, functions & constructs that make "smart" SQL possible. Including special registers, string functions (CHAR, DIGITS, RTRIM, SUBSTR & CONCAT), CASE, UNION ALL, "semi-Cartesian" joins, and "driver" tables

We will discuss the anatomy of a "smart" SQL statement, including its five main parts. We will walk through the process of turning a template into "smart" SQL

We will discuss several examples of "smart" SQL statements, paying particular attention to the ways that the SQL can be changed to fit different environments, situations and requirements



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.