Professional Web Applications Themes

Federated Databases, joins across databases etc - IBM DB2

Greetings, I want to do a join between 2 tables on 2 different db2 databases on the same server. I assume that I have to use federated databases. I ma running DB2 Workgroup edition V8 on Redhat 8, how do I setup federated servers ?? Any hints, or links to doentation would be helpful. Thanks Ben...

  1. #1

    Default Federated Databases, joins across databases etc

    Greetings, I want to do a join between 2 tables on 2 different db2
    databases on the same server. I assume that I have to use federated
    databases. I ma running DB2 Workgroup edition V8 on Redhat 8, how do I
    setup federated servers ??

    Any hints, or links to doentation would be helpful.

    Thanks
    Ben

    Benjamin Stewart Guest

  2. #2

    Default Re: Federated Databases, joins across databases etc

    Go to DB2 DD:
    [url]http://www7b.boulder.ibm.com/dmdd/[/url]
    Then search for "federated". There are several hands on article. It's quite
    easy.

    Cheers
    Serge


    Serge Rielau Guest

  3. #3

    Default Re: Federated Databases, joins across databases etc

    ESE is definitely a coreq for DB2 II. Not sure about the Federated Functionality
    that come with DB2 though.

    Larry

    Ben Stewart wrote:
    > So it can be done with the workgroup edition ? I was under the
    > impression workgroup edition did not support federated.
    >
    > Ben
    >
    > Serge Rielau wrote:
    > > Go to DB2 DD:
    > > [url]http://www7b.boulder.ibm.com/dmdd/[/url]
    > > Then search for "federated". There are several hands on article. It's quite
    > > easy.
    > >
    > > Cheers
    > > Serge
    > >
    > >
    Larry Guest

Similar Threads

  1. databases
    By max in forum ASP.NET Web Services
    Replies: 8
    Last Post: October 21st, 05:22 PM
  2. ASP & Databases
    By McKirahan in forum ASP Database
    Replies: 7
    Last Post: April 11th, 08:31 AM
  3. [PHP] Databases
    By Duncan Hill in forum PHP Development
    Replies: 1
    Last Post: September 25th, 09:48 AM
  4. PHP and databases
    By Craig in forum PHP Development
    Replies: 5
    Last Post: August 21st, 07:59 AM
  5. One vs many databases
    By John Hunter in forum Oracle Server
    Replies: 9
    Last Post: January 5th, 08:50 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139