1.0

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.
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”);
vFabric SQLFire User's Guide570
vFabric SQLFire Reference