Chapter 7. DB2 Programming Roadmap

There are a variety of flexible alternatives for programming with DB2. Over the past decade, a number of standardized programming interfaces for database access have been developed, including ODBC, JDBC, SQLj, and OLE DB. These interfaces provide functions and methods that perform many of the DB2 and SQL commands. For example, to PREPARE a statement using the DB2 CLI driver, you would call the SQLPrepare() function.

This type of abstraction is a key to the driver-based approach of these interfaces. It allows the interface to define operational details, but vendor-specific syntax and native-API calls are hidden in the driver code. Third parties also are able to develop their own drivers for commercial databases, ...

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.