Source

This article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications. The article shows how EGL and Data Studio Developer can be installed in a shell-sharing mode, and then how pureQuery can be used with the EGL Java generated code to convert dynamic statements to static statements for the DB2 versions, change captured SQL statements with better performing SQL statements,reduce SQL Injection risk, and look at execution times for the different SQL statements in special views provided in DataStudio.

This entry was posted on Wednesday, July 8th, 2009 and is filed under IBM: DB2 Tutorials. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.