O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQLj Programs

Dynamic SQL provides flexibility and a means to construct universal interfaces with which to develop database applications. One of the drawbacks, however, is that query performance can suffer because of run-time access plan generation. Also, it often takes time to master an API such as JDBC as compared to directly embedding statements into your application. Although C/C++ programmers have always had a choice of writing their applications using static or dynamic embedded SQL, or using a dynamic SQL API such as ODBC, these options were not open to Java programmers. The only way for a Java application to execute static SQL was to write static embedded SQL code in C, and invoke it using the JNI. Obviously, this is not a pure Java solution, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required