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.

Regards,
Chandu.

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