How to select data from server and insert it into another server in informix DB

Question

If i have two tables with the same structure Table1,Table2 in different databases DB1,DB2 in two different servers S1 And S2.

How to Select from Table1 and Insert Into Table2 with a simple query ?

I try to execute the following but in vain:

INSERT INTO  DB2:Table2
SELECT * FROM DB1@S1:Table1

I get the following error :

tek-tips.com/viewthread.cfm?qid=303711 can perhaps help?

jarlh
– jarlh

2017-09-18 14:01:50 +00:00
Commented Sep 18, 2017 at 14:01 — jarlh
– jarlh, Commented Sep 18, 2017 at 14:01
@Scath :the link is concerning sqlserver not informix

Anyname Donotcare
– Anyname Donotcare

2017-09-18 14:15:10 +00:00
Commented Sep 18, 2017 at 14:15 — Anyname Donotcare
– Anyname Donotcare, Commented Sep 18, 2017 at 14:15

jsagrera · Accepted Answer · 2017-09-18 15:02:05Z

2

If you are connecting to S1 (informix Server 1) the SQL will be executed in that server, which means S1 will need to know where S2 is.

Basically make sure that there is a S2 defined in the sqlhosts file used in S1 (and that you can connect to S2 using the same user you are connecting to S1)

It's not enough to have S1 and S2 defined in the client 'sqlhosts' (server studio) as it is the Informix server (not the client) who will do the connection to S2 for the insert

answered Sep 18, 2017 at 15:02

jsagrera

2,0138 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to select data from server and insert it into another server in informix DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related