Skip to content

mode-element-xmla.md

Latest commit

 

History

History
74 lines (62 loc) · 3.33 KB

mode-element-xmla.md

File metadata and controls

74 lines (62 loc) · 3.33 KB
title Mode Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Mode Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
urn:schemas-microsoft-com:xml-analysis#Mode
microsoft.xml.analysis.mode
helpviewer_keywords
Mode element
ms.assetid 43a54181-6494-48c3-b14b-376d8939fa9f
caps.latest.revision 13
author jeannt
ms.author jeannt
manager erikre

Mode Element (XMLA)

Identifies the mode to be used by the parent Lock element when creating a lock on a specified object.

Syntax

  
<Lock>  
   ...  
   <Mode>...</Mode>  
   ...  
</Lock>

Element Characteristics

Characteristic Description
Data type and length String (enumeration)
Default value None
Cardinality 1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element
Parent elements Lock, Unlock
Child elements None

Remarks

The parent Lock element uses the Mode element to determine the type of lock to create on an object. The value of this element is limited to one of the strings listed in the following table.

Value Description
CommitShared A shared lock is established on the specified object. Other shared locks can be created for the same object.

A shared lock prevents transactions containing write operations, such as an Execute method call running an Alter command, on a specified object, from committing until the shared lock is removed. A shared lock does not prevent transactions containing read operations, such as a Discover method call or an Execute method call running a Statement command, from committing.
CommitExclusive An exclusive lock is established on the specified object. Other shared or exclusive locks cannot be created for the same object.

An exclusive lock prevents transactions containing either read or write operations on a specified object from committing until the exclusive lock is removed.

See Also

ID Element (XMLA)
Object Element (XMLA)
Properties (XMLA)