DB2 for z/OS

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

May 08, 2007 03:00 PM

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


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

pdf file
NA07F05.pdf   355 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.