TUniQuery only returns 1 row

[kstantonnw]

Greetings.

I just purchased UniDAC to work with an ODBC driver for the AS/400 replacing the current BDE connection and query components.

In a very simple test app, I use the same exact SQL but TUniQuery only returns 1 row.

Environment:
Windows XP all updates
Delphi 6 all updates
UniDAC 5.02


Here is the SQL, very basic:
SELECT CRORDR, CRAMT, CRCUST, CRMDAT, CRRDAT, "CRAR$", CRPOST,
CRPDAT
FROM ARREC Arrec

Here is the TUniQuery:

object qry: TUniQuery
Connection = UniConnection1
Transaction = UniTransaction1
UpdateTransaction = UniTransaction1
SQL.Strings = (
'SELECT CRORDR, CRAMT, CRCUST, CRMDAT, CRRDAT, "CRAR$", CRPOST, '
'CRPDAT'
'FROM ARREC Arrec')
FetchRows = 100
Left = 88
Top = 16
end


Connection Component:
object UniConnection1: TUniConnection
ProviderName = 'ODBC'
SpecificOptions.Strings = (
'ODBC.DSNType=ntName')
DefaultTransaction = UniTransaction1
Username = 'KEVIN40'
Password = '**************'
Server = 'FCTG400'
ConnectDialog = UniConnectDialog1
LoginPrompt = False
Left = 24
Top = 16
end


Transaction Component:
object UniTransaction1: TUniTransaction
DefaultConnection = UniConnection1
Left = 56
Top = 16
end

Any help will be GREATLY appreciated!

Kevin

[AlexP]

Hello,

Please specify the exact versions of the DB server and ODBC driver you are using.

[kstantonnw]

The database resides on an IBM AS/400.

ODBC Driver: Client Access Driver (32-bit)
This is part of the installation for IBM i Access for Windows 7.1.

I hope this helps!

Kevin

[AlexP]

Hello,

Please specify the name and the versions of the server you are working with

[kstantonnw]

I'm not sure where to get that.

I'm assuming by "server" you're referring to the AS/400?

[AlexP]

Hello,

I meant DB server

[kstantonnw]

Greetings,

Sorry for the delayed reply. I have found an alternative route that worked the first time out of the box.

Best Regards,
Kevin

[AlexP]

Hello,

If you have any other questions, feel free to contact us.

[jstone]

I am having the same problem with my iSeries (AS/400) I'm only getting 1 row for my query. I would really appreciate any help I can get on this.

Thanks
Jody

[jstone]

If you set prefetch=0 in your DSN string it seems to fetch all the rows.

[AlexP]

Hello,

Please specify your ODBC driver version. We have checked the behavior on the version 10.01.200.238 and, independently on the value set in the prefetch parameter, UniDAC returns the correct number of strings.
P.S. There is no such parameter as prefetch in the ODBC settings of the driver version I have specified, we pasted this parameter directly to the connection string.

[jstone]

Version 13.00.01.00

[AlexP]

Hello,

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

[Andidreas]

If you set prefetch=0 in your DSN string it seems to fetch all the rows.

@jstone...
Where can i find this Parameter?
I've tried to add this parameter to the Connection String for my AS400, but i've got an Exception that this parameter doesn't exists/is allowed!

[AlexP]

This parameter is set in ODBC Data Source Administrator when creating DSN