DB2: Concepts, Design, and Programming

This practical guide to DB2, IBM's primary relational database product, provides both an introduction to and an in-depth discussion of the DB2 environment, as well as complete coverage of DB2's Structured Query Language (SOL). it also provides thorough coverage of many related products, including Query Management Facility (QMF) and Data Extract (DXT).

This book, up-to-date with Version 2 of DB2, discusses a wide range of capabilities, from ad hoc use by end users to the development of production applications by professional programmers.

Topics covered include:
normalization
referential integrity
security
concurrency

In addition, the book offers a thorough analysis of DB2 logical and physical data structures. It covers the use of SQL for both simple and complex queries, report formatting with QMF, and the use of Query-by-Example (QBE). DB2 program development and DB2 system administration are also discussed.

Written by the IBM mainframe guru, this book is for all data base courses on IBM mainframes. Full of practical examples and real-world situations, the book is appropriate for all computer applications courses, especially database management.