Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Question Unanswered: Database Connection

    Hi all,

    Is there a

    Connect to <Database1>, <Database2> user <Admin> using <Password>; ??

    TIA,

    Newbie

  2. #2
    Join Date
    Jun 2003
    Posts
    77
    You can not connect to two databases in a single command. In one command window, the connection is only to one database at a time.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Not quiet ...

    You may set CONNECT TYPE 2 and connect to more than one database in the same UOW ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Question Hmm...

    The reason i wanted to do that was, I need to access tables across two databases whose schemas are different and the user accesses are different. Only a Admin can access both.

    Database1 has a table TBLDB1 with DB1Col1, Db1Col2, Db1Col3
    Database2 has a table TBLDB2 with DB2Col1, Db2Col2, Db2Col3

    Where DB1Col1 = DB2Col1 (P.Key)

    I need to access DB2Col2 and DB2Col3. Something like

    Select DB2Col3, DB2Col2 from TBLDB2 where DB1Col1 = DB2Col1

    Thanks,
    Newbie

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Federated Databases is something you'll need

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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