Book DescriptionThis 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!
Customer Reviews
Average Rating:
Rating: - 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.
Rating: - 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 ... Read More
Rating: - 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 ... Read More
- Very helpful reference guide.
- If you want to learn DB2/SQL this is a MUST HAVE
