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

IBM Redbooks

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

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 Redbook 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.
Price: $47.00 $37.00
Pages: 284
Date Published: May 31, 2002
ISBN: 0738425265
Author: IBM Redbooks
Product Number: SG24-6418-00
Ships in 3-5 days
Why Vervante?

© 2022 Vervante Corporation. All rights reserved.