Adaptive Server generates an error message if you attempt to:
Transfer a table that does not exist.
Transfer an object that is not a table.
Transfer a table that you do not own and have not been granted permission to transfer, and you do not have sa_role privileges.
Decrypt columns during transfer from a table containing encrypted columns, without having specific permission to decrypt those columns.
Transfer for iq, when the table contains text or image columns
Transfer for ase, but specify a column order other than offset.
Transfer for bcp, but specify a column order other than id.
Issue an alter table...set transfer table on command that names a system catalog.
Other reasons for transfer failure are:
The requested file cannot close.
You cannot transfer tables with off-row columns (text, unitext, image, and Java columns stored off-row).
Fail to open the file. Make sure the directory exists and Adaptive Server has write permission in the directory.
Adaptive Server cannot obtain sufficient memory for saved data for each table in a transfer. If this happens, increase the amount of memory available to Adaptive Server.
