rebuilding all demand indexes like /appl/fp/dxmaint FName -ra -e

Kenneth Brody kenbrody at spamcop.net
Thu Jan 26 08:07:50 PST 2017


On 1/25/2017 6:00 PM, Tony Freehauf via Filepro-list wrote:
> hi experts - how can i rebuild all demand indexes in 1 command line.
>
> using, from the command line,       /appl/fp/dxmaint FName -ra -e      works
> great for automatic indexes. I can not figure out how to use the listed
> switches (-A, -ln, -N, -S name and -Xn) to accomplish the same kind of
> results with on demand indexes.

The sort info can be read in processing with the SORTINFO() function.

However, selection information is not stored in demand indexes.

You could crate a script which explicitly calls dxmaint with the sort/select 
settings you want, and simply run that script.

-- 
Kenneth Brody


More information about the Filepro-list mailing list