Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Posts
    6

    Unanswered: OPENQUERY Returning only 2 Rows

    I have successfully set up a linked server to an AS400. However, when I try to set up a view for it using OPENQUERY, I aonly get 2 records. The SQL code itself should return all of the records in the file. Does anyone know if this is a quirk of SQL Server and what the workaround might be?

  2. #2
    Join Date
    May 2002
    Posts
    6

    Cool

    I am posting a reply to my own query, as I have found the solution. It turns out that I had the RECBLOCK setting for Client Access Express DSN set to 0. After I changed it to 0, I was able to get all of the records.

  3. #3
    Join Date
    May 2002
    Posts
    6
    I am posting a reply to my own query, as I have found the solution. It turns out that I had the RECBLOCK setting for Client Access Express DSN set to 0. After I changed it to 1, I was able to get all of the records.

  4. #4
    Join Date
    May 2002
    Posts
    6
    Sorry for the confusion with the above 2 replies.

    The sentence that reads, "After I changed it to 0, I was able to get..." should say, "After I changed it to 1 , I was able to get all of the records."

  5. #5
    Join Date
    May 2002
    Posts
    25
    Thanks for posting the solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •