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

    Unanswered: Accessing tables in another database.

    I have two databases, and a user existing in both. But when I log in as that user into one database and try to access tables in another database I get this error msg:

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

    Can anybody please help me.

    Thanks

    Prashant

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Federated Database

    Hi,

    I think you need to explore the federated database operations.

    Cheers

    Nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

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