re:

Barry Toomey writes: > > I had a somewhat similar sitation some years ago where I wanted to share a > table between two databases. Having created the an identical table in the > second database I then used the Unix ln function to link the tablename.dat > and tablename.idx files from the first database to the second. > > You have to be careful, of course, because if you get the order wrong > you'll wipe your original data. It seemed to work reasonably well, in that > I, as the database owner, could update the table in *either* database and > it would automatically update in the other, although I seem to remember > other users having occasional permission problems on UPDATE or INSERT. I > *know* this is totally undocumented, and probably unsupported by Informix, > but is there any reason why it shouldn't work? > > I would think mv or cp should work likewise. Has anyone out there tried > this? barry, you guys are talking about the standard engine.. check the systable.dirpath column in the databases you are using. you can set these to point at the same file. -- regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | |----------------------------------------------------------------------------| | 'connectionLESS IS MORE' -- Data Broker | |----------------------------------------------------------------------------| | Duct tape is like the force. It has a light side, and a dark side, and | | it holds the universe together ... | | -- Carl Zwanzig | +----------------------------------------------------------------------------+