1.1.1

TABLE
The name of the table that has the loader.
Example
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.REMOVE_LOADER(?,?)");
cs.setString(1, "test");
cs.setString(2, "table");
cs.execute();
SYS.REMOVE_WRITER
Remove an existing SQLFire listener given the schema and the table name.
Syntax
SYS.REMOVE_WRITER
(
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
SCHEMA
The schema of the table that has the writer that you want to remove.
TABLE
The name of the table that has the writer.
Example
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.REMOVE_WRITER(?,?)");
cs.setString(1, "test");
cs.setString(2, "table");
cs.execute();
SYS.START_ASYNC_EVENT_LISTENER
Start an installed AsyncEventListener configuration.
Syntax
SYS.START_ASYNC_EVENT_LISTENER (
IN ID VARCHAR(128) NOT NULL
)
ID
The unique identifier of the AsyncEventListener configuration that you want to start.
Example
After executing this procedure, SQLFire assigns a thread to service the queue of the "MyID"
event listener, dispatching events to the callback class:
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("call
SYS.START_ASYNC_EVENT_LISTENER( ? )");
vFabric SQLFire User's Guide616
vFabric SQLFire Reference