Retrievive index definations

[Stan-Lyn, Stanley Barnett]

Hi Richard,

What you are doing is what I want to switch to.  

What I need is a fast way or a function that can read the definition of an existing index and output its syntax so it can be added to the batch script.  I'm moving away from the -ra switch, as it cannot deal with corrupted or missing indexes.  Currently, when I run into a corrupted index, I have to search all my selection processing, menus, scripts so I can figure out how to recreate the index, and what a pain.

Thanks,
Stanley


 

-----Original Message-----
From: Richard Kreiss <rkreiss at verizon.net> 
Sent: Tuesday, October 15, 2019 3:54 PM
To: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
Subject: RE: Retrievive index definations

Try this as it takes into account corrupted indexes and/ort missing indexes

I use this menu option to avoid clients calling me if an index disappears or get corrupted.

This method can be used on both auto indexes and demand indexes 

Check the Index help for the reasons for why there are what appears to be extra commas.

Richard Kreiss
GCC Consulting

                       C R E A T E   B A T C H   F I L E             6.0
------------------------------------------------------------------------
@dprodir un_hnote -L
@ECHO   ******  UPDATING SALESNOTE INDEXES *************
@dxmaint un_hnote -oa -e -rf 1 -h "Reconstructing Note Index A"
@dxmaint un_hnote -ob -e -rf 2:1 -h "Reconstructing Note Index B"
@dxmaint un_hnote -oc -e -rf 3:1 -h "Reconstructing Note Index C"
@dxmaint un_hnote -od -e -rf 10:11:1 -h "Reconstructing Note Index D"
@dxmaint un_hnote -oe -e -rf 11:10:1 -h "Reconstructing Note Index E"
@dxmaint un_hnote -of -e -rf 74 -h "Reconstructing Note Index F"
@dxmaint un_hnote -og -e -rf 66 -h "Reconstructing Note Index G"
@dxmaint un_hnote -oh -e -rf 73 -h "Reconstructing Note Index H"
@dxmaint un_hnote -oi -e -rf 81:1 -h "Reconstructing Note Index I"
@dxmaint un_hnote -oj -e -rf 91:81,,d:1 -h "Reconstructing Note Index J"
@dxmaint un_hnote -ok -e -rf 4:81,,d  -h "Reconstructing Note Index K"

> -----Original Message-----
> From: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
> Sent: Tuesday, October 15, 2019 1:20 PM
> To: Richard Kreiss <rkreiss at verizon.net>
> Subject: RE: Retrievive index definations
> Importance: High
> 
> Hi Richard,
> 
> You may not be understanding what I need.  As I understand what you 
> are saying, will only work if the index exists and NOT deleted or corrupted.
The
> normal filepro tools allows you to create new, and update existing (so
long as
> they are not corrupted).  Instead of using the -ra switch to rebuild 
> all
of a tables
> indexes, it would be much better to create then again from scratch 
> using
the
> dxmaint tool with the full definition for each index executed by a 
> single
dxmaint
> command in a script, like...
> 
> So instead of doing this:
> /appl/fp /dxmaint sdequip -RA -m _sla -E
> 
> I need to do this so I can build or rebuild a deleted or corrupted 
> index
without
> tracking down of guessing the details on how and why it was built.  
> Also
note the
> arguments for the automatic indexes A-Cx shown below is not correct 
> and
used
> only to convey what I am trying to do:
> /appl/fp /dxmaint comments -o0 -e -r -a -x0 -h "Rebuilding Index 0 for
Comment
> File"
> /appl/fp /dxmaint comments -o1 -e -r -a -x1 -h "Rebuilding Index 1 for
Comment
> File"
> /appl/fp /dxmaint comments -oA -e -r -a -xA -h "Rebuilding Index A for 
> Comment File"
> /appl/fp /dxmaint comments -oB -e -r -a -xB -h "Rebuilding Index B for 
> Comment File"
> /appl/fp /dxmaint comments -oC -e -r -a -xC -h "Rebuilding Index C for 
> Comment File"
> 
> Thanks,
> Stanley
> 
> 
> 
> 
> -----Original Message-----
> From: Richard Kreiss <rkreiss at verizon.net>
> Sent: Monday, October 14, 2019 4:54 PM
> To: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
> Subject: Re: Retrievive index definations
> 
> Depending on your version, FPTech fad supplied an index rebuild 
> program
that
> does what you ask
> 
> Also you could just add a menu option.
> 
> Dxmaint !! -e
> 
> This will present the list of filePro files and allow for selecting 
> the
file and index
> wanted.  The -e will return to the menu when the rebuild is done.
> 
> RichardKreiss
> Sent from my iPhone
> 
> > On Oct 14, 2019, at 4:07 PM, Stan-Lyn, Stanley Barnett via 
> > Filepro-list
<filepro-
> list at lists.celestial.com> 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/201
> > 91
> > 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