Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015

    Question Unanswered: Select item from another database

    Hello everyone ,
    Can you telling me how i can Select an item from another database.
    in MySQL i can do this: SELECT * FROM AnotherDatabase.tableName
    but i dont have any idea how i can do this in DB2 .
    Help Me please
    PS: Im Sory for my english

  2. #2
    Join Date
    May 2012
    Canberra, Australia
    Provided Answers: 6
    if you mean connecting to another db inside one transaction then you will have to federate the db
    read this

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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