Does anyone know how to see DB2 views through a linked server on SQL Server?

I have an ODBC driver that let's me see the AS400, but once I've got a linked server, I can only see the tables and not the views.

If you issue an SQL select statement using the view name it will work fine. You are just looking at a list of tables on sysibm.systables (or whatever DB2/400 calls it). Try to write a query and list the contents of sysibm.sysviews (look in the SQL Reference for the exact name of the catalog table that has views in DB2/400).

Thanks alot. Was getting worried about that. Views working fine through Query Analyzer. Case Sensitivity a bit of a schlep though.

Hi Marcus/RudiVdm

I have a AS/400 V5R2M0 federated in a DB2 V8fp3.
I can recovery the code of a view (logical view) of the AS/400?

Can explain to me how?

Thanks.
Abel.