Gerd K�nig wrote: > > Hi, > > I need to modify one column in a table from varchar to LONG. > > In the archive I found the workaround: > 1.) rename table to temp_table > 2.) create new table with LONG inside > 3.) transfer data from temp_table to new one via > insert into new_table (col1, col2,..) select col1,col2,... from > temp_table > > I want to do this in SQL-Studio, but step 3.) fails with error: > > "General error;-7032 POS(295) SQL statement not allowed for > column of data > type LONG" > > I'm using version 7.0.3.34. Can somebody tell me how to > finish this task ??
There is no way to insert...select from varchar to long. Unfortunately you have to extract the data to a file using some clients and insert it into the new/changed table using a script or the loader. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
