DB2 for the COBOL Programmer Part 2- Curtis Garvin, Anne Prince – 2nd Edition

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