Command Element (XMLA)
Contains the command to be executed by the Execute method.
Syntax
<Execute>
...
<Command>
<Alter>...</Alter>
<!-- or -->
<Backup>...</Backup>
<!-- or -->
<Batch>...</Batch>
<!-- or -->
<BeginTransaction>...</BeginTransaction>
<!-- or -->
<Cancel>...</Cancel>
<!-- or -->
<ClearCache>...</ClearCache>
<!-- or -->
<CommitTransaction>...</CommitTransaction>
<!-- or -->
<Create>...</Create>
<!-- or -->
<Delete>...</Delete>
<!-- or -->
<DesignAggregations>...</DesignAggregations>
<!-- or -->
<Drop>...</Drop>
<!-- or -->
<Insert>...</Insert>
<!-- or -->
<Lock>...</Lock>
<!-- or -->
<MergePartitions>...</MergePartitions>
<!-- or -->
<NotifyTableChange>...</NotifyTableChange>
<!-- or -->
<Process>...</Process>
<!-- or -->
<Restore>...</Restore>
<!-- or -->
<RollbackTransaction>...</RollbackTransaction>
<!-- or -->
<SetPasswordEncryptionKey>...</SetPasswordEncryptionKey>
<!-- or -->
<Statement>...</Statement>
<!-- or -->
<Subscribe>...</Subscribe>
<!-- or -->
<Synchronize>...</Synchronize>
<!-- or -->
<Unlock>...</Unlock>
<!-- or -->
<Update>...</Update>
<!-- or -->
<UpdateCells>...</UpdateCells>
</Command>
...
</Execute>
Element Characteristics
Characteristic |
Description |
|---|---|
Data type and length |
None |
Default value |
None |
Cardinality |
1-1: Required element that occurs once and only once. |
Element Relationships
Relationship |
Element |
|---|---|
Parent elements |
|
Child elements |
Alter, Backup, Batch, BeginTransaction, Cancel, ClearCache, CommitTransaction, Create, Delete, DesignAggregations, Drop, Insert, Lock, MergePartitions, NotifyTableChange, Process, Restore, RollbackTransaction, SetPasswordEncryptionKey, Statement, Subscribe, Synchronize, Unlock, Update, UpdateCells |
Remarks
The Command element is used by the Execute method to relay commands to a data source. While the XML for Analysis (XMLA) 1.1 Specification supports only the Statement command, Microsoft SQL Server Analysis Services supports many new XMLA commands. For more information about the XMLA command supported by Analysis Services, see Commands (XMLA).