demand index creation

[Joe Chasan]

On Thu, Apr 10, 2008 at 10:11:06AM -0400, Kenneth Brody wrote:
> Quoting Robert Pulliam (Thu, 10 Apr 2008 09:42:19 -0400):
> 
> > Is it possible to use @td in selection set for creating a demand   
> > index.   ie /appl/fp/dxmaint filename -o0 -s set -r -x0 -e.
> 
> Yes.  What is in the selection set "set"?
> 
> > A second question is the use of -a and a -v selection set set in the  
> >  above line. ie /appl/fp/dxmaint -o0 -a -v sel -r -x0 -e.
> 
> There is no "-v" flag to dxmaint.
> 
> > I can't seem to get either to work.
> 
> Define "work".
> 
> > If I substitute an actual date in the  selection set in the first  
> > instance it runs
> 
> Okay.  What is the exact selection set that "works", and the exact selection
> set that "doesn't work"?

perhaps you are using "eq" and not "eqf"?  again, would have see the
selection table to comment on it.
 
> > and the second instance always gives me a -v error.
> 
> By "a -v error", I assume you mean dxmaint is complaining about you passing
> a "-v" flag, and dxmaint has no "-v" flag?

while dxmaint can not use a -v, dreport obviously can.

what i do - create a output only process table called nothing, one line
in the prc table - exit.

do the sorting either in define output's sort screen or in your -v table
and add a -o to the command line to save sort/selection as demand index.

e.g. dreport some_file -f nothing -v sel_table -a -o0
(saves sort as demand index 0)
 
--
-Joe Chasan-                           Magnatech Business Systems, Inc.
joe - at - magnatechonline -dot- com   Hicksville, NY - USA
http://www.MagnatechOnline.com         Tel.(516) 931-4444/Fax.(516) 931-1264