Lsxodbc

hcl-bot · June 21, 2011, 2:54am

Hi list,

I use odbc connection to access AS400.

It works fine to connect to files, but when I import files using an agent, I only import about 10000 documents, despite the query has about 13000 registries.

If I use .txt to import files, then all the registries are imported. Is there any limit to use sql instruction to import data?

b.Regards

hcl-bot · June 24, 2011, 11:36am

Subject: ODBCResultSet Class?

Using ODBCResultSet?

If so, try MaxRows Property

Read-write. Maximum number of rows fetched to the result set, or 0 to fetch all rows subject to memory limits.

odbcResultSet.MaxRows = rows&