Retrievive index definations

Fri Oct 18 11:48:26 PDT 2019

Thanks Richard,

Sounds like what I'm looking for...  However I'm on SCO Unix with filepro 5.0.14d.  Is this utility and documentation published anywhere?  Searching for " FPIDX" now...

Thanks again,
Stanley

-----Original Message-----
From: Richard Kreiss <rkreiss at gccconsulting.net> 
Sent: Friday, October 18, 2019 2:44 PM
To: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
Subject: RE: Retrievive index definations

FP Tech has supplied a program FPIDX and a database file built on the output of foidx.

The fpidxdata file holds the index and sort information to be used by dxmaint.  It will also build a batch file to rebuild all of the indexes in your database.  That file can be modified easily to suit your needs or can be copied and edited.

If you don't have these, I would be happy to send them to you.  They have been included with the installs for a long time now so I can't tell you when they first appeared.  The issue may be that you are not running a version of filePro that can make use of these programs.  Also the version of the files I have are for Windows based filePro and not *nix.

Richard Kreiss

> -----Original Message-----
> From: Stan-Lyn, Stanley Barnett <stanley at stanlyn.com>
> Sent: Friday, October 18, 2019 3:01 AM
> To: Richard Kreiss <rkreiss at verizon.net>
> Cc: Filepro-list at lists.celestial.com
> Subject: RE: Retrievive index definations
> 
> 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/2
> > > 01
> > > 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