This is the only advanced DB2 book written specifically for COBOL programmers! Now, in this Second Edition, it's been completely revised to reflect the mix of programming and DBA skills you need to be a top senior programmer or programmer/analyst in today's DB2/COBOL 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 to process DB2 data in CICS programs. How to work with distributed DB2 data, where the data is managed by a DB2 subsystem on a system that's connected over a network. How data sharing works on the parallel sysplex and other System/390 configurations. Advanced locking concepts that let you understand 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 you design databases, manage database objects, and set up a quality assurance environment.

So don't wait to rise to a new level of DB2 programming. Get a copy of this book TODAY.

Product Description

Following on from Part 1, this guide covers advanced skills in DB2 programming, including using dynamic SQL, data sharing and locking concepts, and administration that lets readers design database, manage dabatase objects and set up quality assurance environments.

"About this title" may belong to another edition of this title.