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
(?)" ?

Regards,
Laurent

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to