UDS/SQL V2.9 (en)

&pagelevel(4)&pagelevel

DISPLAY [IN CSV [csv-filename]] DATA PAGES page-selection

{

ALL [{RECORDS | TABLES}]

| ONLY { RECORD record-name

| TABLES OF {OWNER record-name | SET set-name | KEY 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' ...).

When national items exist, the output contains data in UTF-16 format.

For a detailed description of CSV format output, see the manual “Database Operation”, section “Outputting database information in a neutral format”.

page-selection

See section “Physical selection (page selection)”, BPRECORD statements.

Overflow pages lying outside of the page selection are also output with the primary table pages.

ALL

Print all realm data pages defined by page-selection

ALL RECORDS

Print all record types from the data pages defined by page-selection

ALL TABLES

Print all tables from the data pages defined by page-selection

ONLY RECORD record-name

From the data pages defined by page-selection, print the records or certain record (rsq-selection) of the record type record-name

record-name
Name of a record type which has not been defined with LOCATION MODE CALC

ONLY TABLES OF

From the data pages defined by page-selection, print out the tables or certain table entries (rsq-selection)

OWNER record-name
Of the owner record type record-name

SET set-name
Of the set set-name

KEY keyref
Of the key with the number keyref (see "KEY INFORMATION (NO CALC SEARCH KEYS)").

rsq-selection
See section “Logical selection (RSQ selection)”, “BPRECORD statements”. An RSQ selection is of no use for SYSTEM sets and is ignored if present.

Example 1

DISPLAY DATA PAGES PAGE 19 ALL RECORDS(only data records)

********************************** 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
-3-              PAGE INDEX:  DB_KEY     9,        49 -- COL-NR     0 -- LIST REC     -- DISPL  3552
 (       1)  (00000000)   00090000 00000031 05000013 00090000   00000031 05000013 00090000 00000031
 (      33)  (00000020)   05000013 00090000 00000031 05000013   00090000 00000031 05000013 00090000
 (      65)  (00000040)   00000031 05000013 00090000 00000031   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 F0F2F3F8 0020700C 0023900C                 23710238
 (     193)  (000000C0)   00000500 000C050C 00000499 950C0000   00000000 050C00 
-4-              PAGE INDEX:  DB_KEY     9,        50 -- COL-NR     0 -- LIST REC     -- DISPL  3337
 (       1)  (00000000)   00090000 00000032 05000013 00090000   00000032 05000013 00090000 00000032
 (      33)  (00000020)   05000013 00090000 00000032 05000013   00090000 00000032 05000013 00090000
 (      65)  (00000040)   00000032 05000013 00090000 00000032   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 F0F2F4F0 0020700C 0023900C                 23710240
 (     193)  (000000C0)   00000500 000C050C 00000499 950C0000   00000000 050C00

For descriptions of PAGE INFO, PAGE INDEX and SCD, see "Determine scope of output (PRINT)".

Example 2

DISPLAY DATA PAGES ALL PAGES ALL TABLES(only tables)

********************************** DATA / TABLE  PAGES OF REALM < :SQL2:$XXXXXXXX.SHIPPING.ARTICLE-RLM                 > ********
-------------------------------------- REALM REF  11  BNR      31 ----- ACT KEY  X'0B00001F' -------------------------------------
   PAGE INFO:   TYPE 0 -- FREE SPACE  SIZE    0,  DISPL    32 -- NR OF PAGE INDICES    1 -- DISPL TO END OF PAGE  4000
   LOGICAL RECORDS:
-1-            PAGE INDEX:  DB_KEY    0,        5 -- COL-NR    1 -- TABLE REC    -- DISPL    32
   TABLE:           MAX ENTRIES   112 -- TABLE NEXT       0 -- TABLE DESCR X'40' -- NEXT HIGHER LEVEL       0
                  ACT ENTRIES     5 --     PRIOR       0 --    LEVEL NR    0  --       LAST ENTRY      31
     -1-
               RSQ         2 -- PPP   8,      4
(    1)  (00000000)   C2C1E5C1 D9C9C1D5 40C2C5C5 D9404040   40404040 40404040 40              BAVARIAN BEER

     -2-
               RSQ         4 -- PPP   5,     18
(    1)  (00000000)   C3D6D5E3 C5D4D7D6 D9C1D9E8 40C3D3D6   E3C8C9D5 C7404040 40              CONTEMPORARY CLOTHING

     -3-
               RSQ         1 -- PPP   5,     12
(    1)  (00000000)   C5D3C5C7 C1D5E340 C3D3D6E3 C8C9D5C7   40404040 40404040 40              ELEGANT CLOTHING

     -4-
               RSQ         3 -- PPP   8,      5
(    1)  (00000000)   D3C5D4D6 D5C1C4C5 40404040 40404040   40404040 40404040 40              LEMONADE

     -5-
               RSQ         5 -- PPP   8,      6
(    1)  (00000000)   E8D6C7C8 E4D9E340 40404040 40404040   40404040 40404040 40              YOGHURT

[ Table header

[ Associated table entries

TABLE

From the header of the table, BPRECORD prints the following information:

MAX ENTRIES
Self-explanatory

ACT ENTRIES
Number of current entries

TABLE
Linkage of table pages
NEXT n
Page number of the next table page
PRIOR m
Page number of the preceding table page;
0: No next or prior table page exists

TABLE DESCR
Description of the table
Bit 2⁷ = 1: List
Bit 2⁶ = 1: Multi-level table
Bit 2⁵ = 1: Table ATTACHED TO OWNER
Bit 2⁴ = 1: Duplicates table
Bit 2³ = 1: Table in ACTKEY format
Bit 2² = 1: Table in ACTKEY format with chaining to the last page

LEVEL NR
Level of the table

NEXT HIGHER LEVEL
Page number of the page of the next higher level

LAST ENTRY
Page number of the last page of the basic level

In the case of table headers in ACTKEY format the chainings NEXT, PRIOR, NEXT HIGHER LEVEL and LAST ENTRY are displayed in eight-digit hexadecimal format. Non-existent chainings (e.g. LAST ENTRY in pages of the main level and PRIOR in pages of the highest level) remain free in the display. In the case of table headers in BNR format the chainings specify the block numbers concerned in the same realm in decimal format (cf. structure of the tables in the “Design and Definition” manual).

Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly

Print data pages (DISPLAY DATA)

Example 1

Example 2