I don’t know how I could describe the frustration I have passed through when a linked DB2 server on MS SQL started returning 1 single row using the openquery syntax.
After trolling on the net for days, I finally found a solution at http://sastools.com/b2/post/79394261#comments