DISPLAY [IN CSV [csv-filename]] RECORDNUMBER STATISTICS FOR
{REALM {realm-name-1,... | ALL} | RECORD {record-name-1,... | ALL}}
IN CSV
BSTATUS also outputs the data in CSV format.
csv-filename
Name of the file to which the data is to be output in CSV format. The specification of csv-filename is mandatory in the first IN CSV statement of a BSTATUS run (e.g.
DISPLAY IN CSV 'BSTATUS.CSV' ...).
For a detailed description of CSV format output, see the manual “Database Operation”, section “Outputting database information in a neutral format”.
REALM
For each record type which can occur in the specified realm(s), BSTATUS prints the number of records stored therein
realm-name
Name of the realm for which BSTATUS is to print out the record number statistics
ALL
BSTATUS prints the record number statistics for all realms of the subschema
RECORD
For each specified record type, BSTATUS prints out the number of records stored in the realms in which the record type can occur
record-name
Name of the record type for which BSTATUS is to print out the record number statistics
ALL
BSTATUS prints the record number statistics for all record types of the subschema
Example
DISPLAY RECORDNUMBER STATISTICS FOR REALM ALL.
NUMBER OF RECORDS PER REALM* R E A L M R E F S|-----------------------------------------------------------------------------------------------** R E C O R D S | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 ||--------------------------------|-----------|-----------|-----------|-----------|-----------|-----------|-----------|-----------|| | | | | | | | | || CUSTOMER | 0 | - | - | - | - | - | - | - || | | | | | | | | || CST-ORDERS | 0 | - | - | - | - | - | - | - || | | | | | | | | || ORD-ITEM | 0 | - | - | - | - | - | - | - || | | | | | | | | || INSTALMENT | 0 | - | - | - | - | - | - | - || | | | | | | | | || ART-TYPE | - | - | 1 | 0 | 0 | 3 | 0 | 0 || | | | | | | | | || ART-SELECTION | - | - | 2 | 0 | 0 | 3 | 0 | 0 || | | | | | | | | || ART-DESCR | - | - | 8 | 0 | 0 | 5 | 0 | 0 || | | | | | | | | || ARTICLE | - | - | 55 | 0 | 0 | 8 | 0 | 0 || | | | | | | | | || SUBSET | - | - | - | 0 | 0 | - | - | - || | | | | | | | | || COLORS | - | - | - | - | - | - | - | - || | | | | | | | | || MATERIALS | - | - | - | - | - | - | - | - || | | | | | | | | || SUPPLIER | - | 1 | - | - | - | - | - | - || | | | | | | | | || PURCHASE-ORDER | - | 0 | - | - | - | - | - | - || | | | | | | | | || P-ORD-ITEM | - | 0 | - | - | - | - | - | - || | | | | | | | | |*--------------------------------------------------------------------------------------------------------------------------------*..AREA REF 3 = CUSTOMER-ORDER-RLMAREA REF 4 = PURCHASE-ORDER-RLMAREA REF 5 = CLOTHINGAREA REF 6 = HOUSEHOLD-GOODSAREA REF 7 = SPORTS-ARTICLESAREA REF 8 = FOODAREA REF 9 = LEISUREAREA REF 10 = STATIONERY
RECORDS
Names of record types
REALM REFS
Realm numbers; for each realm BSTATUS sets up a column containing the number of records stored in the realm
0:
The record type can be contained in the realm, but no record is stored there
-:
The record type cannot occur in the realm
AREA REF
Assignment of realm numbers to realm names