PRINT
[ {WITH | WITHOUT} PAGEINFO]
[ {WITH | WITHOUT} PAGEINDEX]
[ {WITH | WITHOUT} SCD]
[ DBTT {DEC | HEX | BOTH}];PAGEINFO
Page header
PAGEINDEX
Page index entries
SCD
Set connection data
PAGEINFO, PAGEINDEX and SCD apply to the output of CALC and data pages.
DEC
Decimal
HEX
Hexadecimal
BOTH
Decimal and hexadecimal
DEC, HEX and BOTH apply to the output of DBTTs.
Default values:
WITHOUT and DEC
Use of the PRINT statement is optional. It affects all DISPLAY statements which the user enters between two REALM statements or between a REALM statement and the END statement.
If the PRINT statement appears more than once, only the last statement takes effect.
Example
PRINT WITH PAGEINFO WITH PAGEINDEX WITH SCD.
****************************************** SCHEMA NAME < MAIL-ORDERS > ***************************************** ********************************** DATA / TABLE PAGES OF REALM < :SQL2:$XXXXXXXX.SHIPPING.CLOTHING > ******** -------------------------------------- REALM REF 5 BNR 18 ----- ACT KEY X'05000012' -------------------------------------- PAGE INFO: TYPE 0 -- FREE SPACE SIZE 1963, DISPL 2103 -- NR OF PAGE INDICES 10 -- DISPL TO END OF PAGE 4000 LOGICAL RECORDS: -2- PAGE INDEX: DB_KEY 9, 41 -- COL-NR 0 -- LIST REC -- DISPL 3767 ( 1) (00000000) 00090000 00000029 05000012 00090000 00000029 05000012 00090000 00000029 ( 33) (00000020) 05000012 00090000 00000029 05000012 00090000 00000029 05000012 00090000 ( 65) (00000040) 00000029 05000012 00090000 00000029 05000012 00000000 00090500 0011FF00 ( 97) (00000060) 00000000 00000000 00000000 00000000 00000000 00000000 00000001 0400000E ( 129) (00000080) F8F3F1F2 F1F3F1F1 C6D3D6E6 C9D5C740 D1C5D9E2 C5E840C4 D9C5E2E2 40E6C9E3 83121311FLOWING JERSEY DRESS WIT ( 161) (000000A0) C840D1C1 C3D2C5E3 40404040 40404040 F2F3F6F1 F1F1F3F6 0020700C 0023900C H JACKET 23611136 ( 193) (000000C0) 00000500 000C050C 00000499 950C0000 00000000 050C00 -3- PAGE INDEX: DB_KEY 9, 42 -- COL-NR 0 -- LIST REC -- DISPL 3552 ( 1) (00000000) 00090000 0000002A 05000012 00090000 0000002A 05000012 00090000 0000002A ( 33) (00000020) 05000012 00090000 0000002A 05000012 00090000 0000002A 05000012 00090000 ( 65) (00000040) 0000002A 05000012 00090000 0000002A 05000012 00000000 00090500 0011FF00 ( 97) (00000060) 00000000 00000000 00000000 00000000 00000000 00000000 00000001 0400000E ( 129) (00000080) F8F3F1F2 F1F3F1F1 C6D3D6E6 C9D5C740 D1C5D9E2 C5E840C4 D9C5E2E2 40E6C9E3 83121311FLOWING JERSEY DRESS WIT ( 161) (000000A0) C840D1C1 C3D2C5E3 40404040 40404040 F2F3F6F1 F1F1F3F8 0020700C 0023900C H JACKET 23611138 ( 193) (000000C0) 00000500 000C050C 00000499 950C0000 00000000 050C00 -4- PAGE INDEX: DB_KEY 9, 43 -- COL-NR 0 -- LIST REC -- DISPL 3337 ( 1) (00000000) 00090000 0000002B 05000012 00090000 0000002B 05000012 00090000 0000002B ( 33) (00000020) 05000012 00090000 0000002B 05000012 00090000 0000002B 05000012 00090000 ( 65) (00000040) 0000002B 05000012 00090000 0000002B 05000012 00000000 00090500 0011FF00 ( 97) (00000060) 00000000 00000000 00000000 00000000 00000000 00000000 00000001 0400000E ( 129) (00000080) F8F3F1F2 F1F3F1F1 C6D3D6E6 C9D5C740 D1C5D9E2 C5E840C4 D9C5E2E2 40E6C9E3 83121311FLOWING JERSEY DRESS WIT ( 161) (000000A0) C840D1C1 C3D2C5E3 40404040 40404040 F2F3F6F1 F1F1F4F0 0020700C 0023900C H JACKET 23611140 ( 193) (000000C0) 00000500 000C050C 00000499 950C0000 00000000 050C00 . . .[ page header
[ page index entry
[ Set Connection Data (SCD)
[ data record
PAGE INFO (page header)
All pages, except for DBTT pages and FPA pages, contain the page header in the first 20 bytes. BPRECORD prints the following PAGE INFO:
TYPE
Type of page
0:
Data page or CALC page
1:
Act-Key-0 page
FREE SPACE
Free storage space in the page:
SIZE
Length of the free storage space (in bytes)
DISPL
Displacement relative to the first unused byte
NO OF PAGE INDICES
Number of page index entries
DISPL TO END OF PAGE
Length of the page (in bytes)
PAGE INDEX (page index entry)
Page index entries are used to locate a record or table within the page. They occur in data pages and direct CALC pages. BPRECORD prints:
DB-KEY
Database key of a record in the form: recref, rsq
COL-NR
Column number in the DBTT
=0:
Data record (LOGICAL RECORD or CALC KEY REC)
>0:
Table record (TABLE REC)
DISPL
Displacement relative to the data record
SCD (Set connection data)
The set connection data is explained in the “Design and Definition” manual.