LISTSTAT: Customizable BUTIL -STAT Program

ListStat is a direct replacement for BUTIL -STAT.  In addition to being
fewer characters to type, the ListStat output is more compact and often will
eliminate the need to use "|MORE" when you use it.

For normal use, use the command format:
        LISTSTAT filename

Additionally, ListStat has the capabilities to perform STAT calls across a
series of filenames using wildcards in the filespec.

For example, to display statistics for all .BTR files, use:
        LISTSTAT *.BTR

Finally, ListStat can be used to extract out only specific pieces of
information from the STAT report, based on options provided on the command
line.  The available options (with full syntax) are:

LISTSTAT Version 1.4: 03/13 (C)2000 Goldstar Software Inc.

Usage:  LISTSTAT filespec [/Options] [/P=OwnerName]

    This command STATs each Btrieve file in filespec and displays that
    information to the console.
    /A Prints ALL Statistics. [Default]
    /F Prints File Formats.
    /S Prints Page Sizes.
    /R Prints Record Count Information.
    /L Prints Record Length Information.
    /V Prints Variable Record Information.
    /T Prints Key Total Information.
    /K Prints Detailed Key Information.
    /C Outputs Data in Comma-Delimited Format.
    /M Suppresses 'Processing' Messages.
    /P= Use this Btrieve Owner Name.

For example, if you wanted to find out the file formats of all DDF files:
        LISTSTAT *.DDF /F
This command displays:
LISTSTAT Version 1.4: 03/13 (C)2000 Goldstar Software Inc.

Processing File n:\pvsw\demodata\ATTRIB.DDF...
n:\pvsw\demodata\ATTRIB.DDF: File Version = 7.00

Processing File n:\pvsw\demodata\FIELD.DDF...
n:\pvsw\demodata\FIELD.DDF: File Version = 7.00

Processing File n:\pvsw\demodata\FILE.DDF...
n:\pvsw\demodata\FILE.DDF: File Version = 7.00

Processing File n:\pvsw\demodata\INDEX.DDF...
n:\pvsw\demodata\INDEX.DDF: File Version = 7.00


Statistical Output Complete.

To display a quick list of the records in each DDF File, try:
        LISTSTAT *.DDF /R
This results in the following output:

LISTSTAT Version 1.4: 03/13 (C)2000 Goldstar Software Inc.

Processing File n:\pvsw\demodata\ATTRIB.DDF...
n:\pvsw\demodata\ATTRIB.DDF: Total Number of Records = 35

Processing File n:\pvsw\demodata\FIELD.DDF...
n:\pvsw\demodata\FIELD.DDF: Total Number of Records = 101

Processing File n:\pvsw\demodata\FILE.DDF...
n:\pvsw\demodata\FILE.DDF: Total Number of Records = 14

Processing File n:\pvsw\demodata\INDEX.DDF...
n:\pvsw\demodata\INDEX.DDF: Total Number of Records = 58

Statistical Output Complete.


For dumping data into a spreadsheet, add the /C option to output in comma-
delimited format, and the /M to eliminate the "Processing" messages:
        LISTSTAT *.DDF /R /M /C
This results in the following output:

LISTSTAT Version 1.4: 03/13 (C)2000 Goldstar Software Inc.

n:\pvsw\demodata\ATTRIB.DDF,35,
n:\pvsw\demodata\FIELD.DDF,101,
n:\pvsw\demodata\FILE.DDF,14,
n:\pvsw\demodata\INDEX.DDF,58,

Statistical Output Complete.


You will note that the processing messages, header, and footer are all sent
to STDERR, so that these will not be visible if you redirect STDOUT.


LISTSTAT is a shareware DOS utility available at no cost.  Goldstar Software
can provide other extensions to these programs, upon request.  One future
extension is to convert this application to a 32-bit Windows application,
which would eliminate the need to run a DOS requester or BTRBOX.  Contact
us for further details on this update.


For more information on these utilities, or for onsite consulting, contact:
	Goldstar Software Inc.
        www.goldstarsoftware.com
