AS400 DB2 TUniQuery Returns only 1 Row!

[Andidreas]

Hi,

today i faced another issue...

I connected to our AS400 Database via the ODBC Provider.
First i tried to get all Records of a small table, so i used a Select * From Table1 SQL Statment.

The Query should return 925 Records, but the Query returns only one Row!
And now i don't know whats wrong. I hope you can help!


Some additional Informations:
- UniDAC Version 5.2.7
- Delphi Version RAD XE
- ODBC Driver Version for IBM 13.64.04.00 (32-bit [Windows 64-bit])
- TUniQuery.FetchRow = 1000
- TUniQuery.QueryRecCount = True

[Andidreas]

Ok... When i change the TUniQuery.FetchRows Parameter to one, it works!

But this is really confusing!!! Pls explain why i must set this Parameter to one!!!!

[AlexP]

Hello,

Please send us a link, where we can download the specified version of the driver to study the issue.

[Andidreas]

You can not use the ODBC Driver for the AS400 w/o a valid license.

So please find another way to study this Issue!
Maybe the ADO Component from Delphi can helps you?!

[AlexP]

We need to reproduce the problem in our components and on the driver, on which you reproduced the problem.