Hi all, I am connecting to a DB2 database on an AS/400 using the Client Access Express ODBC driver (version 6). At times, I will have need to return some rather large datasets (around 10Mb total). Unfortunately, the CAE driver only allows the information to be sent in 8Kb segments before it pauses to prepare the next 8Kbs of data. Approx. every 2 seconds it will send the next batch of data, you can see that it will take roughly 40 minutes to retrieve the data.
Is there a way to configure the information to be returned in a compressed format so the transmission is quicker? How about removing trailing spaces so I can get more record sets? How about increasing the buffer send size (It might be called the Blocking Size)? Much thanks, Adam Frielink