We use a LSX ODBC connection to transfer records from a DB2/400 database to a Domino database. Also the DB2 database contains many more records, always 2828 records are transfered. The agent doing this job comes to a normal end. If I start the agent again the next 2828 records are transfered. We used different sets of records/data in the DB2 database. So we don’t think that we have some kind of data problem.
Any ideas why there is this limit with 2828 records?
Subject: LSX ODBC transfers always 2828 records
Jochen,
I had the same problem. I can’t remember what setting it was, but one of result set values for getting the records is the key. If I find the code, I’ll tell what I set.
John
Subject: LSX ODBC transfers always 2828 records
Jochen,
sorry for the delay. but what I set was res.cachelimit to a small number like 500, and everything worked. I had to do this with a few other clients, I think it has to do with the amount of data being returned by the query. In any case, others have had this problem and they all posted the same in r5 forum.
john
Subject: RE: LSX ODBC transfers always 2828 records
Thanks for your help. We solved the problem.
Jochen
Subject: LSX ODBC transfers always 2828 records
Try these settings:
Set res=New ODBCresultset
res.FetchBatchSize = 50
res.maxRows = 200000
res.CacheLimit =60