Chapter 32 Further Reading

IBM Official Documentation

DB2 for z/OS Application Programming and SQL Guide (SC19-4766) The definitive reference for embedded SQL programming. Covers host variable declarations, cursor processing, dynamic SQL, and the SQLCA in exhaustive detail. Essential reading for any DB2 application programmer.
DB2 for z/OS Command Reference (SC19-4768) Complete BIND PLAN and BIND PACKAGE command syntax with all options documented. Includes REBIND, FREE, and related commands.
DB2 for z/OS SQL Reference (SC19-4769) Full SQL syntax for DECLARE CURSOR, FETCH, PREPARE, EXECUTE, and EXECUTE IMMEDIATE. Includes data type mapping tables for COBOL, C, PL/I, and other host languages.
DB2 for z/OS Codes (GC19-4770) Comprehensive listing of all SQLCODE values with explanations, user actions, and related codes. Keep this bookmarked — you will reference it constantly.
DB2 13 for z/OS: Application Programming Guide and Reference for Java (SC27-9846) While focused on Java, this guide provides useful context for understanding how modern access methods compare with embedded SQL.

DB2 Developer's Guide by Craig Mullins (6th Edition) The most comprehensive single-volume reference for DB2 for z/OS. Chapters on embedded SQL, the precompile/bind process, and performance tuning are excellent. Required reading for serious DB2 developers.
DB2 for z/OS: The Complete Reference by Sheryl Larsen Covers embedded SQL programming patterns with detailed examples in both COBOL and C. The chapter on dynamic SQL and the SQLDA is particularly thorough.
COBOL and DB2: A Practical Guide by Jonathan Sayles Focused specifically on the intersection of COBOL and DB2. Includes complete program examples, JCL for the precompile/compile/bind process, and real-world debugging techniques.
DB2 SQL Tuning Tips for z/OS Developers by Tony Andrews While focused on SQL tuning, this book covers the performance implications of static vs dynamic SQL, bind option selection, and multi-row operations — all critical for embedded SQL developers.

DB2 for z/OS: Batch Processing Best Practices (SG24-8458) Covers batch programming patterns including multi-row FETCH, commit strategies, and checkpoint/restart. Directly applicable to the Meridian Bank batch programs discussed in this chapter.
DB2 11 for z/OS Technical Overview (SG24-8180) Provides context for modern DB2 features that affect embedded SQL programs, including new optimization techniques and compatibility considerations.

IBM DB2 for z/OS Knowledge Center https://www.ibm.com/docs/en/db2-for-zos Continuously updated documentation. The "Developing applications" section covers embedded SQL for all supported host languages.
IDUG (International DB2 Users Group) https://www.idug.org Conference proceedings and technical articles from DB2 practitioners. Search for "embedded SQL" and "batch performance" for relevant presentations.
Planet Mainframe https://www.planetmainframe.com Articles on mainframe development including COBOL and DB2 programming techniques, modernization strategies, and performance optimization.

Chapter 22 of this book: Authorization and Security — how BIND-time authorization works with embedded SQL
Chapter 26 (forthcoming): EXPLAIN and Access Path Analysis — understanding the access paths chosen during BIND
Chapter 35 (forthcoming): Stored Procedures — an alternative to embedded SQL for some use cases
Chapter 37 (forthcoming): Performance Tuning — advanced techniques for optimizing batch SQL