Articles & Content


Java Data Access Applications You Can Trust - Easy Static SQL Deployment with pureQuery (H07)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2009

DATE: 2009-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: William Bireley (IBM)

Although Java applications using JDBC have become the de-facto standard in web application environments, many DB2 administrators have been tested by the challenges inherent with the dynamic SQL normally used. Many of these same administrators are familiar with the operational characteristics of static SQL applications from traditional OLTP environments. In fact a few enterprise environments still donít permit JDBC applications, or only permit them to call stored procedures.For Java Application Developers, the SQLJ programming interface has been the only choice for enabling static SQL. Now the pureQuery platform provides other options to easily deploy Java applications using static SQL. Existing dynamic JDBC applications can be converted to use static SQL packages. Or developers can code new applications using the pureQuery programming API from the high productivity Data Studio Developer product. The accompanying utilities greatly simplify static deployment.

EXP. LEVEL: Beginner,Intermediate


Tools for managing pureQuery application deployments and package binds.

How to use pureQuery with existing application frameworks

How to convert JDBC applications to use static SQL with pureQuery

Comparison of SQLJ and pureQuery

Performance Characteristics of pureQuery applications using static SQL

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.