Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    36

    Unanswered: Accessing two databases

    I want to know the syntax for accessing two databases from my query.
    like

    connect to databse 1
    Create table <tabname1> <definition> in Databse1.
    then
    connect to database 2
    insert into database2.tabname1 select * from database1.table1

    Is something like this possible in DB2?

    Urgently need your help

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Accessing two databases

    Yes ... possible ...

    http://dbforums.com/showthread.php?threadid=664813

    Looks like I had replied to your question ...

    Cheers

    Sathyaram

    Originally posted by sandips
    I want to know the syntax for accessing two databases from my query.
    like

    connect to databse 1
    Create table <tabname1> <definition> in Databse1.
    then
    connect to database 2
    insert into database2.tabname1 select * from database1.table1

    Is something like this possible in DB2?

    Urgently need your help

Posting Permissions

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