Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Posts
    14

    Unanswered: creating dblink between informix databases

    Hi, how to create a dblink between 2 informix databases in order to launch a query on tables between the 2 databases, is there a command to create this link?

    tnanks

  2. #2
    Join Date
    Mar 2012
    Location
    Somewhere In Europe
    Posts
    24
    Hi Challenger
    I do it in such way:

    Code:
    SELECT t1.col1 FROM nameofdb1@nameofserver:nameoftable t1, nameofdb2@nameofserver:nameoftable2 t2 
    WHERE t1.col1 = t2.col1;
    Shorter version (w/o server name):

    Code:
    SELECT t1.col1 FROM nameofdb1:nameoftable t1, nameofdb2:nameoftable2 t2 
    WHERE t1.col1 = t2.col1;
    Watch out for logging mode.

    Regards
    Mike

  3. #3
    Join Date
    Jul 2012
    Posts
    14
    Hi, it gives me this error : Cannot reference an external database with logging

  4. #4
    Join Date
    Apr 2013
    Posts
    2
    Hello,
    be sure that both database has the same logging mode, You can see that with onmonitor tool, and if you want to change the logging mode you can do it with ONTAPE, check the sintaxis doing ontape --

    Example:
    switching from no-logging to logging the database dummy.

    ontape -s -U dummy

    Regards,
    Julio

Posting Permissions

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