APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX System Administration :
"Recover"ing data into a consecutive file.
`
The 'recover' utility has an option for directing its output to a consecutive file, rather than an AppxIO indexed-format .dat file. Example:
 /usr/local/appx/appx -recover -c INDEXED.dat CONSEC.dat INDEXED.deleted

The "-c" argument takes data records found in the INDEXED.dat indexed file and writes them as consecutive records in CONSEC.dat. Any deleted records are placed into INDEXED.deleted as usual, and any invalid records are streamed to standard out as usual (from which they can be redirected into a file).

This can be handy for recovering data records you can't get via a keypath. It's also be useful if you have records in your INDEXED.dat with duplicate primary key values, on which you'd be unable to rebuild a .key because the key rebuild logic in "Create" stops on duplicate unique primary index values.

See also: http://www.appx.com/assets/asp/dynamic_generator.asp?pageid=624
and (Xref) How to use recover.exe!
`

[Append to This Answer]
2004-Apr-01 4:07pm
Previous: (Answer) Is there a PDF for the record number in a consecutive file?
Next: (Answer) I can't connect to a second instance of the database (Sybase, Oracle, etc.)
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=474
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.