Re: How to copy LONG column

Tom Wilson wrote:

> I need to copy a long varchar from one table to another using
>
> UPDATE tab1 SET longcol = (SELECT longcol2 FROM tab2 WHERE
> tab1.key=tab2.key);
>
> But I get an error that this is an invalid use of a LONG column. How
> do
> I insert or update a long column by copying a value from another
> column?
>
> Tom

 Try the COPY-Statement,

Before executing the COPY-Statement: SET LONG 32000 (or more)

Hope this helps!

Stefan Received on Wed May 21 1997 - 00:00:00 CDT