Articles & Content
Topic: 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
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.