1.1

Syntax
SYS.REMOVE_LISTENER
(
IN ID VARCHAR(128),
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
ID
The unique identifier of the listener that you want to remove.
SCHEMA
The schema of the table that has the specified listener.
TABLE
The name of the table that has the specified listener.
Example
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.REMOVE_LISTENER(?,?,?)");
cs.setString(1, “id”);
cs.setString(2, “test”);
cs.setString(3, “table”);
cs.execute();
SYS.REMOVE_LOADER
Remove a loader from a table given the schema and table name.
Syntax
SYS.REMOVE_LOADER
(
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
SCHEMA
The schema of the table that has the loader that you want to remove.
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.
vFabric SQLFire User's Guide600
vFabric SQLFire Reference