Skip to main content

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 on 31 May 2002

  1. .PDF (3.8 MB)

Share this page:   

ISBN-10: 0738425265
ISBN-13: 9780738425269
IBM Form #: SG24-6418-00

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

    menu icon


    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 also read