DB2 for z/OS and OS/390 : Squeezing the Most Out of Dynamic SQL

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 31 May 2002

cover image

ISBN-10: 0738425265
ISBN-13: 9780738425269
IBM Form #: SG24-6418-00
(284 pages)

More options

Rate and comment

Authors: Bart Steegmans, Freddy Lorge, Axel Puerner, Suresh Sane


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.

Table of contents

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

Others who read this publication also read

Follow IBM Redbooks

Follow IBM Redbooks