IBM OLE DB Provider restrictions

The restrictions for the IBM® OLE DB Provider are:
  • IBMDADB2 supports auto commit and user-controlled transaction scope with the ITransactionLocal interface. Auto commit transaction scope is the default scope. Nested transactions are not supported.
  • RestartPosition is not supported when the command text contains parameters.
  • IBMDADB2 does not quote table names passed through the DBID parameters, which are parameters used by the IOpenRowset interface. Instead, the OLE DB consumer must add quotation marks to the table names when quotes are required.