You cannot use the data transfer utility to transfer data:
Using the for bcp format over pipes
Using pipes on the Windows platform
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, without having 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 include:
The requested file cannot close.
You cannot transfer tables with off-row columns (text, unitext, image, and Java columns stored off-row).
Failure 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.
