Hello Again,
I have removed the quotes and added the comment lines but I am still
getting the "Invalid End of SQL Statement" Error on this query, I have
been running the sql through the SQL Studio if that makes any
difference.
Current Query:
INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES
(6,
2, '02/14/2003 10:07:02', 23701) //
INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES
(6,
2, '02/14/2003 10:07:32', 23705)
Thanks,
Randall Hinton
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....?
Thanks,
Randall Hinton
_______________________________________________
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
