Retrievive index definations
Nancy Palmquist
nancy.palmquist at vss3.com
Tue Oct 15 13:52:44 PDT 2019
Stanley,
IXSORT() returns the sort information on an index. IXSORT(filename,
index, sortlevel)
That works if you have the indexes. If the indexes are deleted it is
too late to make that work.
I suggest that you build a menu options with the full information about
the index for rebuilding .
dxmaint filename -rf 1,10,a:2,5,A -oA -e
Like that. Then you can always replace the indexes and rebuild anytime
you want.
I have seen people copy the index.A, etc. to a subfolder or rename them
like st_index.A and use that to recover the index. Not my suggested
method but it is a solution.
Nancy
On 10/14/2019 4:07 PM, Stan-Lyn,Stanley Barnett via Filepro-list wrote:
> Hi,
>
>
> Is there a way to retrieve the index definitions of a data file where its indexes were built via the gui? So instead of ./dxmaint table -bs -ra -e -h "Rebuilding All Indexes" that rebuilds all the indexes without knowing anything about the indexes, I need to build them individually with the dxmaint command. Sometimes an index gets deleted and without this info, I have to spend a lot of time tracking down the process that uses the deleted index and then try and figure out how it was constructed. If this info can be gathered near creation time, I would have a library of the index definitions. I'm using SCO Unix here. So is there a filepro function or a storage location where the definition can be retrieved?
>
>
> Thanks,
>
> Stanley
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191014/1c785552/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191015/609b90aa/attachment.html>
More information about the Filepro-list
mailing list