Re: Problem with multiple databases in a single 4GL program

mmaldona@andromeda.mty.itesm.mx (Ing. Maximo Maldonado Boyso) writes: >[some text deleted] >Based on my own experience: >In SE you can use temporary tables to transfer >data between different databases; I've had no >problem performing the next sequence of >operations: Be careful here! I did this some years ago, and a new version of SE caused it to fail, at which time I discovered I was coding into a bug. Unless you've seen it documented, I would say that creating a temp table in one database and switching to another database and using that temp table is not supported. Back then, one couldn't even use UNLOAD and LOAD statements in 4GL, so I had to grab an array-full of data at a time to do data transfer. ============================================================ Dennis J. Pimple Senior Consulting Services Engineer Informix Software Inc Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025 > - open source database > - create temporary tables for the transfer > - close source database > - open destination database > - populate tables >In OnLine 5.0 although you can open only one >database, you still can manipulate directly multiple >databases in your sql statements (the requirement >is that all databases have logging) >-- >Maximo Maldonado B. >Information Services >ITESM-Campus Monterrey >Mexico >mmaldona@mtecv2.mty.itesm.mx