SQL2000 Linked Server To DB2

I’ve got a linked server created in SQL2000 to DB2.

I’m using Client Access ODBC Drivers, and Microsoft OLE DB provider for ODBC Drivers.

I have views created against the linked server as

ALTER VIEW BLBATDT AS
SELECT * FROM LURCH_PARADB.S102D4LM.PARADB.BLBATDT

All seem(ED) to be working fine until I ran into this issue.

Using the view
If I select count(*) from BLBATDT returned value 786
If I select * from BLBATDT I get 76 rows returned

If I select from BLBATDT where field = value I get nothing, when in fact there is a value I specified.

I modified the view creation to

Create view as
select * from openquery(LURCH_PARADB,
'select *
from S102D4LM.PARADB.BLHDR')

Performed the above simple selects, (same results)

I modified the view creation to
Create view as
select * from openquery(LURCH_PARADB,
'select field_list_of_all_fields_in_the_table
from S102D4LM.PARADB.BLHDR')

Same results

However if I modified the view creation to
Create view as
select * from openquery(LURCH_PARADB,
'select field1, field2
from S102D4LM.PARADB.BLHDR')

And limit the fields selected to a small subset, everything works fine.

I think the issue may be that the parent tables are very wide in total byte count and the number of fields is also large.
This particular tables has 120 fields with a total record length of over a 1000 bytes.

If this is the case, how do I resolve this?


Has anyone ran into this before?