jasper@ibmpcug.co.uk (Jasper May) (05/28/91)
I am looking for a way to contract Informix SQL (C-ISAM ?) files that
have empty space in them where many records have been deleted. To date the only
way I have found is to unload the table, drop it, recreate it and then
reload the data. However, as the majority of the data that I am using
is maintained within a 4GL manufacturing package using Informix compatible
files that are linked (UNIX ln) with a namesake in an Informix .dbs directory,
this is to say the least a major pain.
For background info, in case it matters, I am running UNIX SVR3.2d on
an Altos 2000, with free disk space up to about 10 times the largest file to be
contracted. The Informix version I forget - purchased 1991 - 2.01.03b ?
Any help that anyone can offer would be greatly appreciated,
Thank You, Jasper.
--
Automatic Disclaimer:
The views expressed above are those of the author alone and may not
represent the views of the IBM PC User Group.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Jasper May - jasper@ibmpcug.co.uk | ...!uunet!ukc!ibmpcug!jasper |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~