IBM OLE DB Provider support for OLE DB components and interfaces

The following tables list the OLE DB components and interfaces that are supported by the IBM® OLE DB Provider for Db2® and the Microsoft OLE DB Provider for ODBC.
Table 1. Blobs
Interface Db2 ODBC Provider
ISequentialStream Yes Yes
Table 2. Commands
Interface Db2 ODBC Provider
IAccessor Yes Yes
ICommand Yes Yes
ICommandPersist No No
ICommandPrepare Yes Yes
ICommandProperties Yes Yes
ICommandText Yes Yes
ICommandWithParameters Yes Yes
IColumnsInfo Yes Yes
IColumnsRowset Yes Yes
IConvertType Yes Yes
ISupportErrorInfo Yes Yes
Table 3. DataSources
Interface Db2 ODBC Provider
IConnectionPoint No Yes
IDBAsynchNotify (consumer) No No
IDBAsynchStatus No No
IDBConnectionPointContainer No Yes
IDBCreateSession Yes Yes
IDBDataSourceAdmin No No
IDBInfo Yes Yes
IDBInitialize Yes Yes
IDBProperties Yes Yes
IPersist Yes No
IPersistFile Yes Yes
ISupportErrorInfo Yes Yes
Table 4. Enumerators
Interface Db2 ODBC Provider
IDBInitialize Yes Yes
IDBProperties Yes Yes
IParseDisplayName Yes No
ISourcesRowset Yes Yes
ISupportErrorInfo Yes Yes
Table 5. Error Lookup Service
Interface Db2 ODBC Provider
IErrorLookUp Yes Yes
Table 6. Error Objects
Interface Db2 ODBC Provider
IErrorInfo Yes No
ISQLErrorInfo (custom) Yes No
Table 7. Multiple Results
Interface Db2 ODBC Provider
IMultipleResults Yes Yes
ISupportErrorInfo Yes Yes
Table 8. Rowsets
Interface Db2 ODBC Provider
IAccessor Yes Yes
IColumnsRowset Yes Yes
IColumnsInfo Yes Yes
IConvertType Yes Yes
IChapteredRowset No No
IConnectionPointContainer Yes Yes
IDBAsynchStatus No No
IParentRowset No No
IRowset Yes Yes
IRowsetChange Yes Yes
IRowsetChapterMember No No
IRowsetFind No No
IRowsetIdentity Yes Yes
IRowsetIndex No No
IRowsetInfo Yes Yes
IRowsetLocate Yes Yes
IRowsetNotify (consumer) Yes No
IRowsetRefresh Cursor Service Component Yes
IRowsetResynch Cursor Service Component Yes
IRowsetScroll Yes1 Yes
IRowsetUpdate Cursor Service Component Yes
IRowsetView No No
ISupportErrorInfo Yes Yes
Note:
  1. The values to be returned are approximations. Deleted rows will not be skipped.
Table 9. Sessions
Interface Db2 ODBC Provider
IAlterIndex No No
IAlterTable No No
IDBCreateCommand Yes Yes
IDBSchemaRowset Yes Yes
IGetDataSource Yes Yes
IIndexDefinition No No
IOpenRowset Yes Yes
ISessionProperties Yes Yes
ISupportErrorInfo Yes Yes
ITableDefinition No No
ITableDefinitionWithConstraints No No
ITransaction Yes Yes
ITransactionJoin Yes Yes
ITransactionLocal Yes Yes
ITransactionObject No No
ITransactionOptions No Yes
Table 10. View Objects
Interface Db2 ODBC Provider
IViewChapter No No
IViewFilter No No
IViewRowset No No
IViewSort No No