Re: Tablespace tablespace hackery

andrew, check out the /usr/informix/etc/makeps.sql script. its not supported by informix prior to version 6.x but it does what you want. its a little buggy, but works for most cases. > > I would like to be able to access the tablespace tablespace (and other hidden > tables) through a database, just like any regular table. > > My plan of action would be something like: > > Create a database, with a table with the same structure as the tablespace > tablespace, go into systables and change the partition number to point at > the real tablespace tablespace. > > Anyone done this before? Anyone got schemas? > > Yes, I know - I could do no end of damage this way... > > Andrew > -- 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 | +----------------------------------------------------------------------------+