I need to copy text data from one sybase 11.5.1 server to another using a CIS link.

I have tried update text but this won't work over a remote server link -
(I got this error: "Update or 'complex INSERT' of non-NULL TEXT/IMAGE data is unsupported by server 'Preprod1'. Use WRITETEXT instead. ").

The sql command WRITETEXT seems to be my best option, however it only appears to accept a typed value i.e:

WRITETEXT dbname.tablename.field @val with log "The text needs to be typed here"

i.e we can't use :
WRITETEXT dbname.tablename.field @val with log (select field from table)

Any help would be great, thanks.