Articles & Content

Archives

Make Your Dynamic SQL Static with Static Profiling (F14)

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

OBJECTIVES:

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.