Re: SQL Syntax Problem

[Peng Tuck Kwok]

In SAPDB you do not need to include the ' " ' for table names and column names. So for example your first statement would be :

INSERT INTO ans_doc_to_batch (doc_id, vault_name, batchname)
VALUES(257316, 'RECORDER', 'REC-3202') UPDATE DUPLICATES

I'm unsure whether the last bit about ' UPDATE DUPLICATES '


Randall Hinton wrote:

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