1.1

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( ? )");
cs.setString(1, "MyID");
cs.execute();
SYS.STOP_ASYNC_EVENT_LISTENER
Stop a running AsyncEventListener configuration.
Syntax
SYS.STOP_ASYNC_EVENT_LISTENER (IN ID VARCHAR(128) NOT NULL)
This procedure stops dispatching events to the callback listener class, and invokes the close() method of the
implementation so that the event listener can perform any necessary cleanup.
ID
The unique identifier of the AsyncEventListener configuration that you want to stop.
601
SQL Language Reference