Retrievive index definations

[Stan-Lyn, Stanley Barnett]

Hi Nancy,

Looks like the language doesn't have any functions for doing what is needed here.  So until fpTech gives us a function that does this, I'll be forgetting about doing the repair and rebuild in a script and rely on backups for missing and corrupted indexes.  It would have been so nice to have a script for each table that can create or fix them all in one go...  

Thanks,
Stanley



 

-----Original Message-----
From: Filepro-list <filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com> On Behalf Of Nancy Palmquist via Filepro-list
Sent: Tuesday, October 15, 2019 4:53 PM
To: filepro-list at lists.celestial.com
Subject: Re: Retrievive index definations

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/20191
> 014/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>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list