Dan Galvin's Page

The planning committee for IDUG® 2011 - North America is currently accepting abstracts for presentations. If you have an interesting topic to share with the conference community, this is an excellent opportunity to to relate your experiences and to give others your insi

… Continue

You may have heard about several different capabilites available with pureQuery such as Client Optimization, Annotated Method and In-Line. Some questions that I have had about these options would include what is the difference between these methods and where do I use each? I wanted to just quickly write a few paragraphs to answer these two primary questions.

In answer to the first question, both Annotated Method and In-Line are part of the pureQuery API. Annotated Method uses a

… Continue

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