Results 1 to 4 of 4

Thread: DB2 views

  1. #1
    Join Date
    Sep 2003
    Posts
    17

    Unanswered: DB2 views

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).

  3. #3
    Join Date
    Sep 2003
    Posts
    17

    Thanks

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

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •