SYS.ATTACH_LOADER

Attach a rowloader implementation to a table.

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 RowLoader 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();