Problem with semicolon ; in multiple statement

[Guest_imported]

Hi,
I am tring to execute multiple SQL statements using my ADO/Windows application connecting to DB2 on AS400.

My sql statement is very simple, someting like:

UPDATE sometable set somet=1 where someting=1 ;
UPDATE sometable set somet=1 where someting=2

I put semicolon between the UPDATES.

When I execute it I get an error:
Token ; was not valid. Expecting token:<END-OF-STATEMENT>

My update statements work fine by themself.
But I can't execute multiple statements.

Does anyone know what may be wrong?

Thanks

Robert

 

[arunrathna]

Are u using Command Center to do this?? If u are using it, u can set the delimiter as &quot;;&quot;. U should be careful that u should not hit a enter (line feed) after the last semicolon (last line in the script).
Rathna