How does the Infotmix database between two machines access data tables?

wuren61

Prawns, does Informix have something similar to Oracle's dblink?
I now have the business system database on machine A and the data warehouse on machine B. They are all the same version of Informix. Now I write a stored procedure in database B to extract the table data in database A. How do I write it?

If it is Oracle, it can be written like this
insert into tablename1 (select * from username.tablename1@dblinkname)

Help Informix solution!

落日圣骑

It should be select * from datebase@informixserver:tablename, there must be a trust relationship between the two machines.

wuren61

If machine A ip=19.168.0.1, database name=CRMDB
Can I create machine A alias=Aserver and database alias=MisDB on machine B?
The sql=select * from MisDB@Aserver:tablename on B, the purpose No matter how the ip and database name on machine A change, the sql on B does not need to be modified

Please enlighten prawns. . . .

無所謂

Informix does not have such things as oracle dblink
In fact, only need to establish a trust relationship between the two machines, it is more convenient to access
The documents for establishing a trust relationship are as follows:
/etc/hosts
/etc/services
/etc/hosts.equiv
$HOME/etc/sqlhosts

godxuli

The one on the first floor should be correct, but as he said, two computers must establish a trust relationship