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

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

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

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.