List:MaxDB« Previous MessageNext Message »
From:Randall Hinton Date:February 19 2003 5:22pm
Subject:Fwd: Sql Syntax Problem,
View as plain text  
>
> 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: sapdb.general-admin@stripped
>> [mailto:sapdb.general-admin@stripped]Im Auftrag von Randall
>> Hinton
>> Gesendet: Mittwoch, 19. Februar 2003 00:49
>> An: sapdb.general@stripped
>> 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
>>
>> _______________________________________________
>
>


Thread
Fwd: Sql Syntax Problem,Randall Hinton19 Feb
  • Documents for procedure and triggerUlf Kellermann19 Feb