Hi Ruediger, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > I need to convert a table field from varchar to long varchar. > > > Is there a way to bring data from a varchar field into a long varchar > field in another table using sql, > or is there another possibility of converting the field > without using a new table, > or is it up to me writing a program which reads, converts and writes > record for record? > Copying could be done using the Loader. 1. Use a DATAEXTRACT FOR DATALOAD statement to get the data and to get the DATALOAD command generated. 2. Run the generated DATALOAD command.
That should do it. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
