Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    46

    Question Unanswered: Accessing tables from another db

    Please somebody help me!

    I have two databases on the same server, and a user existing in both the databses . From one database (logged into this one) I am trying to access another database tables. I get this error msg:

    SQLSTATE = S0002
    [IBM][CLI DRIVER][DB2/6000] SQL0204N "DATABASE2.SH1.TAB1" is an undefined name. SQLSTATE=42704.

    In SQL Server and Sybase this can be done very very easily. I am new to DB2.

    Thanks

    Prashant

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Prashant,
    The only way to do this in DB2 is through Federation. Look through the manuals on how to set this up to suit your purposes.

    Andy

Posting Permissions

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