Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010

    Unanswered: Fully Qualified Sever name

    Hi all,

    I am not familiar with Informix. Have a very basic question here.
    Can we run a query using the fully qualified server name? My requirement is that I should use fully qualified server name. Query is something like

    select col1.col2 from database@server.protocol.countrycode:tablename;

    Here server.protocol.countrycode is the fully qualified servername..

    I am running the above query through Queryman. Please let me know if there is any way to run it.


  2. #2
    Join Date
    Dec 2003
    North America
    Not familiar with QueryMan.

    You didn't specify which IDS release you're working with but I would assume this would be consistent from release-to-release. This is what I use in IDS 9.4:

    <db_name>@<server_name>:<'owner' in single quotes>.<table_name>

    example: prod_db@prodserver_shm:'sysadm'.timeclock

Posting Permissions

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