Product Description

This book makes it easy for you to master the essentials of DB2 programming. Written from the programmer's point of view, it focuses right from the start on what you need to know to access and process DB2 data in your application programs using embedded SQL

You'll learn: the basics of how DB2 works so you can program more easily and logically...how to design and code DB2 programs...how to use inner joins, outer joins, and unions to combine data from two or more tables...how to use column functions to extract summary data from a table...how to work with variable-length data and nulls...how to use error handling techniques and ROLLBACK to protect DB2 data...how to use locking and concurrency features so you don't tie up the whole system...how to develop DB2 programs interactively (using DB2I, a TSO facility) or in batch...how to create test data using SPUFI and QMF...and more!

Product Details

• Amazon Sales Rank: #449096 in Books
• Published on: 1998-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 448 pages

About the Author
Curtis Garvin and Steve Eckols

Customer Reviews

All You Need To Learn DB2
This is an excellent resource for all those baffled programmers who need to learn DB2 fast. Thos book provides clear-cut examples, syntax, and the results of the various SQL commands that are most likely to be needed by any programmer. All the basics from simple SELECT statements are covered all the way up to ORDER BY clauses, joins and so on. A special chapter on using SPUFI was also a big help. The emphasis here is on the COBOL language and mainframe computers, but it is an excellent learning tool for anyone. The book teaches by example and can be finished easily within a week (The example programs are what make it look so big). A must-read for anyone interested in relationall databases.

If you want to learn DB2/SQL this is a MUST HAVE
Buy this book!!! ... I wanted
to refresh my basic DB2/COBOL skills, so I ordered a copy of this book.
"DB2 for the COBOL Programmer" is written in a clear and concise fashion
which even a novice programmer can start using immediately. SQL theory and
application are presented in a way that can only be described as inspired.
Curtis Garvin and Steve Eckols have done an outstanding job taking the
reader from zero to competent professional in this book. I only wish that
more 'techie' books were written like this one (and it's companion, Part 2).

Very helpful reference guide.
I use this book at work all the time for projects where we are adding DB2 to old COBOL programs. I have a little bit of SQL experience, so I generally use this book as a reference. It also helps me use a variety of DB2 features to make the queries simpler and do what I really want.