Laurent Vaills wrote: > > Hello. > > I am using SAP DB 7.3.0.29 . > > Here are my table definitions : > CREATE TABLE Foo (Content LONG BYTE) > CREATE TABLE Bar (Content LONG BYTE) > > Then I want to INSERT all the rows from Foo to Bar with this > statement : > INSERT INTO Bar SELECT * FROM Foo ; > > and I got the error : > -7032,SQL statement not allowed for column of data type LONG:CONTENT > > I tried both with dbmcli and JDBC but I got the same error, so I guess > it comes from the kernel. > > Any plans to allow this kind of statement in a near future ? > > Do you have any work around except from doing a Java program and > iterating the ResultSet of "SELECT * FROM Foo" and then > "INSERT INTO Bar > (?)" ?
In 7.4.3beta this insert..select using long-columns is allowed. Unfortunately there are no other chances than fetching long-values to some client and inserting it in the other table if you use kernel-versions earlier than that. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
