[thelist] Serializing SQL calls to AS/400 via ODBC

[aardvark]

(sorry for the bad quoting, i'm on web mail...)

nup, that dinna do it... sadly i'm away from the server, but i'll try tomorrow and let y'all know what i do find.... if anything...

but guesses still welcome!

-----Original Message-----
From: Anthony Baratta 

At 02:48 PM 1/3/2005, aardvark wrote:

>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token ; was not valid. 
>Valid tokens: <END-OF-STATEMENT>.
>
>the examples we've found online don't work, and we can't find any detail 
>of this happening to anyone else...

I did a quick google and the examples I see don't have ";" as an end of 
statement. Maybe it just needs a carriage return/line feed?

e.g.

insert into table (,,,) values (,,,)
insert into table (,,,) values (,,,)
insert into table (,,,) values (,,,)
insert into table (,,,) values (,,,)

????