DB2 10.5 for Linux, UNIX, and Windows

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