Results 1 to 4 of 4

Thread: Accross servers

  1. #1
    Join Date
    Jul 2008
    Posts
    14

    Unanswered: Accross servers

    Hi Experts,

    I am connect to informix server A database dbA

    from this I need to retrieve data from informix server B database dbB

    how can I accomplish the above?

    Regards,
    Poornima

  2. #2
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    Hello,
    how about RTF(ine)M?
    I found this:
    http://publib.boulder.ibm.com/infoce...61%6d%65%22%20

    So in your case it would be:
    select * from dbB@B:your_database_B_table_name

    I think this is SQL92 compliant.

    HTH

  3. #3
    Join Date
    Jul 2008
    Posts
    14
    Hello,

    Thanks it works fine.

    But now I need to link two servers before I could issue the query rite.

    I need to know how to programatically link two servers. I mean by executing a shell script I should be able to link two informix database servers

    Thanks in advance.

    Rgds,
    P_db_user

  4. #4
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    I don't know anything about "programatically linking two servers" for IDS.
    You just need 2 IDS databases (you can have them on the same server or 2 different servers; same IDS instance or 2 instances), you need to configure instance(s) to receive remote connection (if you have 2 servers), and you can have distributed queries between instances. This isn't any high-tech procedure - it is simple IDS configuring.

Posting Permissions

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