Articles & Content


Make Your Dynamic SQL Static with Static Profiling (F14)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2005

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

Click Here to Download

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