can you query the table in DB2 from the DB2 console? Try to use the same query on the DB2 side (and also post the query here)
I dont think this is anything to do with SQL server.
Some links reg. that error.
http://webdocs.caspur.it/ibm/web/udb...m0/sql0200.htm
https://aurora.vcu.edu/db2help/db2m0/frame3.htm#sql0200