Action Element for ChronicleRule (ADF)
Provides a Transact-SQL statement that specifies the action to be taken in an event chronicle rule.
Syntax
<EventClasses>
<EventClass>
...
<ChronicleRule>
...
<Action>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 1 and 100,000 characters in length. |
Default value |
None. |
Occurrence |
Required once per ChronicleRule element. |
Updates |
Can be modified, but not added or deleted, when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
The Action element can contain Transact-SQL statements that maintain the event chronicle, or can contain calls to stored procedures that maintain the event chronicle.
Example
This example shows a populated Action element. The Transact-SQL statements insert a row into the chronicle table if the stock information doesn't exist, and update the stock information if a row already exists.
<Action>
-- Insert New Stock Symbols with Prices
INSERT dbo.StockEventsChron (StockSymbol, StockPrice)
SELECT e.StockSymbol, e.StockPrice
FROM dbo.StockEvents AS e
WHERE e.StockSymbol
NOT IN (SELECT StockSymbol FROM dbo.StockEventsChron);
-- Update Existing Stock Symbols with New Prices
UPDATE dbo.StockEventsChron
SET StockPrice = e.StockPrice
FROM dbo.StockEvents AS e
JOIN dbo.StockEventsChron AS c
ON e.StockSymbol = c.StockSymbol
WHERE e.StockPrice > c.StockPrice;
</Action>
This example shows how to call a stored procedure that maintains the event chronicle.
<Action>
EXEC MyStoredProcdure;
</Action>
See Also
Reference
Application Definition File Reference
Other Resources
Defining Event Chronicle Rules
Defining Chronicles for an Event Class
Updating Instances and Applications