Remote SQL

Posted in 2003

Bharu — 13 Oct 2003 11:51:36 -0700 — source: Usenet: comp.databases.informix

Hi , I never used a remote SQL before. Can somebody please help me here. My program is running on a machine A , I want to fetch the data from a machine B. If possible please tell me how I can do it both from the command prompt and programatically. Thanks in advance. Bharad.

↪ replying to Bharu

tomL — 13 Oct 2003 14:39:04 -0700 — source: Usenet: comp.databases.informix

bharu108@yahoo.com (Bharu) wrote in message news:<29c7fdae.0310131051.3e77867c@posting.google.com>... > Hi , > > I never used a remote SQL before. Can somebody please help me here. > My program is running on a machine A , I want to fetch the data from a > machine B. > If possible please tell me how I can do it both from the command > prompt and programatically. > > Thanks in advance. > Bharad. --------------- try this , where foo is the table INSERT INTO foo SELECT * FROM [database name]@[server name]:foo WHERE ID NOT IN (SELECT ID FROM foo) Tom