Re: Multiple database opens with informix 5.0

In <56smk8$890@cssun.mathcs.emory.edu> URFF@dbcc.cc.fl.us (Eric Urff) writes: >We are running informix 5.0 in an HP-UX >environment. We currently have 2 databases >running in the engine a production database called >'prod' and a test database called 'test'. >These 2 databases are exact duplicates of each >other. Is there a way to extract the data from ><table-a> in the prod database and automatically >update <table-a> in the test database, without >doing a dbunload and then dbload. >i.e. Can both databases be open and the >information extracted from 'prod' and placed into >'test' with a single sql statement? If you're using Online, and both databases are in the same instance, you can see entities in both databases by prefixing with the database name. e.g. select <field list> from prod:<table>, test:<table> where prod:<table>.<field> something and...... If you're using Online and the databases are in seperate instances, then you'll need Star to do the job. Syntax is basically the same but you add the dbservername into the database name portion (prod@<dbservername>: etc). The functionality of Star is built into Engine versions 6 and above, in case you're thinking of upgrading in the near future. If you don't got Online, (or SE version 7.x, I think) then you'll have to muck about with temp tables which is hardly the "automatic" you were looking for. Bryan Tonnet batonnet@zeta.org.au