Chapter6.Advanced SQL Coding


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.



DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net