Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Unanswered: SQL that accesses tables in different DB2 subsystems

    ...is there a way to do it?

    Running DB2 V7 on OS/390 - want to be able to access tables that reside in different subsystems with the same SQL. Is there some sort of DB2 technology that provides for this sort of functionality?

    Thanks.
    Last edited by Grumpy; 03-03-04 at 17:54.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: SQL that accesses tables in different DB2 subsystems

    Originally posted by Grumpy
    ...is there a way to do it?

    Running DB2 V7 on OS/390 - want to be able to access tables that reside in different subsystems with the same SQL. Is there some sort of DB2 technology that provides for this sort of functionality?

    Thanks.
    This has been discussed before, e.g. here:

    http://www.dbforums.com/showthread.php?threadid=985475

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Ask your DB2 DBA or DB2 systems programmer about DDF (distributed data facility).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2004
    Location
    Zuerich, Switzerland
    Posts
    13
    No need to ask - this is simply not implemented.
    you can access different DB2 systems in the same unit of work, but not in the same SQL statement

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Maybe Grumpy does't really need both tables to be in the same single SQL statement. One can almost always make it work with some program logic.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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