Exceptions and Errors

Some restrictions apply when transferring data incrementally.

Error messages are generated if you attempt to:

You cannot use the data transfer utility to transfer data using the bcp format over pipes or using pipes on the Windows platform.
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 SAP ASE has write permission in the directory.
SAP ASE cannot obtain sufficient memory for saved data for each table in a transfer. If this happens, increase the amount of memory available to SAP ASE.