Re: How do you copy "long" data from one table to another?

Hi,

I think it is not possible to Update a long_column in a table, but you can built a new table with the COPY-Command:

Try :

set long 9999; # the maximale length you use in from table;

copy from db_user/db_passwd_at_db_name - create to_table (to_key, to_long_column) - using -
select from_key, from_long_column where from_keyname = from_key;

Hope it will help.

Greetings,
Stefan Scheck. Received on Thu Jul 06 1995 - 00:00:00 CEST