BPRECORD is used to print out any combination of the five different page types making up a realm in the following sequence:
1.
************************************* ACTUAL-KEY-0 OF REALM < :IUDS:$XXXXXXXX.SHIPPING.ARTICLE-RLM > *************
PHYS REC LENGTH : 4000
DATASET INFO :
TOTAL NR PAGES: 2062
FPA BASE BEGIN: AREA REF: 11
BNR: 1
NR PAGES IN FPA BASE: 1990
FPA EXTENTS
NR BNR
1 47
MAX NR PAGES IN EXTENT: 63680
HIGHEST PAGE NR FOR FORMATTING: 2061
CREATE DATA: DATE : 20190129 TIME: 092704
BACK UP DATA: DATE : 20190129 TIME: 092742
REALM VERSION NR: 3
SYSTEM BREAK:
OCCURRED: 0
ADMIN USERID: $XXXXXXXX
CONFNAME: BREORG
FILE NAME: :IUDS:$XXXXXXXX.SHIPPING.ARTICLE-RLM
REALM LAYOUT VERSION: 004.00
UDS VERSION: V2.9
INCR NR PAGES: 64
INCR MIN PAGES: 0
2.
************************************* F.P.A. ENTRIES OF REALM < :SQL2:$XXXXXXXX.SHIPPING.ARTICLE-RLM >
-------------------------------------- REALM REF 11 BNR 1 ----- ACT KEY X'0B000001' --------------------------
0.......29: 0 0 0 0 0 0 0 0 0 0
30.......39: 0 0 3960 3964 0 0 3956 0 0 0
40.......49: 0 0 0 0 0 0 2800 0 0 0
50.......69: 0 0 0 0 0 0 0 0 0 0
70.......79: 0 0 0 0 0 0 0 0 0 3980
80.....1989: 3980 3980 3980 3980 3980 3980 3980 3980 3980 3980
-------------------------------------- REALM REF 11 BNR 47 ----- ACT KEY X'0B00002F' --------------------------
1990.....2059: 3980 3980 3980 3980 3980 3980 3980 3980 3980 3980
2060.....2061: 3980 0
3.
*********************************** D.B.T.T. ENTRIES OF REALM < :SQL2:$XXXXXXXX.SHIPPING.ARTICLE-RLM
==================================== RECORD REF 6, NAME: < ART-TYPE > =====================
-------------------------------------- REALM REF 11 BNR 3 ----- ACT KEY X'0B000003' ------------------------
RSQ 1/X'00000001': ( 5, 12/X'0500000C') ( 11, 37/X'0B000025')
RSQ 2/X'00000002': ( 8, 4/X'08000004') ( 11, 39/X'0B000027')
RSQ 3/X'00000003': ( 8, 5/X'08000005') ( 11, 41/X'0B000029')
RSQ 4/X'00000004': ( 8, 6/X'08000006') ( 11, 44/X'0B00002C')
RSQ 5/X'00000005'- 11/X'0000000B': ( 0, 0/X'00000000') ( 0, 0/X'00000000')
4.
*********************************** CALC KEY BUCKETS OF REALM < :SQL2:$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
.
.
.
5.
********************************** DATA / TABLE PAGES OF REALM < :SQL2:$XXXXXXXX.SHIPPING.CLOTHING > ********
-------------------------------------- REALM REF 5 BNR 19 ----- ACT KEY X'05000013' -------------------------------------
PAGE INFO: TYPE 0 -- FREE SPACE SIZE 2081, DISPL 2209 -- NR OF PAGE INDICES 9 -- DISPL TO END OF PAGE 4000
LOGICAL RECORDS:
-2- PAGE INDEX: DB_KEY 9, 48 -- COL-NR 0 -- LIST REC -- DISPL 3767
( 1) (00000000) 00090000 00000030 05000013 00090000 00000030 05000013 00090000 00000030
( 33) (00000020) 05000013 00090000 00000030 05000013 00090000 00000030 05000013 00090000
( 65) (00000040) 00000030 05000013 00090000 00000030 05000013 00000000 000A0500 0012FF00
( 97) (00000060) 00000000 00000000 00000000 00000000 00000000 00000000 00000001 0400000E
( 129) (00000080) F8F3F5F9 F2F8F0F9 E360E2C8 C9D9E340 C4D9C5E2 E2404040 40404040 40404040 83592809T-SHIRT DRESS
( 161) (000000A0) 40404040 40404040 40404040 40404040 F2F3F7F1 F0F2F3F6 0020700C 0023900C 23710236
( 193) (000000C0) 00000500 000C050C 00000499 950C0000 00000000 050C00
The structure and function of the different page types are described in the “Design and Definition“ manual.
SCHEMA NAME schema-name
Name of the schema, whose realms are to be printed by BPRECORD
ACTUAL-KEY-0 OF REALM realm-name
Realm information page of the realm realm-name; BPRECORD optionally prints the realm information page in normal text
F.P.A. ENTRIES OF REALM realm-name
FPA (free place administration) entries of the realm realm-name; BPRECORD optionally prints all FPA entries or only the FPA entries of certain pages
REALM REF realm-ref BNR pnr
BPRECORD prints the page address before the contents of each page
realm-ref:
Number of the realm
pnr:
Page number
D.B.T.T. ENTRIES OF REALM realm-name
DBTT entries of the realm realm-name; BPRECORD optionally prints:
- all DBTTs,
- only the DBTT of a certain record type, or
- only the DBTT entries of certain records of a record type
RECORD REF recref, NAME: record-name
is the header of the DBTT of a record type
recref:
Number of the record type (record reference)
record-name:
Name of the record type
CALC KEY BUCKETS OF REALM realm-name
Direct CALC pages or indirect CALC pages (primary and overflow pages) of the realm realm-name
CALC RECORD, REC REF recref, RECORD NAME record-name
Direct or indirect CALC pages of the record type record-name
CALC SEARCH KEY, KEY REF keyref, SET NAME set-name
CALC pages of CALC SEARCH key keyref
keyref:
Number of the key
set-name:
Name of the associated set
DATA/TABLE PAGES OF REALM realm-name
Data pages of the realm realm-name, which contain records (excluding CALC records) or tables and/or table entries;
BPRECORD only prints pages which are not empty. To decide whether or not a page is empty, BPRECORD first checks the FPA entries.
CALC pages and data pages are sorted according to ascending page numbers.