IBM OLE DB Provider support for ADO methods and properties

The IBM® OLE DB Provider supports the following ADO methods and properties:
Table 1. Command Methods
Method/Property OLE DB Interface/Property IBM OLE DB Support
Cancel ICommand Yes
CreateParameter   Yes
Execute   Yes
Table 2. Command Properties
Method/Property OLE DB Interface/Property IBM OLE DB Support
ActiveConnection (ADO specific)  
Command Text ICommandText Yes
Command Timeout
ICommandProperties::SetProperties
DBPROP_COMMANDTIMEOUT
Yes
CommandType (ADO specific)  
Prepared ICommandPrepare Yes
State (ADO specific)  
Table 3. Command Collections
Method/Property OLE DB Interface/Property IBM OLE DB Support
Parameters
ICommandWithParameter
DBSCHEMA
_PROCEDURE_PARAMETERS
Yes
Properties
ICommandProperties
IDBProperties
Yes
Table 4. Connection Methods
Method/Property OLE DB Interface/Property IBM OLE DB Support
BeginTrans
CommitTrans
RollbackTrans
ITransactionLocal
Yes (but not nested)
Yes (but not nested)
Yes (but not nested)
Execute
ICommand
IOpenRowset
Yes
Open
IDBCreateSession
IDBInitialize
Yes
OpenSchema
adSchemaColumnPrivileges
adSchemaColumns
adSchemaForeignKeys
adSchemaIndexes
adSchemaPrimaryKeys
adSchemaProcedureParam
adSchemaProcedures
adSchemaProviderType
adSchemaStatistics
adSchemaTablePrivileges
adSchemaTables
IDBSchemaRowset

Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Cancel   Yes
Table 5. Connection Properties
Method/Property OLE DB Interface/Property IBM OLE DB Support
Attributes
adXactCommitRetaining
adXactRollbackRetaining
ITransactionLocal

Yes
Yes
CommandTimeout
ICommandProperties
DBPROP_COMMAND_TIMEOUT
Yes
ConnectionString (ADO specific)  
ConnectionTimeout
IDBProperties
DBPROP_INIT_TIMEOUT
No
CursorLocation:
adUseClient
adUseNone
adUseServer

(Use OLE DB Cursor Service)
(Not Used)

Yes
No
Yes
DefaultDataBase
IDBProperties
DBPROP_CURRENTCATALOG
No
IsolationLevel
ITransactionLocal
DBPROP_SESS
_AUTOCOMMITISOLEVELS
Yes
Mode
adModeRead
adModeReadWrite
adModeShareDenyNone
adModeShareDenyRead
adModeShareDenyWrite
adModeShareExclusive
adModeUnknown
adModeWrite
IDBProperties
DBPROP_INIT_MODE

No
Yes
No
No
No
No
No
No
Provider ISourceRowset::GetSourceRowset Yes
State (ADO specific)  
Version (ADO specific)  
Table 6. Connection Collection
Method/Property OLE DB Interface/Property IBM OLE DB Support
Errors IErrorRecords Yes
Properties IDBProperties Yes
Table 7. Error Properties
Method/Property OLE DB Interface/Property IBM OLE DB Support
Description
NativeError
Number
Source
SQLState
IErrorRecords
Yes
Yes
Yes
Yes
Yes
HelpContext
HelpFile
  
No
No
Table 8. Field Methods
Method/Property OLE DB Interface/Property IBM OLE DB Support
AppendChunk
GetChunk
ISequentialStream
Yes
Yes
Table 9. Field Properties
Method/Property OLE DB Interface/Property IBM OLE DB Support
Actual Size
IAccessor
IRowset
Yes
Attributes
DataFormat
DefinedSize
Name
NumericScale
Precision
Type
IColumnInfo

Yes
Yes
Yes
Yes
Yes
Yes
OriginalValue IRowsetUpdate Yes (Cursor Service)
UnderlyingValue
IRowsetRefresh

IRowsetResynch
Yes
(Cursor Service)
Yes
(Cursor Service)
Value
IAccessor
IRowset
Yes
Table 10. Field Collection
Method/Property OLE DB Interface/Property IBM OLE DB Support
Properties
IDBProperties
IRowsetInfo
Yes
Table 11. Parameter Methods
Method/Property OLE DB Interface/Property IBM OLE DB Support
AppendChunk ISequentialStream Yes
Attributes
Direction
Name
NumericScale
Precision
Scale
Size
Type
ICommandWithParameter
DBSCHEMA
_PROCEDURE_PARAMETERS

Yes
No
Yes
Yes
Yes
Yes
Yes
Value
IAccessor
ICommand
Yes
Table 12. Parameter Collection
Method/Property OLE DB Interface/Property IBM OLE DB Support
Properties   Yes
Table 13. RecordSet Methods
Method/Property OLE DB Interface/Property IBM OLE DB Support
AddNew IRowsetChange Yes
Cancel   Yes
CancelBatch IRowsetUpdate::Undo Yes (Cursor Service)
CancelUpdate   Yes (Cursor Service)
Clone IRowsetLocate Yes
Close
IAccessor
IRowset
Yes
CompareBookmarks   No
Delete IRowsetChange Yes
GetRows
IAccessor
IRowset
Yes
Move
IRowset
IRowsetLocate
 Yes
MoveFirst
IRowset
IRowsetLocate
Yes
MoveNext
IRowset
IRowsetLocate
Yes
MoveLast IRowsetLocate Yes
MovePrevious IRowsetLocate Yes
NextRecordSet IMultipleResults Yes
Open
ICommand
IOpenRowset
Yes
Requery
ICommand
IOpenRowset
Yes
Resync IRowsetRefresh Yes (Cursor Service)
Supports IRowsetInfo Yes
Update
UpdateBatch
IRowsetChange
IRowsetUpdate
Yes
Yes (Cursor Service)
Table 14. RecordSet Properties
Method/Property OLE DB Interface/Property IBM OLE DB Support
AbsolutePage
IRowsetLocate
IRowsetScroll
Yes
Yes1
AbsolutePosition
IRowsetLocate
IRowsetScroll
Yes
Yes1
ActiveConnection
IDBCreateSession
IDBInitialize
Yes
BOF (ADO specific)  
Bookmark
IAccessor
IRowsetLocate
Yes
CacheSize
cRows in IRowsetLocate
IRowset
Yes
CursorType
adOpenDynamic
adOpenForwardOnly
adOpenKeySet
adOpenStatic
ICommandProperties

No
Yes
Yes
Yes
EditMode IRowsetUpdate Yes (Cursor Service)
EOF (ADO specific)  
Filter
IRowsetLocate
IRowsetView
IRowsetUpdate
IViewChapter
IViewFilter
No
LockType ICommandProperties Yes
MarshallOption   No
MaxRecords
ICommandProperties
IOpenRowset
Yes
PageCount IRowsetScroll Yes1
PageSize (ADO specific)  
Sort (ADO specific)  
Source (ADO specific)  
State (ADO specific)  
Status IRowsetUpdate Yes (Cursor Service)
Note:
  1. The values to be returned are approximations. Deleted rows will not be skipped.
Table 15. RecordSet Collection
Method/Property OLE DB Interface/Property IBM OLE DB Support
Fields IColumnInfo Yes
Properties
IDBProperties
IRowsetInfo::GetProperties
Yes