Online/Standard question !

Hi ! Is this possible between Standard Engine and Online Engine ? Btw, I am not very much familiar with higher versions of INFORMIX. what i am talking here is informix 7.1 Version. TIA, Nayan ---------- From: Kai_Shen@acer.de[SMTP:Kai_Shen@acer.de] Sent: Wednesday, 28 April, 1999 01:34 PM To: informix-list@iiug.org Subject: Re: Inserting data into another server. Some requirements: Which Informix version? You need I-net which is included since IDS 5 (?). In $INFORMIXDIR/etc/sqlhosts of source_server you need an entry similar to dest_tcp ontlitcp destination_server i_net In /etc/services of both servers you need an entry like i_net 1527/tcp # the 1527 must not be used before, can be any number Of course destination_server must be known TCPIP host. Then you may do something like INSERT INTO dest_database@dest_tcp:table SELECT * FROM src_database:table WHERE ... Hope this helps. Kai Please respond to krishnakn@yahoo.com To: informix-list@iiug.org cc: (bcc: Kai Shen/AEB_HAM/ACER) Subject: Inserting data into another server. Is it possible to write code in Informix-4gl to move data from one server to another. I'm planning to do something like INSERT INTO destination_server.tables... SELECT * FROM source_server.tables .... WHERE ..... Is there any constraints ??? How do u specify the server name in SQL statement ???? Thanks nkrishnakumar -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own