DB2 UDB V8.1 Cookbook ©
Preface 3
Preface
Important!
If you didn’t get this document directly from my website, you may have got an older edition.
The book gets changed all the time, so if you want the latest, go to the source. Also, the latest
edition is usually the best book to have, even if you are using an older version of DB2, as the
examples are often much better.
This Cookbook is for DB2 UDB for Windows, UNIX, LINX, OS/2, etc. It is not suitable for
DB2 for z/OS or DB2 for AS/400. The SQL in these two products is quite different.
Disclaimer & Copyright
DISCLAIMER: This document is a best effort on my part. However, I screw up all the time,
so it would be extremely unwise to trust the contents in its entirety. I certainly don’t. And if
you do something silly based on what I say, life is tough.
COPYRIGHT: You can make as many copies of this book as you wish. And I encourage you
to give it to others. But you cannot sell it, nor charge for it (other than to recover reproduction
costs), nor claim the material as your own, nor replace my name with another. Secondary dis-
tribution for gain is not allowed. You are also encouraged to use the related class notes for
teaching. In this case, you can charge for your time and materials (and your expertise). But
you cannot charge any licensing fee, nor claim an exclusive right of use.
TRADEMARKS: Lots of words in this document, like "DB2", are registered trademarks of
the IBM Corporation. And lots of other words, like "Windows", are registered trademarks of
the Microsoft Corporation. Acrobat is a registered trademark of the Adobe Corporation.
Tools Used
This book was written on a Dell PC that came with oodles or RAM. All testing was done on
DB2 V8.1.4. Word for Windows was used to write the document. Adobe Acrobat was used to
make the PDF file. As always, the book would have been written in half the time if Word for
Windows wasn’t such a bunch of bug-ridden junk.
Book Binding
This book looks best when printed on a doubled sided laser printer and then suitably bound.
To this end, I did some experiments a few years ago to figure out how to bind books cheaply
using commonly available materials. I came up with what I consider to be a very satisfactory
solution that is fully documented on page 365.
Author / Book
Author: Graeme Birchall ©
Address: 1 River Court, Apt 1706
Jersey City NJ 07310-2007
Ph/Fax: (201)-963-0071
Email: Graeme_Birchall@compuserve.com
Web: http://ourworld.compuserve.com/homepages/Graeme_Birchall
Title: DB2 UDB V8.1 SQL Cookbook ©
Date: 23-Jul-2004
