Output
The output for the activity is the following.
Output Item |
Datatype |
Description |
noOfUpdates |
integer |
The number of updates performed by the statement. There could be more than one statement performed (for example, if a stored procedure is executed). Because of this, this item is a list of integers. Each item in the list corresponds to the number of updates performed by each statement. The first integer in the list is the number of updates performed by the first statement executed by this activity. The second integer is the number of updates performed by the second statement, and so on. |
unknownResultSet |
complex |
The result of the database statement. The result element depends upon what is returned by the statement. The result set is a list of zero or more rows with zero or more columns. Each column contains a name and a value element. You can use XPath expressions to retrieve the desired row and column from the result set. There could be multiple result sets returned by the statements executed by this activity. Because of this, this output item is a repeatable list of result sets. The first item in the list of result sets corresponds to the result set returned by the first statement executed by this activity. The second item in the list of result sets corresponds to the result set returned by the second statement executed by this activity, and so on. |
Elapsed Time |
long |
This field displays the time taken for the execution of the activity in milliseconds. This is an optional element that appears only when the property If set in the design-time, this property must be carried forward to the run-time; else it can cause run-time errors. Enabling this property causes additional performance overhead. Hence, it is recommended that you use this property only when this information is to be consumed by some other ActiveMatrix BusinessWorks activity. Also, it is recommended that this property be used only in a non-production environment as a diagnostic tool and the property be turned off at run-time. You can turn off the property and not calculate the elapsed time at run-time by setting the property |