Individual Properties (by Group)

The following is a list of individual properties that are supported by one or more of the SAS providers. The properties listed are organized by property group and, within each group, by property set. Each entry in the list is a link to the information in the alphabetical table of properties. While this table may be used as a reference, the individual programmer is responsible for checking the values of properties and whether properties are supported.

Supported Properties in the Data Source Information Group

• DBPROPSET_DATASOURCEINFO
  
  • DBPROP_BYREFACCESSORS
    
  • DBPROP_DATASOURCEREADONLY
    
  • DBPROP_DBMSNAME
    
  • DBPROP_DBMSVER
    
  • DBPROP_PROVIDERVER
    
  • DBPROP_SUPPORTEDTXNISOLEVELS
    
• DBPROPSET_SAS_DATASOURCEINFO
  
  • DBPROP_SAS_DEFAULTFILEFORMAT
    

Supported Properties in the Initialization Group

• DBPROPSET_DBINIT
  
  • DBPROP_AUTH_PASSWORD
    
  • DBPROP_AUTH_USERID
    
  • DBPROP_INIT_DATASOURCE
    
  • DBPROP_INIT_LOCATION
    
  • DBPROP_INIT_MODE
    
  • DBPROP_INIT_PROVIDERSTRING
    
• DBPROPSET_SAS_DBINIT
  
  • DBPROP_SAS_INIT_FILEFORMAT
    
  • DBPROP_SAS_INIT_LOGICALNAME
    
  • DBPROP_SAS_INIT_MACHINEDNSNAME
    
  • DBPROP_SAS_INIT_PORT
    
  • DBPROP_SAS_INIT_PROTOCOL
    
  • DBPROP_SAS_INIT_SERVERPASSWORD
    
  • DBPROP_SAS_INIT_SERVERRELEASE
    
  • DBPROP_SAS_INIT_SERVICENAME
    
  • DBPROP_SAS_INIT_WORKSPACE
    
  • DBPROP_SAS_INIT_WORKSPACEID
    
• DBPROPSET_SAS_ROWSET
  
  • DBPROP_SAS_ENGINE
    
  • DBPROP_SAS_LIBOPTS
    
  • DBPROP_SAS_PATH
    

Supported Properties in the Rowset Group

• DBPROPSET_ROWSET
  
  • DBPROP_APPENDONLY
    
  • DBPROP_BOOKMARKS
    
  • DBPROP_BOOKMARKSKIPPED
    
  • DBPROP_BOOKMARKTYPE
    
  • DBPROP_CANFETCHBACKWARDS
    
  • DBPROP_CANHOLDROWS
    
  • DBPROP_CANSCROLLBACKWARDS
    
  • DBPROP_IAccessor
    
  • DBPROP_IColumnsInfo
    
  • DBPROP_IConvertType
    
  • DBPROP_IRowset
    
  • DBPROP_IRowsetChange
    
  • DBPROP_IRowsetIdentity
    
  • DBPROP_IRowsetInfo
    
  • DBPROP_IRowsetLocate
    
  • DBPROP_IRowsetUpdate
    
  • DBPROP_IRowsetView
    
  • DBPROP_ISupportErrorInfo
    
  • DBPROP_LITERALBOOKMARKS
    
  • DBPROP_LITERALIDENTITY
    
  • DBPROP_MAXOPENROWS
    
  • DBPROP_MAXPENDINGROWS
    
  • DBPROP_MAXROWS
    
  • DBPROP_ORDEREDBOOKMARKS
    
  • DBPROP_OTHERINSERT
    
  • DBPROP_OTHERUPDATEDELETE
    
  • DBPROP_OWNINSERT
    
  • DBPROP_OWNUPDATEDELETE
    
  • DBPROP_REMOVEDELETED
    
  • DBPROP_UPDATABILITY
    
• DBPROPSET_SAS_ROWSET
  
  • DBPROP_SAS_ALTERPASSWORD
    
  • DBPROP_SAS_BLANKPADDING
    
  • DBPROP_SAS_FMTERR
    
  • DBPROP_SAS_FORMATS
    
  • DBPROP_SAS_INFORMATS
    
  • DBPROP_SAS_OPTIMISTICLOCKING
    
  • DBPROP_SAS_READPASSWORD
    
  • DBPROP_SAS_WHERE
    
  • DBPROP_SAS_WRITEPASSWORD
    
• DBPROPSET_VIEW
  
  • DBPROP_IViewFilter
    
  • DBPROP_IViewRowset
    
  • DBPROP_IViewSort
    
  • DBPROP_MAXORSINFILTER
    
  • DBPROP_MAXSORTCOLUMNS
    
  • DBPROP_SORTONINDEX
    

Supported Properties in the Session Group

• DBPROPSET_SAS_SESSION
  
  • DBPROP_SAS_PT2DBPW
    
  • DBPROP_SAS_SQLCONNECTIONSTRING
    
  • DBPROP_SAS_SQLENGINE
    
• DBPROPSET_SESSION
  
  • DBPROP_SESS_AUTOCOMMITISOLEVELS
    

SAS IOM Data Provider