Skip to Main Content
DB2® for z/OS® Version 8 DBA Certification Guide
book

DB2® for z/OS® Version 8 DBA Certification Guide

by Susan Lawson
October 2004
Intermediate to advanced content levelIntermediate to advanced
688 pages
16h 35m
English
IBM Press
Content preview from DB2® for z/OS® Version 8 DBA Certification Guide

Chapter 6. Advanced SQL Coding

• Subqueries

• Unions

• Joins

• Nested and common table expressions

• Case expressions

• Row expressions

• OLAP and star joins

• Predicates and filtering

This chapter covers some the more advanced DB2 SQL features. The discussion begins with the constructs of subqueries, unions, and joins. Then we examine nested and common table expressions, the CASE expression with its if-then-else logic, row expressions, and OLAP features. Efficient query coding also requires a knowledge of how DB2 processes predicates. We look at how predicates are classified and data is filtered during query processing.

Subqueries

A subquery, an SQL statement specifying a search condition, contains either a subselect or a fullselect and is used ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

DB2® Universal Database for OS/390® Version 7.1 Certification Guide

DB2® Universal Database for OS/390® Version 7.1 Certification Guide

Richard Yevich, Susan Lawson
Security Functions of IBM DB2 10 for z/OS

Security Functions of IBM DB2 10 for z/OS

Paolo Bruni, Marcelo Antonelli, Hyun Baek, Rick Butler, Ernie Mancill
Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Paolo Bruni, Carlos Alberto Gomes da Silva Junior, Craig McKellar, Adilet Sabyrbaev, Tim Willging

Publisher Resources

ISBN: 0131491202Purchase book