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