Part II. DB2 Application Development

Part I, “SQL Techniques, Tips, and Tricks,” described the nature and features of SQL and introduced guidelines for its efficient and effective use. Part II provides information on the development of DB2 applications.

Chapter 13, “Using DB2 in an Application Program,” discusses the components of embedded static SQL programming and provides guidelines for the proper implementation of DB2 programs. Dynamic SQL is covered in-depth in Chapter 14, “Dynamic SQL Programming,” complete with examples, coding guidelines, and advice on when to use dynamic SQL over static SQL. Chapter 15, “Program Preparation,” discusses the steps to take to prepare DB2 programs for execution.

Chapter 16, “Using DB2 Stored Procedures

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.