Re: Multiple database opens with informix 5.0
How about
DATABASE test
INSERT INTO test SELECT * from prod:test
This only has database test open but uses a distributed database feature
to achieve the remote table name.
For this to work both databases have to be in the same instance of
INFORMIX-OnLine or you need to have INFORMIX-STAR installed.
> 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?
>
> Eric Urff
> DBCC
> }Received: from rmy.rmy.emory.edu by dbcc_rap.dbcc.cc.fl.us with ESMTP
> } (1.39.111.2/16.2) id AA189134876; Tue, 19 Nov 1996 09:47:56 -0500
> }Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
> JAA05337 for urff@dbcc.cc.fl.us; Tue, 19 Nov 1996 09:46:29 -0500 (EST)
> }From: clay@panix.com (Clay Irving)
> }Message-Id: <56s9oj$e0o@panix.com>
> }Subject: Re: 32bit Informix ODBC driver ?
> }Date: 19 Nov 1996 07:38:43 -0500
> }Reply-To: clay@panix.com (Clay Irving)
> }Organization: PANIX Public Access Internet and Unix, NYC
> }Sender: informix-list-owner@rmy.emory.edu
> }To: informix-list@rmy.emory.edu
> }X-Informix-List-To: urff@dbcc.cc.fl.us
> }X-Informix-List-Id: <news.30626>
> }
> }In <328c3863.169705876@news.csie.nctu.edu.tw> binary@ms1.hinet.net
> > (Binary Wang) writes:
> }
> }> I use Delphi 2.0,but
> }> Informix have not 32bit ODBC driver.
> }
> }> where have the 32 bit ODBC driver for informix 5.x ?
> }
> }I believe Visigenics has a 32-bit ODBC driver from Informix...
> }
> }--
> }Clay Irving N2VKG
> }clay@panix.com
> }http://www.panix.com/~clay/
> }
Malcolm Weallans
Online Database Consultancy
Phone 01628-72154
Fax 01628-37463
CIX - onlinedbc