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?