can DBSYS.EXE be used to repair the secondary indexes?

I have a file that has lost its 3 secondary indexes, primary is Ok and idx file is present.

The file has data so do not want to just repalce it

urgent

Thanks
LArry

"Larry" <larry@vikingcomp.co.za> wrote in message
news:05DF75F8-FF9A-4C45-AAF0-767131A9DF0E@news.elevatesoft.com...
> can DBSYS.EXE be used to repair the secondary indexes?
>
> I have a file that has lost its 3 secondary indexes, primary is Ok and idx
> file is present.
>
> The file has data so do not want to just repalce it
>
> urgent
>

Assuming the data portion is OK (I would at least run a verify and also a
query producing some totals that you can check against an external total)
all you need to do is re-add the indexes using SQL.

Robert

Larry,

<< can DBSYS.EXE be used to repair the secondary indexes?

I have a file that has lost its 3 secondary indexes, primary is Ok and idx
file is present. >>

A repair cannot re-add any missing indexes, but it can repair the table,
including all indexes that are present.

If you know what the index definitions are, then I would suggest that you
simply re-add them after repairing the table.

--
Tim Young
Elevate Software
www.elevatesoft.com