Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
speno
Starting Member
18 Posts |
 Posted - 2004-02-09 : 17:52:52
|
| I have a linked server to an AS/400 database and I'm using OpenQuery in my statement but it's not bringing all of the records across. Statement readsSelect * from OPENQUERY(XXX,'SELECT * FROM XXX.XXX')I will only get about 60 records out of 18,000. When I change the statement to read "Select * from OPENQUERY(XXX,'SELECT X,Y FROM XXX.XXX')", I get 4,000 records but again not all of them. Can anyone offer some explantation? |
|
|
speno
Starting Member
18 Posts |
Posted - 2004-02-11 : 09:18:08
|
| I discovered the answer inside the ODBC for this connection and the buffer setting. |
 |
|
|
|
|
|
OpenQuery not returning all records