Bulk copy transfer initiates a direct transfer of data between two databases from the client application. You use the bulk copy transfer statement to copy large amounts of data between similar tables.
These limitations apply to bulk copy transfer.
The transfer statement must be the only statement in a request.
The table (the target) into which you want to transfer data must already exist, because the transfer statement does not create new tables.
The structure of the target table must match the structure of the source table.
For bulk copy transfer to work, the secondaryname to the secondary database must be recorded in the interfaces file (UNIX) or in the sql.ini file (Windows).
Unicode datatypes are not supported.
The first 32K of long character and long binary values are supported. Transfer processing truncates longer values without any warning.
