ODBC connection to AS/400 and max resultset problem

I use ODBC connection to retrieve data from at table on a iSeries. The table I do a select from with SELECT * FROM LIB/PRODUCTS contains aprox. 16000 records. When executing the statement and run through the resultset, it only returns the first 8500 records.

Any suggestions why?

Subject: ODBC connection to AS/400 and max resultset problem

Where you ever able to get an answer to this question, if so could you please email me at a.derosa@live.com