ODBC resultset - remove limitation

HCL Domino Domino Forum
1

Hi,

The number of records in the Db2 is around 9000 but when I run the below code only 500 records are fetched.

result.Execute

If result.IsResultSetAvailable Then

Msgbox “Items found”

Do

result.NextRow

Item = result.GetValue(“IMLITM”,Item)

Msgbox Item

Loop Until result.IsEndOfData

result.Close(DB_CLOSE)

End If

Somehow, is it possible to fetch all the records from DB2 in the resultset? Is there some kid of memory limit on the resultset??

waiting for a reply,

Regards,

Priti.

2

Subject: ODBC resultset - remove limitation

Hello,

I ran into a problem like this and solved it by setting a CacheLimit on the resultset after running the Execute.

HTH,

David

3

Subject: ODBC resultset - remove limitation

Priti,

Add the following line PRIOR to your execute statement:

result.CacheLimit = DB_NONE

Like this:

result.CacheLimit = DB_NONE

result.Execute

If result.IsResultSetAvailable Then

…

Be aware – this can adversly impact performance and eat memory!

Hope this helps,

Gary

4

Subject: RE: ODBC resultset - remove limitation

Thanks a lot :slight_smile:

Regards,

Priti.