Driver-Based Application Solutions

Embedded SQL applications require that a vendor's precompiler first precompile the application and then the resultant source code be compiled and linked directly with a vendor's library. In most cases, the application will also have to be bound to the database that it is accessing so that the database can generate an access plan based on static queries made within the application. If a developer wants his application to work against another vendor's database, then he needs to repeat these steps for an alternate database. It's a lot of work, but at least the source code should not need to be modified.

An alternative approach to accessing databases is to use a driver-based solution. This solution involves a driver ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.