Unanswered: Copying text data from one server to the next
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)