Cleaning Up the RAPStore

Once the LOAD TABLE command completes for every table that must be reloaded, clean up the RAPStore before restarting the Sybase IQ Output adapter. The RAPStore loads data using files written by the Sybase IQ Output adapter.

1. Go to the directory where the files are located, which is specified by the primaryFileLocation or overflowFileLocation property in the rap.ccr configuration file.
2. In the RAP_WORK_FILE table, remove each file in the directory:

   delete from RAP_WORK_FILE where FILE_NAME='filename'

3. Delete all of the files in the directory.