Results 1 to 3 of 3

Thread: Data merging

  1. #1
    Join Date
    Oct 2004
    Posts
    28

    Unanswered: Data merging

    Hi all,

    We are trying to merge data from 2 different databases, does anybody have any ideas how this can be acheived

    Thanks

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    merge

    if you mean, select data from 2 db in the same query ..?
    this is only possible if a nickname has been defined over the second table
    in that case the table is seen as local and can be used in a regular join..
    nicknames support between db2 db is included in base code
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Apr 2003
    Posts
    9
    Using the federated database feature.
    For detail pls refer to the information center for DB2

Posting Permissions

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