CID CHAR(6) -- primary key links one to one to Attach1 DataFile Long Raw -- hold external fileI set up a remote view where datafile is mapped to a regular memo field. To get the data into the memo field, the file name is stored in m.lcDOC and the command I use is:
APPEND MEMO DataFile FROM (m.lcDoc) OVERWRITETo extract the data I use
COPY MEMO DataFile TO (m.lcFile) && lcFile is the destination path and nameI use this in both Oracle and SQL*Server and it seems to work fine -- although the file to string stuff seems to be the recommended approach.