One tip
This is a multi-part message in MIME format. ------=_NextPart_000_0009_01BF14D6.05C4BE80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi People , I=B4m 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 =3D stock_db1+stock_db2 ... and = so on ...! The problem is that I can only have one database selected at same time ( = I=B4m using informix 4gl ) , I was thinking on using text file=20 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=B4s a "dummie" = solution. and also is not so fast ....! Any Ideas ???=20 Thanks Roque. =20 =20 ------=_NextPart_000_0009_01BF14D6.05C4BE80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi People , I=B4m using Informix Dynamic Server = Version=20 7.30.FC7 for HP-UX , and I need to retrieve from 12 remote = databases=20 the stock of some items</FONT></DIV> <DIV><FONT size=3D2>at the end I have all stock available =3D=20 stock_db1+stock_db2 ... and so on ...!</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>The problem is that I can only have one database = selected at=20 same time ( I=B4m using informix 4gl ) , I was thinking on using = text file=20 </FONT></DIV> <DIV><FONT size=3D2>one text file for each database and at the = end , load=20 all texts files into a temp table and run a report on it , but It=B4s a = "dummie"=20 solution.</FONT></DIV> <DIV><FONT size=3D2>and also is not so fast ....!</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV><FONT size=3D2>Any Ideas ??? </FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>Thanks Roque.</FONT></DIV> <DIV><FONT size=3D2> </FONT></DIV> <DIV><FONT size=3D2> </FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0009_01BF14D6.05C4BE80--