Queries against a DB2 linked server return a fixed quantity of bytes??

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739565

  More actions

  May 25, 2004 at 6:30 am

  #507632

  Try changing the columns you get, I'd bet you get a different row cont. We fought this issue using Client Access going against a AS/400 and didn't get a resolution that I remember. We had to work around it. It was apparently a data volume issue iwth both IBM and MS pointing at each other. I'd lean towards a client access issue, personally.

• Alejandro DAndrea

  SSC Veteran

  Points: 275

  More actions

  May 26, 2004 at 6:48 am

  #507833

  Thanks Steve!

  Luckily, I found the answer:

  Open the ODBC entry, go to "Performance" -> "Advanced" -> and uncheck "Use blocking with a fetch of 1 row"

  Regards,

  Alejandro