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!, ISBN13: 9781890774028 ISBN10: 1890774022 Material Type: paperbackThis 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!, ISBN13: 9781890774028 ISBN10: 1890774022 Material Type: paperback , ISBN13: 9781890774028 ISBN10: 1890774022 Material Type: paperback

Garvin, Curtis,Eckols, Steve