Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Location
    New Jersey
    Posts
    10

    Unanswered: Insert Select With Remote DB

    insert into local_table
    select * from remote_table;

    Any help here would be appreciated. Assume that sqlhosts is set up
    and I have authority to access the remote server. I am running dbaccess
    on the local server. what needs to be done to point to remote_table as far as syntax goes. Using IDS 7.31.

    Thanks,

  2. #2
    Join Date
    Mar 2006
    Location
    New Jersey
    Posts
    10
    I have the answer... create a synonym pointing to remote database

    thanks

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    here is the syntax

    select * from databasename@informixservername:tablename

    Cheers

Posting Permissions

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