3.1.4.2.2.1.2.1 PropertyList

Article
02/16/2023

The PropertyList type contains the properties that are associated with a Discover or Execute request. Only writeable properties can be sent to the server in a request. Attempts to send properties that are not writeable or that are reserved for future use will result in a fault.

   <xsd:complexType name="PropertyList" >
     <xsd:all>
       <xsd:element name="DataSourceInfo" type="xsd:string" minOccurs="0" />
       <xsd:element name="Timeout" type="xsd:integer" minOccurs="0" />
       <xsd:element name="UserName" type="xsd:string" minOccurs="0" />
       <xsd:element name="Password" type="xsd:string" minOccurs="0" />
       <xsd:element name="LocaleIdentifier" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="Catalog" type="xsd:string" minOccurs="0" />
       <xsd:element name="StateSupport" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="None" />
             <xsd:enumeration value="Sessions" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Content" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="None" />
             <xsd:enumeration value="Schema" />
             <xsd:enumeration value="Data" />
             <xsd:enumeration value="SchemaData" />
             <xsd:enumeration value="Metadata" />
            
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Format" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Tabular" />
             <xsd:enumeration value="Multidimensional" />
             <xsd:enumeration value="Native" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="AxisFormat" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="ClusterFormat" />
             <xsd:enumeration value="CustomFormat" />
             <xsd:enumeration value="TupleFormat" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="BeginRange" type="xsd:integer" minOccurs="0" />
       <xsd:element name="EndRange" type="xsd:integer" minOccurs="0" />
       <xsd:element name="MDXSupport" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Core" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ProviderName" type="xsd:string" minOccurs="0" />
       <xsd:element name="ProviderVersion" type="xsd:string" minOccurs="0" />
       <xsd:element name="DBMSVersion" type="xsd:string" minOccurs="0" />
       <xsd:element name="ProviderType" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="3" />
             <xsd:enumeration value="4" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ShowHiddenCubes" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="SQLSupport" type="xsd:integer" minOccurs="0" />
       <xsd:element name="TransactionDDL" type="xsd:integer" minOccurs="0" />
       <xsd:element name="MaximumRows" type="xsd:integer" minOccurs="0" />
       <xsd:element name="Roles" type="xsd:string" minOccurs="0" />
       <xsd:element name="VisualMode" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="EffectiveRoles" type="xsd:string" minOccurs="0" />
       <xsd:element name="EffectiveUserName" type="xsd:string" minOccurs="0" />
       <xsd:element name="ServerName" type="xsd:string" minOccurs="0" />
       <xsd:element name="CatalogLocation" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropCatalogTerm" type="xsd:string" minOccurs="0" />
       <xsd:element name="DbpropCatalogUsage" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropColumnDefinition" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropConcatNullBehavior" minOccurs="0 " >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropDataSourceReadOnly" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="DbpropGroupBy" minOccurs="0" type="xsd:integer" />
       <xsd:element name="DbpropHeterogeneousTables" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropIdentifierCase" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropMaxIndexSize" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropMaxOpenChapters" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropMaxRowSize" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropMaxRowSizeIncludeBlob" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="DbpropMaxTablesInSelect" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropMultiTableUpdate" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="DbpropNullCollation" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="4" />
             <xsd:enumeration value="8" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropOrderByColumnsInSelect" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="DbpropOutputParameterAvailable" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="4" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropPersistentIdType" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="4" />
             <xsd:enumeration value="8" />
             <xsd:enumeration value="16" />
             <xsd:enumeration value="32" />
             <xsd:enumeration value="64" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropPrepareAbortBehavior" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropPrepareCommitBehavior" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropProcedureTerm" type="xsd:string" minOccurs="0" />
       <xsd:element name="DbpropQuotedIdentifierCase" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="4" />
             <xsd:enumeration value="8" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropSchemaUsage" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropSqlSupport" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropSubqueries" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropSupportedTxnDdl" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxSubqueries" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropSupportedTxnIsoLevels" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropSupportedTxnIsoRetain" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropTableTerm" type="xsd:string" minOccurs="0" />
       <xsd:element name="MdpropAggregateCellUpdate" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropAxes" type="xsd:integer" minOccurs="0" />
       <xsd:element name="MdpropFlatteningSupport"  minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="3" />
             <xsd:enumeration value="4" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropMdxCaseSupport" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxDescFlags" type="xsd:integer" minOccurs="0" />
       <xsd:element name="MdpropMdxDrillFunctions" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxFormulas" type="xsd:integer" minOccurs="0" />
       <xsd:element name="MdpropMdxJoinCubes" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxMemberFunctions" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxNonMeasureExpressions" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer">
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropMdxNumericFunctions" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxObjQualification" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxOuterReference" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxQueryByProperty" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxRangeRowset" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="4" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropMdxSetFunctions" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="MdpropMdxSlicer" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropMdxStringCompop" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="MdpropNamedLevels" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropMsmdMDXCompatibility" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="3" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdSQLCompatibility" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropMsmdMDXUniqueNameStyle" type="xsd:integer"
                  minOccurs="0"/>
       <xsd:element name="DbpropMsmdCachePolicy" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="DbpropMsmdCacheRatio" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="DbpropMsmdCacheMode" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="DbpropMsmdCompareCaseSensitiveStringFlags"
                    minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="16" />
             <xsd:enumeration value="256" />
             <xsd:enumeration value="4096" />
             <xsd:enumeration value="65536" />
             <xsd:enumeration value="1048576" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdCompareCaseNotSensitiveStringFlags"
                    Type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropMsmdFlattened2" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="DbpropInitMode" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="SspropInitAppName" type="xsd:string" minOccurs="0"/>
       <xsd:element name="SspropInitWsid" type="xsd:string" minOccurs="0" />
       <xsd:element name="SspropInitPacketsize" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="ReadOnlySession" type="xsd:integer" minOccurs="0" />
       <xsd:element name="SecuredCellValue" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="3" />
             <xsd:enumeration value="4" />
             <xsd:enumeration value="5" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="NonEmptyThreshold" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="SafetyOptions" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration  value="0" />
             <xsd:enumeration  value="1" />
             <xsd:enumeration  value="2" />
             <xsd:enumeration  value="3" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdCacheRatio2" type="xsd:double"
                    minOccurs="0"/>
       <xsd:element name="DbpropMsmdUseFormulaCache" type="xsd:string"
                    minOccurs="0"/>
       <xsd:element name="DbpropMsmdDynamicDebugLimit" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="DbpropMsmdDebugMode" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Dialect" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="MDX" />
             <xsd:enumeration value="DMX" />
             <xsd:enumeration value="SQL" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ImpactAnalysis" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="SQLQueryMode" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Data" />
             <xsd:enumeration value="Calculated" />
             <xsd:enumeration value="IncludeEmpty" />
             <xsd:enumeration value="DataKeys" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="ClientProcessID" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="Cube" type="xsd:string" minOccurs="0" />
       <xsd:element name="ReturnCellProperties" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="CommitTimeout" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="ForceCommitTimeout" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="ExecutionMode" type="xsd:string" minOccurs="0"/>
       <xsd:element name="RealTimeOlap" type="xsd:boolean" minOccurs="0" />
       <xsd:element name="MdxMissingMemberMode" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Default" />
             <xsd:enumeration value="Ignore" />
             <xsd:enumeration value="Error" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MdpropMdxNamedSets" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="DbpropMsmdSubqueries" minOccurs="0" >
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdAutoExists" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
             <xsd:enumeration value="3" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="CustomData" type="xsd:string" minOccurs="0"/>
       <xsd:element name="DisablePrefetchFacts" type="xsd:boolean"
                    minOccurs="0" />
       <xsd:element name="UpdateIsolationLevel" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="1" />
             <xsd:enumeration value="2" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdErrorMessageMode" type="xsd:integer"
                    minOccurs="0"/>
       <xsd:element name="MdpropMdxDdlExtensions" type="xsd:integer"
                    minOccurs="0" />
       <xsd:element name="ResponseEncoding" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Default" />
             <xsd:enumeration value="UTF-8" />
             <xsd:enumeration value="UTF-16" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="MemoryLockingMode" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:integer" >
             <xsd:enumeration value="0" />
             <xsd:enumeration value="1" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DbpropMsmdOptimizeResponse" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="DbpropMsmdActivityID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="DbpropMsmdRequestID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="ReturnAffectedObjects" type="xsd:integer" minOccurs="0" />
       <xsd:element name="DbpropMsmdRequestMemoryLimit" type="xsd:integer" minOccurs="0" />
       <xsd:element name="ApplicationContext" type="xsd:string" minOccurs="0" />
     </xsd:all>
  </xsd:complexType>

