There are certain restrictions for truncations and transfers.
Be aware of the following restrictions:
- Do not modify table structures (add, delete, or change columns) while transfers are in progress, or when Adaptive Server export files are present.
- Rows in use by an open transaction will not be transferred.
- The destination IQ table must have a primary key.
- If the primary key of a row in Adaptive Server is changed, the row will appear as a new row in IQ. The old row in IQ is not updated or deleted.
- If the destination table in RAPStore has a UNIQUE constraint, then the source table in RAPCache must also have a UNIQUE constraint. RAPStore does not perform uniqueness checking when loading transferred data.
- A RAPCache can only transfer data from a particular table to one RAPStore.