SAS OLE DB Provider Property Documentation (Provider Index)

Supported Properties in the IOM Provider

• DBPROP_APPENDONLY
  
• DBPROP_AUTH_PASSWORD
  
• DBPROP_AUTH_USERID
  
• DBPROP_BOOKMARKS
  
• DBPROP_BOOKMARKSKIPPED
  
• DBPROP_BOOKMARKTYPE
  
• DBPROP_BYREFACCESSORS
  
• DBPROP_CANFETCHBACKWARDS
  
• DBPROP_CANHOLDROWS
  
• DBPROP_CANSCROLLBACKWARDS
  
• DBPROP_DATASOURCEREADONLY
  
• DBPROP_DBMSNAME
  
• DBPROP_DBMSVER
  
• DBPROP_IAccessor
  
• DBPROP_IColumnsInfo
  
• DBPROP_IConvertType
  
• DBPROP_INIT_DATASOURCE
  
• DBPROP_INIT_LOCATION
  
• DBPROP_INIT_MODE
  
• DBPROP_INIT_PROVIDERSTRING
  
• DBPROP_IRowset
  
• DBPROP_IRowsetChange
  
• DBPROP_IRowsetIdentity
  
• DBPROP_IRowsetInfo
  
• DBPROP_IRowsetLocate
  
• DBPROP_IRowsetUpdate
  
• DBPROP_ISupportErrorInfo
  
• DBPROP_LITERALBOOKMARKS
  
• DBPROP_LITERALIDENTITY
  
• DBPROP_MAXOPENROWS
  
• DBPROP_MAXPENDINGROWS
  
• DBPROP_MAXROWS
  
• DBPROP_ORDEREDBOOKMARKS
  
• DBPROP_OTHERINSERT
  
• DBPROP_OTHERUPDATEDELETE
  
• DBPROP_OWNINSERT
  
• DBPROP_OWNUPDATEDELETE
  
• DBPROP_PROVIDERVER
  
• DBPROP_SAS_ALTERPASSWORD
  
• DBPROP_SAS_BLANKPADDING
  
• DBPROP_SAS_ENGINE
  
• DBPROP_SAS_FORMATS
  
• DBPROP_SAS_INFORMATS
  
• DBPROP_SAS_INIT_LOGICALNAME
  
• DBPROP_SAS_INIT_MACHINEDNSNAME
  
• DBPROP_SAS_INIT_PORT
  
• DBPROP_SAS_INIT_PROTOCOL
  
• DBPROP_SAS_INIT_SERVICENAME
  
• DBPROP_SAS_INIT_WORKSPACE
  
• DBPROP_SAS_INIT_WORKSPACEID
  
• DBPROP_SAS_LIBOPTS
  
• DBPROP_SAS_OPTIMISTICLOCKING
  
• DBPROP_SAS_PATH
  
• DBPROP_SAS_READPASSWORD
  
• DBPROP_SAS_SQLCONNECTIONSTRING
  
• DBPROP_SAS_SQLENGINE
  
• DBPROP_SAS_WRITEPASSWORD
  
• DBPROP_SESS_AUTOCOMMITISOLEVELS
  
• DBPROP_SUPPORTEDTXNISOLEVELS
  
• DBPROP_UPDATABILITY
  

Supported Properties in the Local Provider

• DBPROP_APPENDONLY
  
• DBPROP_AUTH_PASSWORD
  
• DBPROP_AUTH_USERID
  
• DBPROP_BOOKMARKS
  
• DBPROP_BOOKMARKSKIPPED
  
• DBPROP_BOOKMARKTYPE
  
• DBPROP_BYREFACCESSORS
  
• DBPROP_CANFETCHBACKWARDS
  
• DBPROP_CANHOLDROWS
  
• DBPROP_CANSCROLLBACKWARDS
  
• DBPROP_DATASOURCEREADONLY
  
• DBPROP_DBMSNAME
  
• DBPROP_DBMSVER
  
• DBPROP_IAccessor
  
• DBPROP_IColumnsInfo
  
• DBPROP_IConvertType
  
• DBPROP_INIT_DATASOURCE
  
• DBPROP_INIT_LOCATION
  
• DBPROP_INIT_MODE
  
• DBPROP_INIT_PROVIDERSTRING
  
• DBPROP_IRowset
  
• DBPROP_IRowsetChange
  
• DBPROP_IRowsetIdentity
  
• DBPROP_IRowsetInfo
  
• DBPROP_IRowsetLocate
  
• DBPROP_IRowsetUpdate
  
• DBPROP_IRowsetView
  
