1.0

Syntax
SYS.ATTACH_LOADER
(
IN SCHEMA_NAME VARCHAR(128) NOT NULL,
IN TABLE_NAME VARCHAR(128) NOT NULL,
IN FUNCTION_STRING VARCHAR() NOT NULL,
IN INIT_INFO_STR VARCHAR()
)
SCHEMA_NAME
The schema of the table where the loader will be attached.
TABLE_NAME
The table name to which the loader will be attached.
FUNCTION_STRING
The fully-qualified class name of the Using a RowLoader to Load Existing Data implementation.
INIT_INFO_STR
A string of initialization parameter values to pass to the init method of the loader implementation
after calling its default constructor.
Example
The following code adds an example loader implementation to a table.
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.ATTACH_LOADER(?,?,?,?)");
cs.setString(1, “test”);
cs.setString(2, “table”);
cs.setString(3, “testpackage.RowLoaderImpl”);
cs.setString(4, null);
cs.execute();
SYS.ATTACH_WRITER
Attach a writer to a table.
Syntax
SYS.ATTACH_WRITER
(
IN SCHEMA_NAME VARCHAR(128) NOT NULL,
IN TABLE_NAME VARCHAR(128) NOT NULL,
IN FUNCTION_STRING VARCHAR() NOT NULL,
IN IN-IT_INFO_STR VARCHAR(),
IN SERVER_GROUPS VARCHAR()
)
Description
The writer should be an implementation of the EventCallback interface. The onEvent method of the implementation
is invoked before an event (such as an insert, update or delete) occurs on the table. Only one writer can be attached
to a table. If a writer is already attached to a table, then the new writer replaces the previous one.
vFabric SQLFire User's Guide568
vFabric SQLFire Reference