This is the only beginning book that presents 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. Twelve 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 right so you don't tie up the whole database; use DB2I (a TSO facility) to develop DB2 programs interactively or in batch; and create test data using SPUFI and QMF.

DB2 for the COBOL Programmer, Part 1, 2nd Ed.

Computers & Technology

Eckols, Steve

Garvin, Curtis

Programming

Mike Murach and Associates, Inc.

Designed specifically for COBOL programmers, DB2 for the COBOL Programmer, Part 2 takes up where Part 1 leaves off. Part 1 covers the essentials needed to write any COBOL program that handles DB2 data. Part 2 builds on that base to give you advanced DB2 skills, so you can become a top senior programmer or programmer/analyst in your shop. 
That means you'll learn: 
How to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead 
How to use dynamic SQL so your programs can generate and execute SQL statements as they run 
How data sharing works on the parallel sysplex and other System/390 configurations 
How to work with distributed DB2 data 
How to process DB2 data in CICS programs 
Advanced locking concepts that show how locking and data sharing affect each other and what impact that has on program efficiency 
The concepts and practices of DB2 database administration that let the programmer design databases, manage database objectives, and set up a quality assurance environment

DB2 for the Cobol Programmer, Part 2

Prince, Ann

Programming Languages

Mike Murach Associates Inc

See the best price to sell, buy, or rent books by Garvin, Curtis. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Garvin, Curtis