Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Using OpenQuery to query a linked AS400

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2004-04-26 : 11:34:53
Jay writes "I'm querying and AS400 using OPENQUERY but am finding that the number of rows return is not equal to the 'real' rowcount of the table in question.

I did notice a thread on this subject but it had no resolution so HHEELPPP!

I can see no pattern to the number of rows return e.g. on a table with 18 rows, I get 1. On a table with 6229 rows I get 6203.

Any help would be very much appreciated.

Almighty SQL Goddess

38200 Posts

Posted - 2004-04-26 : 12:42:12
Could it have to do with permissions?

Go to Top of Page

- Advertisement -