DB2 V9.7 SQL Cookbook (1374K)
Click above to get a free copy of the DB2 V9.7 Cookbook (created 11/Jan/2011).
The book is in PDF file format. The 470 pages contain over 1,000 sample SQL statements.
DB2 V9.5 SQL Cookbook (1373K)
Click above to get a free copy of the DB2 V9.5 Cookbook (created 14/Mar/2009).
The book is in PDF file format. The 472 pages contain over 1,000 sample SQL statements.
DB2 V9.1 SQL Cookbook (1328K)
Click above to get a free copy of the DB2 V9.1 Cookbook (created 20/Feb/2007). I
always recomend that one use the latest edition of my book, regardless of the DB2 version that you are on, becaue the examples
are better. But use this edition if you wish.
DB2 V9.7 Cookbook SQL Examples (642K)
The above link goes to an HTML file that has the complete text of the SQL statements
used in the most recently published Cookbook. Only the first and last few lines have HTML tags. All the rest is in plain text.
DB2 V9.5 Cookbook SQL DDL (37K)
The above link is for an HTML file that has the DDL and INSERT stmts
for the standard DB2 sample tables, which are used throughout the Cookbook. Use this code if you do not have the means to
create these tables using the IBM-supplied script. Only the first and last few
lines have HTML tags. All the rest is in plain text.
Version Table DDL & SQL (51K)
The above link is to an HTML file that has the DDL and sample SQL stmts (in
a TEXT file, with just a few lines of HTML at either end) for a set of sample tables that illustrate how to create an application
that would record all changes, and also let one do "what if" analysis. See the section (in the Cookbook) titled "Retaining
a Record" for a description of this code.
Meta-Data to Real Data Join (28K)
The above link is to an HTML file that has some user-defined functions and
stored-procedures that enable one to join meta-data to real data in a single query. In other words, the query can begin
by getting a list of tables, and then access each table in the list. See the chapter (in the Cookbook) titled "Running SQL
within SQL" for notes about this code.
Java Functions Source Code (31K)
The above link is to an HTML file that has java source code for some user-defined
functions that enable one to join meta-data to real data in a single query. See the chapter (in the Cookbook) titled
"Running SQL Within SQL" for notes about this code.
Java Functions DB2 Code (34K)
The above link is to an HTML file that has the DB2 user-defined function defintions for the prior java code.
DB2 SQL Cookbook Class Notes (432K)
This PDF file (uploaded 29/Nov/2006) has the examples in the above SQL Cookbook rewritten as class overheads, thus enabling
one to use this material to teach DB2 SQL to others. Use the Cookbook itself as student notes.
Internet Explorer sometimes has a problem
displaying these documents. It seems to download the file, but only a blank screen appears. One
possible cause may be that you have your IE security options set to "maximum". Change them to "medium" and you may see the
document. Mozilla seems to work OK.
Those who cannot read PDF files (e.g. due to poor eyesight) can use a
free service provided by Adobe to convert Acrobat documents to either text or HTML.
Simply email the PDF file to either pdf2html@adobe.com (for HTML output) or pdf2txt@adobe.com (for text output). In a minute or two, they will return what you sent converted as per your request. The output is not especially readable, but it can be used by most screen reader software.
All of the information on this web site is used at your own risk. The
contents is a best effort on my part. However, given the nature of some of the subject matter covered, it would be extremely
unwise to trust the contents in its entirety, I certainly don't. If you do something silly based on what I say, life is tough.
DB2 and z/OS are registered trademarks of the IBM Corporation. Windows,
Window/XP, and Word for Windows are registered trademarks of the Microsoft Corporation. Adobe Acrobat is a registered trademark
of the Adobe Corporation.
I don't much care what you do with the stuff on this website. You can
use it pretty well as you please, but secondary distribution for gain is not allowed. You are encourage to print, share, and
give away, as many copies as you wish.
I've put a lot of effort into writing what you are downloading, so a
little bit of feedback would be really appreciated. Is it good? Is it bad? Does it have errors? How do you use it? What additional
stuff should I include? To put it bluntly, no feedback, no more goodies.
Graeme_Birchall@verizon.net
|