Re: One tip

Why don't you use the notation like: SELECT * FROM remotedatabase@remoteserver:remotetable I think it is the most resonable way to do what you are trying to do. Best Regards, Octav On Tue, Oct 12, 1999 at 05:20:04PM +0100, Ant?nio Roque wrote: > Hi People , I?m using Informix Dynamic Server Version 7.30.FC7 for HP-UX , and I need to retrieve from 12 remote databases the stock of some items > at the end I have all stock available = stock_db1+stock_db2 ... and so on ...! > > The problem is that I can only have one database selected at same time ( I?m using informix 4gl ) , I was thinking on using text file > one text file for each database and at the end , load all texts files into a temp table and run a report on it , but It?s a "dummie" solution. > and also is not so fast ....! > > > Any Ideas ??? > > Thanks Roque. > > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com