Dan Galvin's Page

Optim pureQuery provides many benefits which include improved quality, improved developer productivity and dramatically improved performance over JDBC based solutions against databases which support static package binds, such as DB2.

Most often discussed about the performance benefits is static packages. However, if you have high-volume INSERT and UPDATE applications, static SQL is only a part of the benefit. pureQuery offers a Heterogeneous Batch capability which can significantly reduc… Continue

Initially, version 1.1.x of Data Studio pureQuery had some support in the Spring Mods. This allowed configuration of pureQuery "DAO" classes with Spring. The Spring compent is spring-pdq.jar and is available at the following link:

jira.springframework.org/MOD-415

That support has been updated now by Matt Anderson to include support fo… Continue

The Data Studio developers at IBM have put together some videos discussing and demonstrating DSD 2.1 and the new features available. If you are a user of Data Studio Developer, you might find some of these videos interesting. If you are new to Data Studio, in addition to these videos, there are many other resources available that demonstrates how Data Studio Developer can help your efforts.

Sonali Surange discusses DSD 2.1 features:… Continue