Features
- Cover Type: Paperback with 448 pages
- Published by: Mike Murach & Associates
- Edition: 2nd Edition January 1998
- Written in: English
- ISBN 10 Number: 1890774022
- ISBN 13 Number: 978-1890774028
-
Book Dimensions:
10 x 8 x 1.1 inches
- Weighs: 2.2 pounds
Book 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 logicallyhow to design and code DB2 programshow to use inner joins, outer joins, and unions to combine data from two or more tableshow to use column functions to extract summary data from a tablehow to work with variable-length data and nullshow to use error handling techniques and ROLLBACK to protect DB2 datahow to use locking and concurrency features so you don't tie up the whole systemhow to develop DB2 programs interactively (using DB2I, a TSO facility) or in batchhow to create test data using SPUFI and QMFand more!
Book Info
Covers Version 4 enhancements like outer joins and the explicit syntax for inner joins that change the way programs are written. Completely revised and updated. Softcover.
Reader Reviews
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.
Comment | |
(Report this)