Articles & Content
Topic: 2005 EU
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2005-10-26 (11:00 - 12:00)
SPEAKERS: Daniel Luksetich (Yevich, Lawson and Associates)
DBAs prefer stability and performance when it comes to managing their databases. Dynamic SQL provides a challenge to this stability and performance. DB2 ODBC/JDBC/CLI SQL static profiling provides another way to get the predicable access paths and security of static SQL from a dynamic SQL application. Come and see how you can turn dynamic SQL into static SQL!
EXP. LEVEL: Intermediate
The challenges of dynamic SQL applications
The advantages of static SQL
Introduction to SQL static profiling
Using static profiling for performance
Using static profiling for security
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.