Name	Usage	Default value	Description
DataSourceInfo	Read/Write	Empty	Contains the information, such as the instance name, that is required to connect to the data source.
LocaleIdentifier	Read/Write		An integer that represents an LCID. This property represents the LCID that is currently in effect.
Timeout	Read/Write	0	An integer value that specifies, in seconds, the maximum time that the server is to wait for a request to be successful before returning an error.
UserName	Read		The user name.
Catalog	Read/Write		The current database for the session.
Password	Write		The password for the session.
StateSupport	Read	"Sessions"	Reserved for future use.
Content	Write	"SchemaData"	An enumeration value that determines the type of data that is returned from the Discover and Execute methods. This property can have one of the following values: None - Allows the structure of the command to be verified but not run. Schema - Returns the XML schema that relates to the requested command. The XML schema indicates columns and other information. Data - Returns only the data that was requested. SchemaData - Returns the schema information and the data. Metadata - Includes the schema plus the OlapInfo result section for results that use the mddataset return type. See section 2.2.4.1.1.1 for the definition of the OlapInfo type and section 2.2.4.1.1 for the definition of the mddataset type.
Format	Write	"Native"	An enumeration value that determines the type of result set that is returned from the Execute method. This property can have one of the following values: Tabular - Returns a result set using the Rowset data type. See section 2.2.4.1.3 for the definition of the Rowset type. Multidimensional - Returns a rowset using the mddataset data type. See section 2.2.4.1.1 for the definition of the mddataset type. Native - No format is explicitly specified.
AxisFormat	Write	"TupleFormat"	An enumeration value that determines the format used within an mddataset result set to describe the axes of the multidimensional dataset. This property can have one of the following values: ClusterFormat - The mddataset axis is made up of one or more CrossProduct elements. CustomFormat - A vendor can use this value to indicate a vendor-specific format. TupleFormat - The mddataset axis contains one or more Tuple elements.<122>
BeginRange	Write	-1	Contains a zero-based integer value corresponding to a CellOrdinal attribute value, which indicates the beginning of the range of cells to include in the result. The CellOrdinal attribute is part of the Cell element in the CellData section of mddataset.
EndRange	Write	-1	Specifies a zero-based integer value corresponding to a CellOrdinal attribute value, indicating the end of the range of cells to include in the result. The CellOrdinal attribute is part of the Cell element in the CellData section of mddataset.
ProviderName	Read		This property is equivalent to the DBPROP_PROVIDERFRIENDLYNAME OLE DB property. Indicates the name of the provider.
ProviderVersion	Read		This property is equivalent to the DBPROP_PROVIDERVER OLE DB property. Indicates the version of the provider.
DBMSVersion	Read		This property is equivalent to the DBPROP_DBMSVER OLE DB property. Indicates the server version number.
ProviderType	Read	6	This property is equivalent to the DBPROP_DATASOURCE_TYPE OLE DB property. This property can have one of the following values or a combination of the following values: DBPROPVAL_DST_TDP(0x00000001L) - The provider is a tabular data provider (TDP). DBPROPVAL_DST_MDP(0x00000002L) - The provider is a multidimensional provider (MDP). DBPROPVAL_DST_TDPANDMDP(0x00000003L) - The provider is both a TDP and an MDP. DBPROPVAL_DST_DOCSOURCE(0x00000004L) - The provider supports direct URL binding and is a document source provider.<123>
ShowHiddenCubes	Read/Write		This property is reserved for future use.
SQLSupport	Read	512 (DBPROPVAL_SQL_SUBMINIMUM)	This property is equivalent to the DBPROP_SQLSUPPORT OLE DB property which is a bitmask displaying the level of support for the SQL language. This property can have a combination of zero or more of the following values: DBPROPVAL_SQL_NONE (0x00000000L) - SQL is not supported. DBPROPVAL_SQL_ODBC_MINIMUM (0x00000001L) DBPROPVAL_SQL_ODBC_CORE (0x00000002L) DBPROPVAL_SQL_ODBC_EXTENDED (0x00000004L) - These levels correspond to the levels of SQL conformance defined in ODBC version 2.5. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels. DBPROPVAL_SQL_ESCAPECLAUSES (0x00000100L) - The provider supports the ODBC escape clause syntax. DBPROPVAL_SQL_ANSI92_ENTRY (0x00000010L) DBPROPVAL_SQL_FIPS_TRANSITIONAL (0x00000020L) DBPROPVAL_SQL_ANSI92_INTERMEDIATE (0x00000040L) DBPROPVAL_SQL_ANSI92_FULL (0x00000080L) - These levels correspond to the levels in ANSI SQL-92. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels. DBPROPVAL_SQL_ANSI89_IEF (0x00000008L) - The provider supports the ANSI89 Integrity Enhancement Facility. DBPROPVAL_SQL_SUBMINIMUM (0x00000200L) - The provider supports the DBGUID_SQL dialect and parses the command text according to SQL rules but does not support either the minimum ODBC level or the ANSI SQL-92 Entry level. This level is not cumulative; providers that support at least the minimal ODBC Level or ANSI SQL-92 Entry Level do not set this bit.<124>
TransactionDDL	Read		Reserved for future use.
MaximumRows	Write		Reserved for future use.
Roles	Read/Write		Specifies a comma-delimited string of the role names for this request.
VisualMode	Write	0	This property is equivalent to the MDPROP_VISUALMODE OLE DB property. Indicates whether the provider is to calculate visual totals, which dynamically totals child members of parent members specified in a set. This property can have one of the following values: MDPROPVAL_VISUAL_MODE_DEFAULT (0) - Default mode for a server; each server can define this for their server. MDPROPVAL_VISUAL_MODE_VISUAL (1) - Visual totals on. MDPROPVAL_VISUAL_MODE_VISUALOFF (2) - Visual totals off.
EffectiveRoles	Write		Reserved for future use.
EffectiveUserName	Write		Specifies the name of an account to use to override the user name when connecting to the server.
ServerName	Read		Indicates the name of the server.
CatalogLocation	Read		An integer enumeration value that is equivalent to the DBPROP_CATALOGLOCATION OLE DB property and which identifies where the catalog name appears within a text string that represents a fully qualified name. This property can be one of the following values: DBPROPVAL_CL_START (0x00000001L) - The catalog name is at the start of the fully qualified name. DBPROPVAL_CL_END (0x00000002L) - The catalog name is at the end of the fully qualified name.<125>
DbpropCatalogTerm	Read		This string property is equivalent to the DBPROP_CATALOGTERM OLE DB property which lists the term that the server uses to describe a catalog.<126>
DbpropCatalogUsage	Read		This property is equivalent to the DBPROP_CATALOGUSAGE OLE DB property. A bitmask that specifies how catalog names can be used in text commands. This property can have a combination of zero or more of the following values: DBPROPVAL_CU_DML_STATEMENTS(0x00000001L) - Catalog names are supported in all data manipulation language (DML) statements. DBPROPVAL_CU_TABLE_DEFINITION(0x00000002L) - Catalog names are supported in all table definition statements. DBPROPVAL_CU_INDEX_DEFINITION(0x00000004L) - Catalog names are supported in all index definition statements and can apply only to the table name, not the index name, depending on the SQL implementation. DBPROPVAL_CU_PRIVILEGE_DEFINITION(0x00000008L) - Catalog names are supported in all privilege definition statements.<127>
DbpropColumnDefinition	Read		This property is equivalent to the DBPROP_COLUMNDEFINITION OLE DB property. A bitmask defining the valid clauses for the definition of a column. This property can have a combination of zero or more of the following values: DBPROPVAL_CD_NOTNULL (0x00000001L) Columns can be created non-nullable.<128>
DbpropConcatNullBehavior	Read		This property is equivalent to the DBPROP_CONCATNULLBEHAVIOR OLE DB property. An enumeration value that indicates how the data source object handles the concatenation of NULL-valued character data type columns with non–NULL-valued character data type columns. This property can have one of the following values: DBPROPVAL_CB_NULL (1) - The result is NULL-valued. DBPROPVAL_CB_NON_NULL (2) - The result is the concatenation of the non–NULL-valued column or columns.<129>
DbpropDataSourceReadOnly	Read		A Boolean that is equivalent to the DBPROP_DATASOURCEREADONLY OLE DB property. When true, indicates that the data store is read-only; otherwise, false.<130>
DbpropGroupBy	Read		This property is equivalent to the OLE DB property DBPROP_GROUPBY. A partial bitmask that indicates the relationship between the columns in a GROUP BY clause and the non-aggregated columns in the select list. The first value in the following list can be used in an OR operation with any of the other values in the list: DBPROPVAL_GB_COLLATE(0x00000010L) - A COLLATE clause can be specified at the end of each grouping column. DBPROPVAL_GB_EQUALS_SELECT(0x00000002L) - The GROUP BY clause MUST contain all nonaggregated columns in the select list. It cannot contain any other columns. DBPROPVAL_GB_CONTAINS_SELECT(0x00000004L) - The GROUP BY clause MUST contain all nonaggregated columns in the select list. It can contain columns that are not in the select list. DBPROPVAL_GB_NO_RELATION(0x00000008L) - The columns in the GROUP BY clause and the select list are not related.<131>
DbpropHeterogeneousTables	Read		This property is equivalent to the OLE DB property DBPROP_HETEROGENEOUSTABLES. A bitmask that specifies whether the provider can join tables from different catalogs or providers. This property can be a combination of zero or more of the following values: DBPROPVAL_HT_DIFFERENT_CATALOGS(0x00000001L) DBPROPVAL_HT_DIFFERENT_PROVIDERS(0x00000002L)<132>
DbpropIdentifierCase	Read	8	This property is equivalent to the OLE DB property DBPROP_IDENTIFIERCASE. A bitmask that indicates how identifiers treat case in data definition commands or interfaces. This property can have one of the following values: DBPROPVAL_IC_UPPER(0x00000001L) - Identifiers in SQL are case-insensitive and are stored in uppercase. DBPROPVAL_IC_LOWER(0x00000002L) - Identifiers in SQL are case-insensitive and are stored in lowercase. DBPROPVAL_IC_SENSITIVE(0x00000004L) - Identifiers in SQL are case-sensitive and are stored in mixed case. DBPROPVAL_IC_MIXED(0x00000008L) - Identifiers in SQL are case-insensitive and are stored in mixed case.<133>
DbpropMaxIndexSize	Read		This property is equivalent to the OLE DB property DBPROP_MAXINDEXSIZE. Indicates the maximum number of bytes allowed in the combined columns of an index. If there is no specified limit or the limit is unknown, this value is set to zero.<134>
DbpropMaxOpenChapters	Read		This integer property is equivalent to the OLE DB property DBPROP_MAXOPENCHAPTERS. If a chapter is released before a new chapter can be opened, this value is "1"; if the provider has no limit on the number of open chapters or does not support chapters, this value is "0".<135>
DbpropMaxRowSize	Read		This integer property is equivalent to the OLE DB property DBPROP_MAXROWSIZE. Indicates the maximum length of a single row in a table. If there is no specified limit or the limit is unknown, this value is set to zero.<136>
DbpropMaxRowSizeIncludeBlob	Read		This property is equivalent to the OLE DB property DBPROP_MAXROWSIZEINCLUDESBLOB. A Boolean that, when true, indicates that the maximum row size includes any blob present in the row; otherwise, false.<137>
DbpropMaxTablesInSelect	Read		This integer property is equivalent to the OLE DB property DBPROP_MAXTABLESINSELECT. Indicates the maximum number of tables allowed in the FROM clause of a SELECT statement. If there is no specified limit or the limit is unknown, this value is set to zero.<138>
DbpropMultiTableUpdate	Read		This Boolean property is equivalent to the OLE DB property DBPROP_MULTITABLEUPDATE. When true, indicates that the provider can do a multitable update; otherwise, false.<139>
DbpropNullCollation	Read		This enumeration value is equivalent to the OLE DB property DBPROP_NULLCOLLATION. Indicates where NULLs are sorted in a list. This property can have one of the following values: DBPROPVAL_NC_END(0x00000001L) - NULLs are sorted at the end of the list, regardless of the sort order. DBPROPVAL_NC_HIGH(0x00000002L) - NULLs are sorted at the high end of the list. DBPROPVAL_NC_LOW(0x00000004L) - NULLs are sorted at the low end of the list. DBPROPVAL_NC_START(0x00000008L) - NULLs are sorted at the start of the list, regardless of the sort order.<140>
DbpropOrderByColumnsInSelect	Read		This Boolean property is equivalent to the OLE DB property DBPROP_ORDERBYCOLUMNSINSELECT. When true, orders by columns in the select list; otherwise, false.<141>
DbpropOutputParameterAvailable	Read		This property is equivalent to the OLE DB property DBPROP_OUTPUTPARAMETERAVAILABILITY. It is an integer enumeration that indicates the time at which output parameter values become available. This property can have one of the following values: DBPROPVAL_OA_NOTSUPPORTED(0x00000001L) - Output parameters are not supported. DBPROPVAL_OA_ATEXECUTE(0x00000002L) - Output parameter data is available immediately after a command is executed. DBPROPVAL_OA_ATROWRELEASE(0x00000004L) - If a command returns a single result that is a rowset, output parameter data is available at the time the rowset is completely released. If a command returns multiple results, output parameter data is available when a multiple results object is completely released, whichever occurs first.<142>
DbpropPersistentIdType	Read		This property is equivalent to the OLE DB property DBPROP_PERSISTENTIDTYPE. An integer specifying the type of DBID that the provider uses when persisting DBIDs that name entities in the data store, such as tables, indexes, columns, commands, or constraints. This is generally the type of DBID that the provider considers the most permanent under schema changes and physical data reorganizations. This property can have one of the following values: DBPROPVAL_PT_NAME(0x0000004L) DBPROPVAL_PT_PROPID(0x0000010L) DBPROPVAL_PT_GUID(0x0000008L) DBPROPVAL_PT_GUID_NAME(0x0000001L) DBPROPVAL_PT_GUID_PROPID(0x0000002L) DBPROPVAL_PT_PGUID_NAME(0x0000020L) DBPROPVAL_PT_PGUID_PROPID(0x0000040L)<143>
DbpropPrepareAbortBehavior	Read		This enumeration value is equivalent to the OLE DB property DBPROP_PREPAREABORTBEHAVIOR. It indicates how aborting a transaction affects prepared commands. This property can have one of the following values: DBPROPVAL_CB_DELETE(0x00000002L) - Aborting a transaction deletes prepared commands. The application MUST re-prepare commands before executing them. DBPROPAL_CB_PRESERVE(0x00000001L) - Aborting a transaction preserves prepared commands. The application can re-execute commands without re-preparing them.<144>
DbpropPrepareCommitBehavior	Read		This integer enumeration value is equivalent to the OLE DB property DBPROP_PREPARECOMMITBEHAVIOR. It indicates how committing a transaction affects prepared commands. This property can have one of the following values: DBPROPVAL_CB_DELETE(0x00000002L) - Aborting a transaction deletes prepared commands. The application MUST re-prepare commands before executing them. DBPROPAL_CB_PRESERVE(0x00000001L) - Aborting a transaction preserves prepared commands. The application can re-execute commands without re-preparing them.<145>
DbpropProcedureTerm	Read		This property is equivalent to the OLE DB property DBPROP_PROCEDURETERM. A character string with the data store vendor's name for a procedure - for example, "database procedure", "stored procedure", or "procedure". This is used for building user interfaces.<146>
DbpropQuotedIdentifierCase	Read		This enumeration value is equivalent to the OLE DB property DBPROP_QUOTEDIDENTIFIERCASE. It indicates how quoted identifiers treat case. This property can have one of the following values: DBPROPVAL_IC_UPPER(0x00000001L) - Quoted identifiers in SQL are case-insensitive and are stored in uppercase in the system catalog. DBPROPVAL_IC_LOWER(0x00000002L) - Quoted identifiers in SQL are case-insensitive and are stored in lowercase in the system catalog. DBPROPVAL_IC_SENSITIVE(0x00000004L) - Quoted identifiers in SQL are case-sensitive and are stored in mixed case in the system catalog. DBPROPVAL_IC_MIXED(0x00000008L) - Quoted identifiers in SQL are case-insensitive and are stored in mixed case in the system catalog.<147>
DbpropSchemaUsage	Read		This property is equivalent to the OLE DB property DBPROP_SCHEMAUSAGE. A bitmask specifying how schema names can be used in text commands. This property can have a combination of zero or more of the following values: DBPROPVAL_SU_DML_STATEMENTS(0x00000001L) - Schema names are supported in all DML statements. DBPROPVAL_SU_TABLE_DEFINITION(0x00000002L) - Schema names are supported in all table definition statements. DBPROPVAL_SU_INDEX_DEFINITION(0x00000004L) - Schema names are supported in all index definition statements and can apply only to the table name, not the index name, depending on the SQL implementation. DBPROPVAL_SU_PRIVILEGE_DEFINITION(0x00000008L) - Schema names are supported in all privilege definition statements.<148>
DbpropSqlSupport	Read	512	This property is equivalent to the OLE DB property DBPROP_SQLSUPPORT. A bitmask specifying the level of support for SQL. This property can have a combination of zero or more of the following values: DBPROPVAL_SQL_NONE(0x00000000L) - SQL is not supported. DBPROPVAL_SQL_ODBC_MINIMUM(0x00000001L) DBPROPVAL_SQL_ODBC_CORE(0x00000002L) DBPROPVAL_SQL_ODBC_EXTENDED(0x00000004L) - These levels correspond to the levels of SQL conformance defined in ODBC version 2.5. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels. For example, if the provider sets the DBPROPVAL_SQL_ODBC_CORE bit, it also sets the DBPROPVAL_SQL_ODBC_MINIMUM bit. DBPROPVAL_SQL_ESCAPECLAUSES(0x00000100L) - The provider supports the ODBC escape clause syntax. DBPROPVAL_SQL_ANSI92_ENTRY(0x00000010L) DBPROPVAL_SQL_FIPS_TRANSITIONAL(0x00000020L) DBPROPVAL_SQL_ANSI92_INTERMEDIATE(0x00000040L) DBPROPVAL_SQL_ANSI92_FULL(0x00000080L) - These levels correspond to the levels in ANSI SQL-92. These levels are cumulative. That is, if the provider supports one level, it also sets the bits for all lower levels. DBPROPVAL_SQL_ANSI89_IEF(0x00000008L) - The provider supports the ANSI89 Integrity Enhancement Facility. DBPROPVAL_SQL_SUBMINIMUM(0x00000200L)- The provider supports the DBGUID_SQL dialect and parses the command text according to SQL rules but does not support either the minimum ODBC level or the ANSI SQL-92 entry level. This level is not cumulative; providers that support at least the minimal ODBC Level or ANSI SQL-92 entry level do not set this bit. OLE DB consumers can determine whether the provider supports the DBGUID_SQL dialect by verifying that the DBPROPVAL_SQL_NONE bit is not set.<149>
DbpropSubqueries	Read	0	This property is equivalent to the OLE DB property DBPROP_SUBQUERIES. A bitmask specifying the predicates in text commands that support subqueries. This property can have a combination of zero or more of the following values: DBPROPVAL_SQ_CORRELATEDSUBQUERIES(0x00000001L) DBPROPVAL_SQ_COMPARISON(0x00000002L) DBPROPVAL_SQ_EXISTS(0x00000004L) DBPROPVAL_SQ_IN(0x00000008L) DBPROPVAL_SQ_QUANTIFIED(0x00000010L) DBPROPVAL_SQ_TABLE(0x00000020L)<150>
DbpropSupportedTxnDdl	Read		This property is equivalent to the OLE DB property DBPROP_SUPPORTEDTXNDDL. An integer that indicates the relationship of transactions to table and index modification data definition language (DDL) statements. This property can have one of the following values: DBPROPVAL_TC_NONE(0x00000000L) - Transactions are not supported. DBPROPVAL_TC_DML(0x00000001L) - Transactions can contain only DML statements. Attempting to modify tables or indexes within a transaction causes an error. DBPROPVAL_TC_DDL_COMMIT(0x00000002L) - Transactions can contain only DML statements. Modifying tables or indexes within a transaction causes the transaction to be committed. The provider's commit mode remains unchanged in accordance with the value of DBPROP_COMMITPRESERVE. If the provider was in auto-commit mode, it remains in auto-commit mode. The same is true for manual-commit mode. DBPROPVAL_TC_DDL_IGNORE(0x00000004L) - Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored.<151>
DbpropSupportedTxnIsoLevels	Read		This property is equivalent to the OLE DB property DBPROP_SUPPORTEDTXNISOLEVELS. A bitmask specifying the supported transaction isolation levels. This property can have a combination of zero or more of the following values: DBPROPVAL_TI_CHAOS(0x00000010L) DBPROPVAL_TI_READUNCOMMITTED or DBPROPVAL_TI_BROWSE(0x00000100L) DBPROPVAL_TI_CURSORSTABILITY or DBPROPVAL_TI_READCOMMITTED(0x00001000L) DBPROPVAL_TI_REPEATABLEREAD(0x00010000L) DBPROPVAL_TI_SERIALIZABLE or DBPROPVAL_TI_ISOLATED(0x00100000L)<152>
DbpropSupportedTxnIsoRetain	Read	292	This property is equivalent to the OLE DB property DBPROP_SUPPORTEDTXNISORETAIN. A bitmask specifying the supported transaction isolation retention levels. This property can have a combination of zero or more of the following values: DBPROPVAL_TR_COMMIT_DC(0x00000001L) - The transaction can either preserve or dispose of isolation context across a retaining commit. DBPROPVAL_TR_COMMIT(0x00000002L) - The transaction preserves its isolation context (that is, it preserves its locks, if that is how isolation is implemented) across a retaining commit. DBPROPVAL_TR_COMMIT_NO(0x00000004L) - The transaction is explicitly not to preserve isolation across a retaining commit. DBPROPVAL_TR_ABORT_DC(0x00000008L) - The transaction can either preserve or dispose of isolation context across a retaining abort. DBPROPVAL_TR_ABORT(0x00000010L) - The transaction preserves its isolation context across a retaining abort. DBPROPVAL_TR_ABORT_NO(0x00000020L) - The transaction is explicitly not to preserve isolation across a retaining abort. DBPROPVAL_TR_DONTCARE (0x00000040L) - The transaction can preserve or dispose of isolation context across a retaining commit or abort. DBPROPVAL_TR_BOTH(0x00000080L) - Isolation is preserved across both a retaining commit and a retaining abort. DBPROPVAL_TR_NONE(0x00000100L) - Isolation is explicitly not to be retained across either a retaining commit or a retaining abort. DBPROPVAL_TR_OPTIMISTIC(0x00000200L) - Optimistic concurrency control is used. When this value is specified, and then whatever isolation technology is in place (such as locking), it MUST be the case that other transactions' ability to make changes to the data and resources manipulated by this transaction is not in any way affected by the data read or updated by this transaction. That is, optimistic control is used for all data in the transaction.<153>
DbpropTableTerm	Read		This property is equivalent to the OLE DB property DBPROP_TABLETERM. A string value that indicates the name the data source object uses for a table - for example, "table" or "file". This property is used for building user interfaces.<154>
MdpropAggregateCellUpdate <155>	Read		This property is equivalent to the OLE DB property MDPROP_AGGREGATECELL_UPDATE. An integer enumeration value that indicates support for updating aggregated cells. This property can have one of the following values: MDPROPVAL_AU_UNSUPPORTED(0x00000000L) - The provider does not support updating nonatomic cells. MDPROPVAL_AU_UNCHANGED(0x00000001L) - The provider supports updating of aggregated cells, but the value of cells beneath an aggregated cell remains unchanged. MDPROPVAL_AU_UNKNOWN(0x00000002L) - The provider supports updating of aggregated cells, and the value of cells beneath an aggregated cell remains undefined.
MdpropAxes	Read		This property is equivalent to the OLE DB property MDPROP_AXES. This is an OLE DB for OLAP property. The value of this property is the maximum number of axes that the provider supports in the dataset. To be compliant with OLE DB for OLAP, this value MUST be at least 3.<156>
MdpropFlatteningSupport	Read		This property is equivalent to the OLE DB property MDPROP_FLATTENING_SUPPORT. An integer that indicates if a provider supports flattening, and if so, of what type. This property can have one of the following values: MDPROPVAL_FS_FULL_SUPPORT(0x00000001L) - The provider supports flattening as described in [MSDN-FDPR]. MDPROPVAL_FS_GENERATED_COLUMN(0x00000002L) - The provider supports flattening by using dummy names, as described in [MSDN-SLNL]. MDPROPVAL_FS_GENERATED_DIMENSION(0x00000003L) - The provider supports flattening by generating one column per dimension, as described in [MSDN-SLNL]. MDPROPVAL_FS_NO_SUPPORT(0x00000004L) - The provider does not support flattening.<157>
MdpropMdxCaseSupport	Read		This property is equivalent to the OLE DB property MDPROP_MDX_CASESUPPORT. A bitmask that represents the type of CASE statement in MDX that the provider supports. This property can have one of the following values: MDPROPVAL_MC_SINGLECASE(0x00000001L) - The provider supports a simple case expression. MDPROPVAL_MC_SEARCHEDCASE(0x00000002L) - The provider supports a searched case expression.<158>
MdpropMdxDescFlags	Read		This property is equivalent to the OLE DB property MDPROP_MDX_DESCFLAGS. It is a bitmask that indicates which desc flag values in the DESCENDANTS MDX function are supported by the provider. This property can have a combination of zero or more of the following values: MDPROPVAL_MD_BEFORE (0x00000002L) - The provider supports the flag BEFORE. MDPROPVAL_MD_AFTER(0x00000004L) - The provider supports the flag AFTER. MDPROPVAL_MD_SELF(0x00000001L) - The provider supports the flag SELF. This bit MUST be set by all providers because support for SELF is mandatory.<159>
MdpropMdxDrillFunctions	Read		A bitmask indicating support for drilldown and drillup groups of functions. These functions indicate provider support for drilldown and drillup on tuples as well as members. This property is a combination of zero or more of the following values: MDPROPVAL_MDF_BASIC(0x01) - The support operation for the drilldown and drillup groups of functions on members. MDPROPVAL_MDF_ASYMMETRIC(0x02) - The support operation for the drilldown and drillup groups of functions on tuples as well as members.<160> MDPROPVAL_MDF_CALC_MEMBERS(0x04) - The support operation for the drilldown and drillup groups of functions returning child calculated members.<161><162>
MdpropMdxFormulas	Read	63	This property is equivalent to the OLE DB property MDPROP_MDX_FORMULAS. A bitmask that indicates what support the provider has for the creation of named sets and calculated members. This property can have a combination of zero or more of the following values: MDPROPVAL_MF_WITH_CALCMEMBERS(0x00000001L) - The provider supports the creation of calculated members by using the WITH clause before a SELECT. MDPROPVAL_MF_WITH_NAMEDSETS(0x00000002L) - The provider supports the creation of named sets by using the WITH clause before a SELECT. MDPROPVAL_MF_CREATE_CALCMEMBERS(0x00000004L) - The provider supports the creation of named calculated members by using the CREATE clause. MDPROPVAL_MF_CREATE_NAMEDSETS(0x00000008L) - The provider supports the creation of named sets by using the CREATE clause. MDPROPVAL_MF_SCOPE_SESSION(0x00000010L) - The provider supports the scope value of SESSION during the creation of named sets and calculated members. MDPROPVAL_MF_SCOPE_GLOBAL(0x00000020L) - The provider supports the scope value of GLOBAL during the creation of named sets and calculated members.<163>
MdpropMdxJoinCubes	Read	1	This property is equivalent to the OLE DB property MDPROP_MDX_JOINCUBES. A bitmask that indicates what support the provider has for queries joining multiple cubes. This property can have a combination of zero or more of the following values: MDPROPVAL_MJC_IMPLICITCUBE(0x00000004L) - The provider supports an empty FROM clause. The cube is implicitly resolved by the axis and slicer dimensions. MDPROPVAL_MJC_SINGLECUBE(0x00000001) - The provider supports only one cube in the FROM clause of the MDX statement. MDPROPVAL_MJC_MULTICUBES(0x00000002L) - The provider supports more than one cube in the FROM clause of the MDX statement.<164>
MdpropMdxMemberFunctions	Read	15	This property is equivalent to the OLE DB property MDPROP_MDX_MEMBER_FUNCTIONS. A bitmask indicating support for various MDX member functions. This property can have a combination of zero or more of the following values: MDPROPVAL_MMF_COUSIN(0x00000001L) - The provider supports the function COUSIN. MDPROPVAL_MMF_PARALLELPERIOD(0x00000002L) - The provider supports the function PARALLELPERIOD. MDPROPVAL_MMF_OPENINGPERIOD(0x00000004L) - The provider supports the function OPENINGPERIOD. MDPROPVAL_MMF_CLOSINGPERIOD(0x00000008L) - The provider supports the function CLOSINGPERIOD.<165>
MdpropMdxNonMeasureExpressions	Read		This property is equivalent to the OLE DB property MDPROP_MDX_NONMEASURE_EXPRESSIONS. An enumeration value that indicates the capabilities in the numeric_value_expression argument of MDX set functions. This property can have one of the following values: MDPROPVAL_NME_MEASURESONLY(0x00000001L) - The provider supports only expressions involving Measures dimension members. MDPROPVAL_NME_ALLDIMENSIONS(0x00000000L) - The provider supports expressions involving members from any dimension.<166>
MdpropMdxNumericFunctions	Read		This property is equivalent to the OLE DB property MDPROP_MDX_NUMERIC_FUNCTIONS. A bitmask that indicates support for various numeric functions. This property can have a combination of zero or more of the following values: MDPROPVAL_MNF_MEDIAN(0x00000001L) - The provider supports the function MEDIAN. MDPROPVAL_MNF_VAR(0x00000002L) - The provider supports the function VAR. MDPROPVAL_MNF_STDDEV(0x00000004L) - The provider supports the function STDDEV. MDPROPVAL_MNF_RANK(0x00000008L) - The provider supports the function RANK. MDPROPVAL_MNF_AGGREGATE(0x00000010L) - The provider supports the function AGGREGATE. MDPROPVAL_MNF_COVARIANCE(0x00000020L) - The provider supports the function COVARIANCE. MDPROPVAL_MNF_CORRELATION(0x00000040L) - The provider supports the function CORRELATION. MDPROPVAL_MNF_LINREGSLOPE(0x00000080L) - The provider supports the function LINREGSLOPE. MDPROPVAL_MNF_LINREGVARIANCE(0x00000100L) - The provider supports the function LINREGVARIANCE. MDPROPVAL_MNF_LINREGR2(0x00000200L) - The provider supports the function LINREGR2. MDPROPVAL_MNF_LINREGPOINT(0x00000400L) - The provider supports the function LINREGPOINT.<167>
MdpropMdxObjQualification	Read		This property is equivalent to the OLE DB property MDPROP_MDX_OBJQUALIFICATION. This property is a bitmask specifying how multidimensional schema object names can be qualified in an MDX statement. This property can have a combination of zero or more of the following values: MDPROPVAL_MOQ_DATASOURCE_CUBE(0x00000001L) - Cubes can be qualified by the data source name. MDPROPVAL_MOQ_CATALOG_CUBE(0x00000002L) - Cubes can be qualified by the catalog name. MDPROPVAL_MOQ_SCHEMA_CUBE(0x00000004L) - Cubes can be qualified by the schema name. MDPROPVAL_MOQ_CUBE_DIM(0x00000008L) - Dimensions can be qualified by cube name. MDPROPVAL_MOQ_DIM_HIER(0x00000010L) - Hierarchies can be qualified by dimension names. MDPROPVAL_MOQ_DIMHIER_LEVEL(0x00000020L) – Levels can be qualified by the dimension name and/or hierarchy name. This property applies only if named levels are supported, which can be checked by the property. MDPROP_NAMED_LEVELS(0x0000000ffL) - If named levels are not supported, this bit MUST be set. MDPROPVAL_MOQ_DIMHIER_MEMBER(0x00000100L) -Members can be qualified by a dimension name and/or a hierarchy name. MDPROPVAL_MOQ_LEVEL_MEMBER(0x00000040L) - Members can be qualified by a level name. MDPROPVAL_MOQ_MEMBER_MEMBER(0x00000080L) - Members can be qualified by their ancestor names.<168>
MdpropMdxOuterReference	Read		This property is equivalent to the OLE DB property MDPROP_MDX_OUTERREFERENCE. This integer indicates whether <tuple>[.VALUE] can be qualified by <cube_name> in an MDX value expression. 0 means true and 1 means false.<169>
MdpropMdxQueryByProperty	Read	True	This property is equivalent to the OLE DB property MDPROP_MDX_QUERYBYPROPERTY. A Boolean that, when true, indicates that the provider supports for querying by property values in an MDX statement; otherwise, false.<170>
MdpropMdxRangeRowset	Read		This property is equivalent to the OLE DB property MDPROP_MDX_RANGEROWSET. An enumeration value that defines the type of support for cell updates provided by the provider. This property can have one of the following values: MDPROPVAL_RR_NORANGEROWSET(0x00000001L) - The provider does not support a range rowset. MDPROPVAL_RR_READONLY(0x00000002L) - The provider supports a read-only range rowset. MDPROPVAL_RR_UPDATE(0x00000004L) - The provider supports an updatable range rowset.<171>
MdpropMdxSetFunctions	Read		This property is equivalent to the OLE DB property MDPROP_MDX_SET_FUNCTIONS. A bitmask that indicates support for various set functions. This property can have a combination of zero or more of the following values: MDPROPVAL_MSF_TOPPERCENT(0x00000001L) - The provider supports the function TOPPERCENT. MDPROPVAL_MSF_BOTTOMPERCENT(0x00000002L) - The provider supports the function BOTTOMPERCENT. MDPROPVAL_MSF_TOPSUM(0x00000004L) - The provider supports the function TOPSUM. MDPROPVAL_MSF_BOTTOMSUM(0x00000008L) - The provider supports the function BOTTOMSUM. MDPROPVAL_MSF_DRILLDOWNLEVEL(0x00000800L) - The provider supports the function DRILLDOWNLEVEL. MDPROPVAL_MSF_DRILLDOWNMEMBER(0x00000400L) - The provider supports the function DRILLDOWNMEMBER. MDPROPVAL_MSF_DRILLDOWNMEMBERTOP(0x00001000L) - The provider supports the function DRILLDOWNMEMBERTOP. MDPROPVAL_MSF_DRILLDOWNMEMBERBOTTOM(0x00002000L) - The provider supports the function DRILLDOWNMEMBERBOTTOM. MDPROPVAL_MSF_DRILLDOWNLEVELTOP(0x00004000L) - The provider supports the function DRILLDOWNLEVELTOP. MDPROPVAL_MSF_DRILLDOWNLEVELBOTTOM(0x00008000L) - The provider supports the function DRILLDOWNLEVELBOTTOM. MDPROPVAL_MSF_DRILLUPMEMBER(0x00010000L) - The provider supports the function DRILLUPMEMBER. MDPROPVAL_MSF_DRILLUPLEVEL(0x00020000L) - The provider supports the function DRILLUPLEVEL. MDPROPVAL_MSF_PERIODSTODATE(0x00000010L) - The provider supports the function PERIODSTODATE. MDPROPVAL_MSF_LASTPERIODS(0x00000020L) - The provider supports the function LASTPERIODS. MDPROPVAL_MSF_YTD(0x00000040L) - The provider supports the function YTD. MDPROPVAL_MSF_QTD(0x00000080L) - The provider supports the function QTD. MDPROPVAL_MSF_MTD(0x00000100L) - The provider supports the function MTD. MDPROPVAL_MSF_WTD(0x00000200L) - The provider supports the function WTD. MDPROPVAL_MSF_TOGGLEDRILLSTATE (0x00040000) – The provider supports the TOGGLEDRILLSTATE function.<172>
MdpropMdxSlicer	Read		This property is equivalent to the OLE DB property MDPROP_MDX_SLICER. An enumeration value that indicates the capabilities available in the WHERE clause of an MDX statement. This property can have one of the following values: MDPROPVAL_MS_SINGLETUPLE(0x00000002L) - The provider supports only one tuple in the WHERE clause. MDPROPVAL_MS_MULTIPLETUPLES(0x00000001L) - The provider supports more than one tuple in the WHERE clause.<173>
MdpropMdxStringCompop	Read		This property is equivalent to the OLE DB property MDPROP_MDX_STRING_COMPOP. A bitmask that indicates support for string comparison operators other than equals and not-equals operators. This property can have a combination of zero or more of the following values: MDPROPVAL_MSC_LESSTHAN(0x00000001L) - The provider supports the less-than operator. MDPROPVAL_MSC_GREATERTHAN(0x00000002L) - The provider supports the greater-than operator. MDPROPVAL_MSC_LESSTHANEQUAL(0x00000004L) - The provider supports the less-than-or-equal-to operator. MDPROPVAL_MSC_GREATERTHANEQUAL(0x00000008L) - The provider supports the greater-than-or-equal-to operator.<174>
MdpropNamedLevels	Read		This property is equivalent to the OLE DB property MDPROP_NAMED_LEVELS. A bitmask that indicates support for named levels. This property can have a combination of zero or more of the following values: MDPROPVAL_NL_NAMEDLEVELST(0x00000001L) - The provider supports named levels. MDPROPVAL_NL_NUMBEREDLEVELS(0x00000002L) - The provider supports numbered levels using the LEVELS(n) function. MDPROPVAL_NL_SCHEMAONLY(0x00000004L) - The provider supports "dummy" named levels. These level names are for display only and are frequently just provider-generated names for a given level number. These names cannot be used in an MDX statement (such as in <level_name>.MEMBERS). These names appear in the LEVEL_NAME and LEVEL_UNIQUE_NAME columns of the schema rowset; providers can choose to have the same name in both the columns, or they can generate LEVEL_UNIQUE_NAME by appropriately qualifying the LEVEL_NAME. It is provider-specific whether these dummy names also appear in the LEVEL_UNIQUE_NAME column of the MEMBERS and PROPERTIES rowsets.<175>
MDXSupport	Read	Core	An enumeration value that specifies the degree of MDX support. This enumeration has only one value, "Core".<176>
DbpropMsmdMDXCompatibility	Read/Write	0	An enumeration value that determines how placeholder members in a ragged or unbalanced hierarchy are treated. This property can have one of the following values: 0 - This value is equivalent to 1. 1 - Hierarchies in role-playing dimensions receive a caption that includes the dimension name and the hierarchy name. The caption has the following format: [Dimension].[Hierarchy] Placeholder members are exposed. 2 - Hierarchies in role-playing dimensions receive a caption that includes the dimension name and the hierarchy name. The caption has the following format: [Dimension].[Hierarchy] Placeholder members are not exposed. 3 - Placeholder members are not exposed.
DbpropMsmdSQLCompatibility	Read/Write	0	Reserved for future use.
DbpropMsmdMDXUniqueNameStyle	Read/Write	0	A bitmask that determines the algorithm for generating the unique names of members in a dimension. This property can have a combination of zero or more of the following values: 0 - For compatibility with earlier versions of Analysis Services, this value is equivalent to 3. 1 - Uses a key path algorithm that has the following format: [dim].&[key1].&[key2] Note In this algorithm, dim is the name of the dimension, and key1 and key2 are the attribute keys. 2 - Uses a name path algorithm that has the following format: [dim].[name1].&[name2] Note In this algorithm, dim is the name of the dimension, and name1 and name2 are the attribute names. 3 - Uses guaranteed unique names that are stable over time.
DbpropMsmdCachePolicy	Read/Write		Reserved for future use.
DbpropMsmdCacheRatio	Read/Write		Reserved for future use.
DbpropMsmdCacheMode	Read/Write		Reserved for future use.
DbpropMsmdCompareCaseSensitiveStringFlags	Read/Write	1	A bitmask that determines case-sensitive string comparison and sort order functionality. This property controls how comparisons are made in character sets that do not support uppercase and lowercase characters, such as Hindi and Japanese katakana. This property can have a combination of zero or more of the following values: NORM_IGNORECASE(0x00000001) - Case is ignored. NORM_BINARY(0x00000002) - Binary comparison. Characters are compared based on their underlying value in the character set, not on their order in their particular alphabet. NORM_IGNORENONSPACE(0x00000010) - Nonspacing characters are ignored. NORM_IGNORESYMBOLS(0x00000100) - Symbols are ignored. NORM_IGNOREKANATYPE(0x00001000) - No differentiation is made between hiragana and katakana characters. When compared, corresponding hiragana and katakana characters are considered to be equal. NORM_IGNOREWIDTH(0x00010000) - No differentiation is made between single-byte and double-byte versions of the same character. SORT_STRINGSORT(0x00100000) - Punctuation is treated the same as symbols.
DbpropMsmdCompareCaseNotSensitiveStringFlags	Read/Write	69633	A bitmask that determines case-insensitive string comparison and sort order functionality. This property controls how comparisons are made in character sets that do not support uppercase and lowercase characters, such as Hindi and Japanese katakana. This property can have a combination of zero or more of the following values: NORM_IGNORECASE(0x00000001) - Case is ignored. NORM_BINARY(0x00000002) - Binary comparison. Characters are compared based on their underlying value in the character set, not on their order in their particular alphabet. NORM_IGNORENONSPACE(0x00000010) - Nonspacing characters are ignored. NORM_IGNORESYMBOLS(0x00000100) - Symbols are ignored. NORM_IGNOREKANATYPE(0x00001000) - No differentiation is made between hiragana and katakana characters. When compared, corresponding hiragana and katakana characters are considered to be equal. NORM_IGNOREWIDTH(0x00010000) - No differentiation is made between single-byte and double-byte versions of the same character. SORT_STRINGSORT(0x00100000) - Punctuation is treated the same as symbols.
DbpropMsmdFlattened2	Read/Write	False	A Boolean property that, when true, outputs all members of a parent-child hierarchy in a single table column in the flattened result, unless the parent-child hierarchy is requested on Axis 0; otherwise, false. The Level template for output columns is not used.
DbpropInitMode	Read/Write		This property is a bitmask specifying access permissions, and is equivalent to the OLE DB property DBPROP_INIT_MODE. The only supported values for this property are DB_MODE_READWRITE (0x03) and DB_MODE_READ (0x01).<177>
SspropInitAppName	Read/Write		The name of the client application.
SspropInitWsid	Read/Write		The ID of the client workstation.
SspropInitPacketsize	Read/Write		The ID of the client application.
ReadOnlySession	Read/Write		Reserved for future use.
SecuredCellValue	Read/Write	0	An integer enumeration that specifies the error code and the values for the Value and Formatted Value cell properties to be returned when a query tries to access a secured cell. This property can have one of the following values: 0 - this value is the same as 1. 1 - The return Value property of the cell contains the result as a variant data type. The string "#N/A" is returned in the Formatted Value property. 2 - Returns an error in the Cell element for this cell, of the mddataset that is returned. 3 - Returns NULL in both the Value and Formatted Value properties. 4 - Returns a numeric zero (0) in the Value property and returns a formatted zero in the Formatted Value property. For example, 0.00 is returned in the Formatted Value property for a cell whose Format property is "#.##". 5 - Returns the string "#SEC" in both the Value and Formatted Value properties.
NonEmptyThreshold	Read/Write		Reserved for future use.
SafetyOptions	Read/Write	0	An enumeration value that determines whether unsafe libraries can be registered and loaded by client applications. This property can have one of the following values: DBPROPVAL_MSMD_SAFETY_OPTIONS_DEFAULT(0)- This value is treated as DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_SAFE. DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_ALL(1) -This value enables all user-defined function libraries without verifying that they are safe for initialization and scripting. DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_SAFE(2) -This value makes sure that all classes for a particular user-defined function library are checked to make sure that they are safe for initialization and scripting. DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_NONE(3) - This value prevents user-defined functions from being used during the session.
DbpropMsmdCacheRatio2	Read/Write		Reserved for future use.
DbpropMsmdUseFormulaCache	Read/Write		Reserved for future use.
DbpropMsmdDynamicDebugLimit	Read/Write		Reserved for future use.
DbpropMsmdDebugMode	Read/Write		Reserved for future use.
Dialect	Read/Write		A server SHOULD <178> attempt to deduce the command dialect from the content of the statement element. The dialect property establishes the dialect used in the following situations: The dialect that the provider will use the first time that the provider tries to run a query. The dialect used to return execution errors as the result of query failures. The dialect that is used when it is ambiguous as to what dialect was used in the query. If the Dialect property is not set, query execution returns errors in the dialect last used. The value of the Dialect property identifies the language used for expressing the statement. The value can be one of the following: MDX DMX SQL
ImpactAnalysis	Write	False	When this Boolean is set to true, commands CREATE, ALTER, DELETE, and PROCESS will return a rowset that lists the objects that would be impacted if the command were executed; otherwise, false.
SQLQueryMode	Read/Write	"Calculated"	An enumeration value that modifies the behavior of calculations which are included in SQL queries. This property can have one of the following values: Data - No calculations are included. Calculated - Calculations are returned. IncludeEmpty - Calculations and empty rows are returned. DataKeys - No calculations are included, and keys associated with columns instead of the key captions for the columns are returned.
ClientProcessID	Read/Write	0	The ID of the client process.
Cube	Write	Empty	The name of the cube that sets the context for the command. If the command itself contains a cube name, such as within the FROM clause of an MDX SELECT statement, the setting of this property is ignored.
ReturnCellProperties	Read/Write	False	A Boolean that, when true, indicates that cell properties are to be returned in query results; otherwise, false.
CommitTimeout	Write	0	An integer that determines how long, in seconds, the commit phase of a command waits for locks before rolling back. A value of zero (0) indicates that the instance waits indefinitely.
ForceCommitTimeout	Write	0	An integer that determines for how long, in seconds, the commit phase of a command waits before forcing previously issued commands to roll back. A value of zero (0) indicates that the instance waits indefinitely.
ExecutionMode	Write	"Execute"	Reserved for future use.
RealTimeOlap	Read/Write	False	A Boolean that, when set to true, indicates that all of the partitions that are listening for table notifications are queried in real time, bypassing caching; otherwise, false.
MdxMissingMemberMode	Write	"Default"	Indicates how missing members are handled in MDX statements. This property can have one of the following values: Default -Default behavior of the server. Error - Generate an error. Ignore - Always ignore missing members.
CustomData	Write	Empty	A string value that defines a value that will be returned by the customdata() MDX function.
MdpropMdxSubqueries	Read		A bitmask that indicates the level of support for subqueries in MDX. This property can have a combination of zero or more of the following values:<179> MDPROPVAL_MSQ_BASIC (0x01) – Supports subselects without arbitrary shapes. MDPROPVAL_MSQ_ARBITRARYSHAPE (0x02) - Supports subselects with arbitrary shapes. MDPROPVAL_MSQ_NONVISUAL (0x04) - Supports subselects with NON VISUAL keyword. MDPROPVAL_MSQ_CALCMEMBERS (0x08) - Supports calc members in subselects. This option does not allow use of arbitrary shapes in a subselect.<180> MDPROPVAL_MSQ_CALCMEMBERS2 (0x10) - Supports calc members in subselects. This option includes support for arbitrary shapes in a subselect.<181> MDPROPVAL_MSQ_DRILLTHROUGH (0x20) - Supports drillthrough, which provides additional details regarding a calculation.<182>
DbpropMsmdErrorMessageMode	Write	2	If a cell security MDX expression does not return true or false, but in fact itself returns an error, the integer this property is set to controls what happens. If set to "2", the result returns the error message associated with the error that the evaluation of the cell security expression returns. If this property is set to any other value, the result is treated the same as if the cell security expression evaluated to false, and access to the cell data is denied. This property will be recognized only for administrator connections.
DisablePrefetchFacts	Read/Write	False	A Boolean that, when true, indicates to the server that it is to disable the prefetching of fact data when executing MDX queries; otherwise, false. By default, the server does prefetch fact data, so the default value for this property, false, leaves the server default in effect.
UpdateIsolationLevel	Read/Write	2	An enumeration value that specifies whether the cells in a single UPDATE CUBE are isolated from each other. When the property is set to isolated, the server evaluates each cell update without any consideration for the others, resulting in better performance. This property is a performance hint and is to be used with care. Specifying the property as isolated when the cells actually overlap can produce incorrect results. This property can have one of the following values: 1 – Isolated 2 – Not isolated
MdpropMdxNamedSets	Read	15	A bitmask that indicates the type of support for named sets. This property can be a combination of zero or more of the following values: MDPROPVAL_MNS_BASIC (0x01) – Supports static named sets. MDPROPVAL_MNS_DYNAMIC (0x02) – Supports dynamic named sets. MDPROPVAL_MNS_DISPLAYFOLDER (0x04) – Supports specifying a display folder in a named set. MDPROPVAL_MNS_CAPTION (0x08) – Supports specifying a caption in a named set.
DbpropMsmdSubqueries	Read/Write	0	An enumeration value that determines the behavior of subqueries. This property can have one of the following values:<183> 0 – Calculated members are not restricted by subselects. 1 – Calculated members are restricted by subselects. This value does not support arbitrary-shaped subselects. 2 – Calculated members are restricted by subselects. This value supports arbitrary-shaped subselects.
DbpropMsmdAutoExists	Read/Write	0	Determines the behavior of autoexists. This property can have one of the following values: 0 – Default value. 1 – Apply deep autoexists for query axes and named sets. Includes WHERE clauses and subselects. 2 – Apply deep autoexists for query axes and exclude named sets from autoexists. Includes WHERE clauses and subselects. 3 – Apply no autoexists for named sets with WHERE clause. Apply shallow autoexists for query axes with WHERE clause. Apply deep autoexists for query axes with subselects and named sets with subselects.
MdpropMdxDdlExtensions <184>	Read		A bitmask that indicates one or more of the following:<185> DBPROPVAL_MDX_DDL_CREATECUBE (0x1). Create Cube is supported. DBPROPVAL_MDX_DDL_INSERTINTO (0x2). InsertInto is supported. DBPROPVAL_MDX_DDL_REFRESHCUBE (0x4). Refresh Cube is supported. DBPROPVAL_MDX_DLL_CREATESESSIONCUBE (0x8). Create Session is supported. DBPROPVAL_MDX_DLL_CREATEGLOBALCUBE (0x10). Create Global Cube is supported.
ResponseEncoding <186>	Read/Write	"Default"	Specifies the character encoding to use for the server response to a client request.
MemoryLockingMode <187>	Read		The server is able to achieve higher performance if it locks memory. However, users might not have permissions to lock memory. In this case, the server executes in a lower-performance, non-locking, mode. This integer indicates which mode is active: 0 – Low performance (non-locking) 1 – High performance (locking)
DbpropMsmdOptimizeResponse <188>	Read/Write	0	A bitmask that indicates which of the following query response optimizations are enabled. (0x01) – AXIS_NORMALIZATION – Use the msxmla:NormTupleSet complex type specified in section 2.2.4.1.1.2.1.1.6. (0x02) – EMPTYSLICERAXIS – The slicer axis in query responses does not contain information. (0x04) – BINARY_DATASET – Use the msxmla:NormAxis or the xmla-ds:CellSet complex type when applicable for query responses.
DbpropMsmdActivityID	Read/Write		A string value that can be set by a client on a session to trace multiple query requests to the server.<189>
DbpropMsmdRequestID	Read/Write		A string value that can be set by a client on a session to correlate traces from multiple components.<190>
ReturnAffectedObjects	Read/Write		This property controls the result of the commands documented in [MS-SSAS-T]. This property is an integer that can be set to cause the current command to return the affected objects.<191> The possible values are as follows. -1 – This value can be set only when a transaction is active on the current session. The result of the command will contain all the objects that are affected by the command. >= 0 – This value represents the Base Version of the Tabular Metadata. The result will contain all the metadata objects that have been updated or deleted since the transactional state represented by that Version number.
DbpropMsmdRequestMemoryLimit	Read/Write		This property is used to further constrain the memory allowed to be used for a request by the Memory\QueryMemoryLimit server property value (see section 2.2.4.2.2.2.1). The unit of measure is in kilobytes.<192>
ApplicationContext	Read/Write		This property is provided by external applications and is used for end-to-end correlation of user activities.<193>

3.1.4.2.2.1.2.1 PropertyList

Additional resources