Retrievive index definations

Ernie Barnard ernieb59 at gmail.com
Fri Oct 18 09:20:34 PDT 2019


There is a rebuild index script option under utilities.

You may be running a very old version of filePro and need to upgrade to 
a supported version.

On 10/18/2019 12:07 PM, Stan-Lyn, Stanley Barnett via Filepro-list wrote:
> 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

-- 
Ernie Barnard Jr.


-- 
This email has been checked for viruses by AVG.
https://www.avg.com



More information about the Filepro-list mailing list