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

[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 (,,,)

????