Re: One tip

Posted in 1999

Angel Gomez — Tue, 12 Oct 1999 14:02:40 PDT — source: Informix-list mailing list archive (1991-1998)

What about a VIEW ? >From: Ant'nio Roque <antonio.roque@auchan.pt> >Reply-To: Ant'nio Roque <antonio.roque@auchan.pt> >To: "informix iiug list" <informix-list@iiug.org> >Subject: One tip >Date: Tue, 12 Oct 1999 17:20:04 +0100 > >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. > > > > > > > > > > Angel Gomez TelNor, S.A. Tijuana, B.C., Mexico. <Angel.Gomez@telnor.com> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com