Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: Accessing tables,views,procedures etc from another DB2 db in one DB2 instance z/os

    How to access objects from other databases on one server db2 z/os?

    Example for the SQL Server:

    select * from test.dbo.table1 -- this query run from database spubs

    For db2 UDB uses alias(federated databases)

    What to use for db2 9.1 z/os?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    BELLO4KA,

    Thank you for the link.

    I need to know how to make the connection between databases on one server db2 z/Os (1 mashine)

    Perhaps I can use something similar in SQL Server:

    select * from test.dbo.table1 -- this query is run against spubs database

Posting Permissions

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