Summary
Many programming interfaces can be used to access DB2 databases. Each method has a set of key advantages. Depending on the task, a suitable programming interface should be selected. This chapter has reviewed the key advantages of several programming interfaces.
The Administrative API is useful for performing DB2 administrative tasks from an application. Embedded SQL is best suited for applications in which the best possible performance is critical. ODBC, ADO, and OLE DB programming interfaces are best suited for applications that need to be independent of the data source. This provides greater application portability. CLI provides a native interface for DB2 databases that is compatible with ODBC. JDBC and SQLj programming interfaces are ...
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.
