EventClass Element (ADF)

Contains elements that define a single event class.

Syntax

<EventClasses>
    <EventClass>

Element Characteristics

Element Relationships

Remarks

Example

The following example shows an EventClass element and its child elements. It defines an event class that provides stock information to a notification application.

<EventClass>
    <EventClassName>StockEvents</EventClassName>
    <Schema>
        <Field>
            <FieldName>StockSymbol</FieldName>
            <FieldType>char(10)</FieldType>
            <FieldTypeMods>not null</FieldTypeMods>
        </Field>
        <Field>
            <FieldName>StockPrice</FieldName>
            <FieldType>money</FieldType>
            <FieldTypeMods>not null</FieldTypeMods>
        </Field>
    </Schema>
    <FileGroup>Primary</FileGroup>
    <IndexSqlSchema>
        <SqlStatement>
        CREATE CLUSTERED INDEX StockIndex
        ON StockEvents (StockSymbol)
        </SqlStatement>
    </IndexSqlSchema>
    <ChronicleRule>
        <RuleName>StockEventChronRule</RuleName>
        <Action>
        INSERT StockEventChron
        (StockSymbol, StockHighPrice)
        SELECT StockEvents.StockSymbol, StockEvents.StockPrice
        FROM StockEvents
        WHERE StockEvents.StockSymbol
        NOT IN (SELECT StockSymbol FROM StockEventChron)
        UPDATE StockEventChron
        SET StockEventChron.StockHighPrice = StockEvents.StockPrice
        FROM StockEvents JOIN StockEventChron
        ON StockEvents.StockSymbol = StockEventChron.StockSymbol 
        WHERE StockEvents.StockPrice &gt; 
            StockEventChron.StockHighPrice
        </Action>
        <ActionTimeout>P0DT00H05M00S</ActionTimeout>
    </ChronicleRule>
    <Chronicles>
        <Chronicle>
            <ChronicleName>StockEventChron</ChronicleName>
            <SqlSchema>
                <SqlStatement>
                IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_NAME = &apos;StockEventChron&apos;)
                DROP TABLE StockEventChron
                </SqlStatement>
                <SqlStatement>
                CREATE TABLE StockEventChron
                (
                StockSymbol char(10),
                StockHighPrice money
                PRIMARY KEY (StockSymbol)
                )
                </SqlStatement>
            </SqlSchema>
        </Chronicle>
    </Chronicles>
</EventClass>

See Also

Reference

Application Definition File Reference

Other Resources

Defining Core Event Class Properties
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance

Change History