You will indeed have to put a // at the end of each statement (line comment). It is used as a separator between multiple statements but is not needed when executing a single statement un SAPDB. The "update duplicates" should be ok though I have never used it myself.
Florian Kaerner > -----Ursprungliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]Im Auftrag von Randall > Hinton > Gesendet: Mittwoch, 19. Februar 2003 00:49 > An: [EMAIL PROTECTED] > Betreff: SQL Syntax Problem > > > Hi all, > I am trying to import a Extremely long SQL script from MSSQL into SAP > and I have found the majority of the things that I have needed to > change, it creates the Tables fine but when it tries to do multiple > insert commands in succession it gives me an "Invalid END of SQL > statement" Error... Is there supposed to be some control character at > the end of the statement....? > > > > INSERT INTO "ans_doc_to_batch" ("doc_id", "vault_name", "batchname") > VALUES(257316, 'RECORDER', 'REC-3202') UPDATE DUPLICATES > > INSERT INTO "ans_doc_to_batch" ("doc_id", "vault_name", "batchname") > VALUES(257317, 'RECORDER', 'REC-3202') > > INSERT INTO "ans_doc_to_batch" ("doc_id", "vault_name", "batchname") > VALUES(257318, 'RECORDER', 'REC-3202') > > INSERT INTO "ans_doc_to_batch" ("doc_id", "vault_name", "batchname") > VALUES(257319, 'RECORDER', 'REC-3202') > > Thanks, > Randall Hinton > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
