sql not returning full result set

We have a problem that I have not been able to get to the bottom of about the size of a result set returned from a sql query.

A client is doing some analysis and has some middleware to return the result set to Azure.

So the middleware sits on a Windows machine and connects to the two servers.

My confusion is why results are different - let me explain.

We are connecting to 2 IBMi systems, both at 7.3 - lets call them A and B

If we run the query requesting a count be returned both systems return the same count.

If we run the query to return the data A will retrieve 100k+ records and B will return 581 records.

Due to the network topology, I currently have only green screen access but hopefully I will get ACS and Navigator access soon.

Neither system as QAQQINI set up or any environment overrides.

I just don't know what would limit the result set / amount of data returned from system B

Any suggestions gratefully accepted.

Thanks
don

Brisbane - Sydney - Melbourne


Don Brown

Senior Consultant




P: 1300 088 400




DISCLAIMER. Before opening any attachments, check them for viruses and defects. This email and its attachments may contain confidential information. If you are not the intended recipient, please do not read, distribute or copy this email or its attachments but notify sender and delete it. Any views expressed in this email are those of the individual sender