Hi! I need to copy the data from one table to another, on my SAPDB database. If I where working with a SQL Server DB I would run the following query: INSERT INTO TableB (fieldB1, fieldB2) SELECT fieldA1, fieldA2 FROM TableA ORDER BY fieldA1 But it seems that it doesn't work on SAPD, since it returned me the following error message: Database error occured: Native error: -5015 Text: [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5015 POS(191) Missing keyword:GROUP,OR,MOD,HAVING,DIV,AND,UPDATE,UNION,REJECT,INTER. Sorry for the somehow off-topic non-zope question, but I would really appreciate if someone could please enlighten on this. kind regards, Vitor Varalonga
Vitor Varalonga wrote:
I need to copy the data from one table to another, on my SAPDB database. If I where working with a SQL Server DB I would run the following query:
INSERT INTO TableB (fieldB1, fieldB2) SELECT fieldA1, fieldA2 FROM TableA ORDER BY fieldA1
But it seems that it doesn't work on SAPD, since it returned me the following error message:
Don't use the ORDER BY clause, it isn't really useful for the INSERT anyway.
Sorry for the somehow off-topic non-zope question, but I would really appreciate if someone could please enlighten on this.
Post these questions on the SAP DB mailing list: http://listserv.sap.com/mailman/listinfo/sapdb.general You can access it also as a newsgroup through gmane: news://news.gmane.org/gmane.comp.db.sapdb.general Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin daniel.dittmar@sap.com http://www.sapdb.org
participants (2)
-
Daniel Dittmar -
Vitor Varalonga