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 -->
<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, 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 2005 Analysis Services (SSAS) supports many new XMLA commands. For more information about the XMLA command supported by Analysis Services, see Commands (XMLA).