Page 1 of 1

AS400 DB2 TUniQuery Returns only 1 Row!

Posted: Mon 03 Mar 2014 14:39
by 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

Re: AS400 DB2 TUniQuery Returns only 1 Row!

Posted: Mon 03 Mar 2014 15:00
by 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!!!! :x

Re: AS400 DB2 TUniQuery Returns only 1 Row!

Posted: Tue 04 Mar 2014 12:52
by AlexP
Hello,

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

Re: AS400 DB2 TUniQuery Returns only 1 Row!

Posted: Wed 05 Mar 2014 16:29
by 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?!

Re: AS400 DB2 TUniQuery Returns only 1 Row!

Posted: Thu 06 Mar 2014 10:26
by AlexP
We need to reproduce the problem in our components and on the driver, on which you reproduced the problem.