DISPLAY [IN CSV [csv-filename]] CALC PAGES page-selection
{
ALL [{RECORDS | CALC SEARCHKEYS}]
| ONLY {RECORD record-name | CALC SEARCHKEY keyref} rsq-selection
};
IN CSV
BPRECORD 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 BPRECORD run (e.g. DISPLAY IN CSV 'BPRECORD.CSV' ...).
For a detailed description of CSV format output, see the manual “Database Operation”, section “Outputting database information in a neutral format”.
page-selection
See BPRECORD statements, section “Physical selection (page selection)”.
Overflow pages lying outside of the page selection are also output with the primary CALC pages.
ALL
Print all realm CALC pages defined by page-selection
ALL RECORDS
Print the CALC pages (defined by page-selection) of all record types defined with LOCATION CALC
ALL CALC SEARCHKEYS
Print the CALC pages (defined by page-selection) of all CALC SEARCH keys
ONLY RECORD record-name
Print all records or specific records (rsq-selection) from the CALC pages defined by page-selection
record-name
Name of a record type defined with LOCATION CALC
ONLY CALC SEARCH KEY keyref
Print all CALC index entries or part (rsq-selection) of the CALC index entries from the CALC pages (defined by page-selection) of the CALC SEARCH key
keyref
Key number of a CALC SEARCH key (see “CALC-SEARCH-KEY INFORMATION”)
rsq-selection
See BPRECORD statements, section “Logical selection (RSQ selection)”.
Example 1
DISPLAY CALC PAGES PAGE 16 ALL CALC SEARCHKEYS
*********************************** CALC KEY BUCKETS OF REALM < :IUDS:$XXXXXXXX.SHIPPING.ARTICLE-RLM > *********** =========================== CALC SEARCH KEY, KEY REF 14, SET NAME < SYS_ARTICLE > =========================== -------------------------------------- REALM REF 11 BNR 16 ----- ACT KEY X'0B000010' -------------------------------------- PAGE INFO: TYPE 0 -- FREE SPACE SIZE 10, DISPL 30 -- NR OF PAGE INDICES 0 -- DISPL TO CALC TABLE HEADER 30 CALC KEY TABLE: MAX ENTRIES 220 -- ACT ENTRIES 25 -- OVERFLOW BUCKET NEXT 0, PRIOR 0 -1- ( 1) (00000000) F2F3F0F1 F0F7F3F6 23010736 RSQ 1 -- PPP 5, 13 -2- ( 1) (00000000) F2F3F0F1 F0F7F4F2 23010742 RSQ 4 -- PPP 5, 13 -3- ( 1) (00000000) F2F3F0F1 F0F7F4F8 23010748 RSQ 7 -- PPP 5, 13 -4- ( 1) (00000000) F2F3F2F1 F0F7F3F8 23210738 RSQ 8 -- PPP 5, 14 -5- ( 1) (00000000) F2F3F2F1 F0F7F4F0 23210740 RSQ 9 -- PPP 5, 14 -6- ( 1) (00000000) F2F3F2F1 F0F7F4F6 23210746 RSQ 12 -- PPP 5, 14 -7- ( 1) (00000000) F2F3F3F1 F0F8F3F8 23310838 RSQ 21 -- PPP 5, 15
Example 2
DISPLAY CALC PAGES ALL PAGES ONLY RECORD ART-DESCR ALL RSQS (record type defined with LOCATION CALC)
****************************************** SCHEMA NAME < MAIL-ORDERS > ****************************************** *********************************** CALC KEY BUCKETS OF REALM < :IUDS:$XXXXXXXX.SHIPPING.CLOTHING > *********** ============================ CALC RECORD, REC REF 8, RECORD NAME < ART-DESCR > =========================== -------------------------------------- REALM REF 5 BNR 2 ----- ACT KEY X'05000002' -------------------------------------- PAGE INFO: TYPE 0 -- FREE SPACE SIZE 20, DISPL 40 -- NR OF PAGE INDICES 0 -- DISPL TO CALC TABLE HEADER 40
CALC KEY TABLE: MAX ENTRIES 79 -- ACT ENTRIES 2 -- OVERFLOW BUCKET NEXT 0, PRIOR 0 -1- ( 1) (00000000) C6D3D6E6 C9D5C740 D1C5D9E2 C5E840C4 D9C5E2E2 40404040 40404040 40404040 FLOWING JERSEY DRESS ( 33) (00000020) 40404040 40404040 RSQ 8 -- PPP 5, 16 -2- ( 1) (00000000) D7D6D3D6 40C4D9C5 E2E24040 40404040 40404040 40404040 40404040 40404040 POLO DRESS ( 33) (00000020) 40404040 40404040 RSQ 11 -- PPP 5, 19 -------------------------------------- REALM REF 5 BNR 3 ----- ACT KEY X'05000003' -------------------------------------- PAGE INFO: TYPE 0 -- FREE SPACE SIZE 20, DISPL 40 -- NR OF PAGE INDICES 0 -- DISPL TO CALC TABLE HEADER 40 CALC KEY TABLE: MAX ENTRIES 79 -- ACT ENTRIES 4 -- OVERFLOW BUCKET NEXT 0, PRIOR 0 -1- ( 1) (00000000) D1C5D9E2 C5E840C3 D9C5D7C5 40C4D9C5 E2E24040 40404040 40404040 40404040 JERSEY CREPE DRESS ( 33) (00000020) 40404040 40404040 RSQ 7 -- PPP 5, 15 -2- ( 1) (00000000) D7D3C5C1 E3C5C440 C4D9C5E2 E240E6C9 E3C840D1 C1C3D2C5 E3404040 40404040 PLEATED DRESS WITH JACKET ( 33) (00000020) 40404040 40404040 RSQ 6 -- PPP 5, 14
.. -------------------------------------- REALM REF 5 BNR 4 ----- ACT KEY X'05000004' -------------------------------------- PAGE INFO: TYPE 0 -- FREE SPACE SIZE 20, DISPL 40 -- NR OF PAGE INDICES 0 -- DISPL TO CALC TABLE HEADER 40 CALC KEY TABLE: MAX ENTRIES 79 -- ACT ENTRIES 2 -- OVERFLOW BUCKET NEXT 0, PRIOR 0 -1- ( 1) (00000000) C6D3D6E6 C9D5C740 D1C5D9E2 C5E840C4 D9C5E2E2 40E6C9E3 C840D1C1 C3D2C5E3 FLOWING JERSEY DRESS WITH JACKET ( 33) (00000020) 40404040 40404040 RSQ 9 -- PPP 5, 17 -2- ( 1) (00000000) E360E2C8 C9D9E340 C4D9C5E2 E2404040 40404040 40404040 40404040 40404040 T-SHIRT DRESS ( 33) (00000020) 40404040 40404040 RSQ 10 -- PPP 5, 18
CALC RECORD
Hash area of a record type defined with LOCATION CALC
REC REF
Number of the record type
RECORD NAME
Name of the record type
CALC SEARCH KEY
Hash area of a SEARCH key defined with USING CALC
KEY REF
Number of the key
SET NAME
Name of the set to which this key belongs
PAGE INFO
Page header (see PRINT statement);
in CALC pages, DISPL TO END OF PAGE is replaced by:
DISPL TO CALC TABLE HEADER
Displacement to the CALC key table header
LOGICAL RECORDS
Print out of records with the following options:
PAGE INDEX
Page index entry (see PRINT statement)
SCD
Set connection data (see PRINT statement)
CALC KEY TABLE
BPRECORD prints the following information from the CALC key table header:
MAX ENTRIES
Maximum number of entries possible
ACT ENTRIES
Actual number of current entries
OVERFLOW BUCKET
Linkage to overflow pages:
NEXT n
Page number of the next overflow page
0: No overflow page exists
PRIOR m
Page number of the preceding page
0: Primary page