July 17, 2002 at 3:04 pm
Hi All,
I'm slowly becoming familiar with SQL Server in effort to migrate from Access and have set up a Linked server to an AS400 database. At times when I query the linked server using the 'openquery' method the results that are returned do not match the expected number of records. For example there is a table that has over 100,000 records but when I query (through Query Analyzer) for all records it only returns the first 420. I haven't set any rowcount conditions and this event only happens on certain tables.
Hopefully I'm just missing something small...any suggestions would be appreciated.
Thanks,
July 17, 2002 at 3:53 pm
Can you post the query you run against AS400 and the SQL with Openquery? Also do you get a successfull completetion or an error message?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 18, 2002 at 7:44 am
Here's the query I'm running...
select USG_AUTH_ANI from openquery(UAT,'select * from USAGEP')
The query seems to run fine and returns the results with no error messages. It's just not the right record count.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply