I am not to familiar with snapshots, but I do know that you
can use the COPY command to copy LONG variables from one
database to another. The syntax for my Alpha Vax/VMS is
something like:
COPY TO SCOTT/TIGER_at_REMOTE
CREATE IMAGE_TABLE USING
SELECT IMAGE_NO, IMAGE
FROM PART_IMAGES;
I can use this to move image columns which are LONG RAW to another
remote database.
HTH
Lee
>It seems there is no way to create a snapshot for a remote table
>with a LONG column. I think what can be done is to create a table
>locally with the LONG column and populate the table (complete
>refresh) using a stored procedure. How is it possible to automate
>this process (such as using CRON in UNIX).
>
>---------------------------------------------------------------------------
>Deepak Sharma
>TATA UNISYS LIMITED
>NEPZ
>INDIA
>
>e-mail : deepak_at_tulnepz.unisys.com
>---------------------------------------------------------------------------
>
>
Received on Fri Jan 19 1996 - 15:09:38 CST
