SQL Syntax Problem

[Randall Hinton]

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