Databases Reference
In-Depth Information
Each
Batch
command contains
Transaction
and
ProcessAffectedObjects
parameters.
The
Transaction
parameter defines how to execute commands contained by the
Batch
command if the user's session did not define a transaction. By default, this property is set
to
TRUE
, which means that all the commands contained in the
Batch
command execute in
a single transaction, and that the results from executing all the commands are committed
only if all the commands execute successfully. In this case, a user gets a response from the
server about successful completion of the batch. The response also contains messages
produced by each individual command during execution.
If at least one command fails, execution of the entire batch stops, and the results of the
commands that succeeded are not committed to the server. In this case, a user gets error
notification that contains error messages from all the commands. The response might look
like the one shown in Listing 26.10, which contains information about execution of the
batch and execution of each individual command.
LISTING 26.10
A Sample Response from a Transactional
Batch
Command
<Envelope>
<Body>
<ExecuteResponse>
<return>
<results xmlns=”http://schemas.microsoft.com/
analysisservices/2003/xmla-multipleresults”>
<root xmlns=”urn:schemas-microsoft-com:xml-
➥
analysis:empty”>
➥
(output from cmd_1)
</root>
<root xmlns=”urn:schemas-microsoft-com:xml-analysis:
empty”>
➥
(output from cmd_1)
</root>
<root xmlns=”urn:schemas-microsoft-com:xml-analysis:
empty”>
➥
<Exception xmlns=”urn:schemas-microsoft-com:
xml-analysis:exception” />
➥
<Messages xmlns=”urn:schemas-microsoft-com:
xml-analysis:exception”>
➥
<Error ErrorCode=”3239313412” Description=
“Errors in the metadata manager. Either the cube with the ID of 'foo'
does not exist in the database with the ID of 'FoodMart 2008',
or the user does not have permissions to access the object.”
Source=”Microsoft SQL Server 2008 Analysis Services” HelpFile=”” />
</Messages>
</root>
</results>
Search WWH ::
Custom Search