October 16, 2003 at 12:25 am
SQL on a linked database loses its 'where' clause when passed to the remote database.
This results in a very large result set being returned to SQL Server.
The remote database is DB2 for OS/390. Client is DB2 Connect.
Suspect it is some sort of collation problem as it only happens on 'where' clauses containing comparisions to string literals ie it works OK for numerics.
October 16, 2003 at 1:08 pm
Can you give a small sample query? I would like to see both the text that would/should be passed to the DB2 machine, and the actual statement executed at the SQL Server machine.
October 21, 2003 at 1:08 am
It was something to do with the collation.
Selecting the collation box on the linked database definition fixed the problem.
I will see if I can get the SQL from the user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply