| |

VerySource

 Forgot password?
 Register
Search
View: 23|Reply: 0

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

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-3-15 08:30:01
| Show all posts |Read mode
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!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list