Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    20

    Unanswered: DB2 --> SQL Server 7 & 2000

    Im supporting a client that has an AS400 (DB2 database) accounting system and has recently upgraded from SQL Server 7 to 2000. He runs all his queries through SQL Server to DB2 becuase the interface and reporting is much easier.

    He has found that some of the same queries run through SQl Server 7 then through SQL Server 2000 yield different row counts. A query run directly on AS400 or through SQL Server 7 returns the correct number of rows, while the same query run through SQL Server 2000 will return a count considerably less...

    1,475,234 though SQL Server 7 and 2,045 through SQL Server 2000!

    Does anyone one know of any changes in the openquery structure between SQL 7 & 2000 or any changes in AS400 interaction that may account for this dataloss in SQL Server 2000?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I vote for the miracle thing...

    Where does the data reside.

    What do you mean "run on".

    How is connectivity established.

    And I would use the word "perceived" in your statement....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    Do you have any type of date criteria in your query?
    jaraba

Posting Permissions

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