• DBPROP_ISupportErrorInfo
  
• DBPROP_IViewFilter
  
• DBPROP_IViewRowset
  
• DBPROP_IViewSort
  
• DBPROP_LITERALBOOKMARKS
  
• DBPROP_LITERALIDENTITY
  
• DBPROP_MAXOPENROWS
  
• DBPROP_MAXORSINFILTER
  
• DBPROP_MAXPENDINGROWS
  
• DBPROP_MAXROWS
  
• DBPROP_MAXSORTCOLUMNS
  
• DBPROP_ORDEREDBOOKMARKS
  
• DBPROP_OTHERINSERT
  
• DBPROP_OTHERUPDATEDELETE
  
• DBPROP_OWNINSERT
  
• DBPROP_OWNUPDATEDELETE
  
• DBPROP_PROVIDERVER
  
• DBPROP_REMOVEDELETED
  
• DBPROP_SAS_ALTERPASSWORD
  
• DBPROP_SAS_BLANKPADDING
  
• DBPROP_SAS_DEFAULTFILEFORMAT
  
• DBPROP_SAS_FMTERR
  
• DBPROP_SAS_FORMATS
  
• DBPROP_SAS_INFORMATS
  
• DBPROP_SAS_INIT_FILEFORMAT
  
• DBPROP_SAS_READPASSWORD
  
• DBPROP_SAS_WRITEPASSWORD
  
• DBPROP_SESS_AUTOCOMMITISOLEVELS
  
• DBPROP_SORTONINDEX
  
• DBPROP_SUPPORTEDTXNISOLEVELS
  
• DBPROP_UPDATABILITY
  

Supported Properties in the SHARE Provider

• DBPROP_APPENDONLY
  
• DBPROP_AUTH_PASSWORD
  
• DBPROP_AUTH_USERID
  
• DBPROP_BOOKMARKS
  
• DBPROP_BOOKMARKSKIPPED
  
• DBPROP_BOOKMARKTYPE
  
• DBPROP_BYREFACCESSORS
  
• DBPROP_CANFETCHBACKWARDS
  
• DBPROP_CANHOLDROWS
  
• DBPROP_CANSCROLLBACKWARDS
  
• DBPROP_DATASOURCEREADONLY
  
• DBPROP_DBMSNAME
  
• DBPROP_DBMSVER
  
• DBPROP_IAccessor
  
• DBPROP_IColumnsInfo
  
• DBPROP_IConvertType
  
• DBPROP_INIT_DATASOURCE
  
• DBPROP_INIT_LOCATION
  
• DBPROP_INIT_MODE
  
• DBPROP_INIT_PROVIDERSTRING
  
• DBPROP_IRowset
  
• DBPROP_IRowsetChange
  
• DBPROP_IRowsetIdentity
  
• DBPROP_IRowsetInfo
  
• DBPROP_IRowsetLocate
  
• DBPROP_IRowsetUpdate
  
• DBPROP_ISupportErrorInfo
  
• DBPROP_LITERALBOOKMARKS
  
• DBPROP_LITERALIDENTITY
  
• DBPROP_MAXOPENROWS
  
• DBPROP_MAXPENDINGROWS
  
• DBPROP_MAXROWS
  
• DBPROP_ORDEREDBOOKMARKS
  
• DBPROP_OTHERINSERT
  
• DBPROP_OTHERUPDATEDELETE
  
• DBPROP_OWNINSERT
  
• DBPROP_OWNUPDATEDELETE
  
• DBPROP_PROVIDERVER
  
• DBPROP_SAS_ALTERPASSWORD
  
• DBPROP_SAS_BLANKPADDING
  
• DBPROP_SAS_FMTERR
  
• DBPROP_SAS_FORMATS
  
• DBPROP_SAS_INFORMATS
  
• DBPROP_SAS_INIT_SERVERPASSWORD
  
• DBPROP_SAS_INIT_SERVERRELEASE
  
• DBPROP_SAS_OPTIMISTICLOCKING
  
• DBPROP_SAS_PT2DBPW
  
• DBPROP_SAS_READPASSWORD
  
• DBPROP_SAS_SQLCONNECTIONSTRING
  
• DBPROP_SAS_SQLENGINE
  
• DBPROP_SAS_WHERE
  
• DBPROP_SAS_WRITEPASSWORD
  
• DBPROP_SESS_AUTOCOMMITISOLEVELS
  
• DBPROP_SUPPORTEDTXNISOLEVELS
  
• DBPROP_UPDATABILITY
  

SAS IOM Data Provider