Synopses & Reviews
Ours are the only DB2 books that present DB2 from the COBOL programmer's point of view. But that of course is what you need if you're writing COBOL programs that process DB2 databases on an IBM mainframe.
In Part 1, 12 complete programs show you how to use embedded SQL statements within a COBOL program. Along the way, you'll learn how to:
-- design and code DB2 programs
-- use inner joins, outer joins, and unions to combine data from two or more tables
-- use column functions to extract summary data
-- work with variable-length data and nulls
-- use error handling techniques, Commit, and Rollback to protect the validity of DB2 data
-- use locking and concurrency features so you don't tie up the whole database
-- use DB2I (a TSO facility) to develop DB2 programs interactively or in batch
-- create test data using SPUFI and QMF
This classic book has been a staple on computer bookshelves since 1991 because it teaches DB2 from the programmer's point of view. Now it's newly revised and reorganized for more effective training.