The time has come to set the record straight. While the use of dynamic SQL in vendor packages continues to rise at a steep rate, the perception of most DB2 professionals remains that dynamic SQL is complex, resource-intensive, and difficult to manage. How true are these perceptions?

This IBM Redbooks publication investigates some of the myths and misconceptions surrounding dynamic SQL. It presents a balanced discussion of issues such as complexity, performance, and control, and provides a jump-start to those venturing into this somewhat under-utilized area.

What is dynamic SQL? When is it appropriate? How do I develop an application in COBOL, REXX, Java with JDBC, or C using ODBC containing dynamic SQL? How do I obtain the best performance from it? Should I use dynamic statement caching (and if so, which flavor) for my dynamic SQL statements? How do Enterprise Solution Packages packages exploit dynamic SQL? How do I manage and control it?

In this book, we focus on these and similar questions as we show you how to maximize the benefits that can be obtained by using dynamic SQL in your applications.

Part 1. Overview of dynamic SQL

Chapter 1. Introduction

Part 2. Developing applications using dynamic SQL

Chapter 2. Dynamic SQL: making the right choice

Chapter 3. Developing embedded dynamic SQL applications

Chapter 4. Developing ODBC applications

Chapter 5. Developing JDBC applications

Chapter 6. Developing REXX applications using dynamic SQL

Chapter 7. Preparing dynamic SQL applications

Part 3. Managing dynamic SQL

Chapter 8. Dynamic statement caching

Chapter 9. System controls for dynamic SQL

Chapter 10. Locking and concurrency

Chapter 11. Governing dynamic SQL

Chapter 12. Monitoring, tracing and explaining dynamic SQL

Chapter 13. Security aspects of dynamic SQL

Chapter 14. Remote dynamic SQL

Part 4. Dynamic SQL in vendor packages

Chapter 15. Dynamic SQL in ESP packages

Part 5. Appendixes

Appendix A. Comparing plan accounting, package accounting, and cache statistics

Appendix B. Additional material