Why filter doesn't work for DB2 views, but works for DB2 tables?

[surotkin]

Hi everyone,
I use MS Access as a front-end to run queries against DB2 tables and views.
When I use filter (criteria) in queries based on DB2 tables, it works fine. However, when I use the same queries based on DB2 views, it doesn't filer records. The filter (criteria) doesn't work for views!!!

Does anybody have any idea, why?

Any help appreciated.
surotkin

 

[blom0344]

Are you using linked tables through ODBC (and then Access query panel with Jet SQL) or are you defining passthrough queries directly onto DB2 objects?
From experience I know that things that were okay in Access97 did no longer work properly with Access2000 when working with DB2/AS400
If you are working with linked tables(views) can you open up the view itself from Acces and see all data?

Ties Blom

 

[surotkin]

Hi blom0344,
Thanks for your response.
I don't use passthrough queries directly to DB2 objects. I use Jet queries with linked DB2 objects.

However, I have solved the problem recently myself.
I deleted links to DB2 objects, then I recreated the links.
It works now.

Thanks.
surotkin