<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<tt>Stanley,<br>
<br>
IXSORT() returns the sort information on an index.
IXSORT(filename, index, sortlevel)<br>
<br>
That works if you have the indexes. If the indexes are deleted it
is too late to make that work.<br>
<br>
I suggest that you build a menu options with the full information
about the index for rebuilding .<br>
<br>
dxmaint filename -rf 1,10,a:2,5,A -oA -e<br>
<br>
Like that. Then you can always replace the indexes and rebuild
anytime you want.<br>
<br>
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.<br>
<br>
Nancy<br>
</tt><br>
<div class="moz-cite-prefix">On 10/14/2019 4:07 PM, Stan-Lyn,Stanley
Barnett via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:6caf658c421243ce853e555dd0f9f28c@stanlyn.com">
<pre class="moz-quote-pre" wrap="">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: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20191014/1c785552/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20191014/1c785552/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>