1.1.1

ADDRESS VARCHAR(1024)
)
GATEWAYSENDER(TEST_SENDER1, TEST_SENDER2)
ASYNCEVENTLISTENER Clause
The ASYNCEVENTLISTENER keyword associates a table with one or more named AsyncEventListener
implementations.
Syntax
[ ASYNCEVENTLISTENER (async-listener-id [,async-listener-id] * ) ]
Description
See Implementing an AsyncEventListener on page 198.
Note: The listener configuration that you specify does not have to be available at the time you create the
table, so SQLFire does not display an error message if the specified listener name does not exist. Make
sure that you use the same listener name with both the CREATE ASYNCEVENTLISTENER command
and the CREATE TABLE command.
Note: You can optionally use the SQLFire ALTER TABLE command to add or remove asynceventlistener
configurations after you have created a table.
Example with ASYNCLISTENER Keyword
The following example associates a new table with two AsyncEventListener implementations.
CREATE TABLE TESTTABLE
(
ID INT NOT NULL,
DESCRIPTION VARCHAR(1024),
ADDRESS VARCHAR(1024)
)
ASYNCEVENTLISTENER(TEST_LISTENER1, TEST_LISTENER2)
EVICTION BY Clause
Use the EVICTION BY clause to evict rows automatically from an in-memory table based on different criteria.
You can use this clause to create an overflow table where evicted rows are written to a disk store, or you can
simply destroy the evicted rows to control memory usage.
Syntax
[ EVICTION BY
{
LRUMEMSIZE integer-constant
|
LRUHEAPPERCENT
|
LRUCOUNT integer-constant
}
[ EVICTACTION { OVERFLOW | DESTROY } ] ]
vFabric SQLFire User's Guide504
vFabric SQLFire Reference