Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Federated db: in which catalog table is relation bettwen nickname and remote table

    Hi,

    I have a federated database system question on db2 v8.1 fp6 on Windows. I would like to know in which system catalog table is written relation bettween nickname and remote table.

    I would like to get something like:
    nickname_schema, nickname_table, remote_schema, remote_table.

    Thanks,
    Grofaty

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    federated tables

    have a look in syscat.taboptions : multi rows for each remote nickname
    ORA10NT BELGIUM SERVER ORA10NT
    ORA10NT BELGIUM REMOTE_SCHEMA DB2ADMIN
    ORA10NT BELGIUM REMOTE_TABLE BELGIUM
    ORA10NT BELGIUM TUPLE_ID_TYPE ROWID
    Hope this will help
    Best Regards, Guy Przytula

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi przytula,

    Thank you very much. It works for me.

    Grofaty

Posting Permissions

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