CA RC/Update for Db2 for Z/OS : View non-display characters using RC/Browse

book

Article ID: 126991

calendar_today

Updated On:

Products

CA RC/Update for DB2 for z/OS

Issue/Introduction

On DB2 tables there is often data stored that is not displayable on screen and can look like garbage. RC/Browse is able to display this data in HEX format so that the data can be viewed correctly.

The results when displaying the START_RBA column from SYSIBM.SYSCOPY don't show the hex value of the field. How this field be displayed in HEX.

Environment

DB2 for Z/OS

Resolution

RC/Browse will format the data being displayed on the panel in order to ensure no ISPF control characters are displayed as a result of the hexadecimal data.
This is done to avoid a possible problem with displaying the ISPF panel.

The SPUFI results screen displays each result row as a single line of data, so no special formatting is required, as opposed to RC/Browse which displays the data via ISPF.

RUBROWC  nn.n   --------- RC/Browse: Column Mode --------- yy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> CSR

For Table   => SYSIBM.SYSCOPY                  > Row number=> nn OF nn
Browse Mode => C                                 Max Char  => 070
SSID: ssid ----------FETCH STATUS: COMPLETE-------------------------- authid
      DBNAME   TSNAME   DSNUM          ICTYPE ICDATE START_RBA  FILESEQNO
      PTDB     PTQRR200              0 C      171209 .L±ú.5³:..              0

The EXPLODE command can be used with the cursor placed at the start of the field to display it.

RUBROWC  nn.n   --------- RC/Browse: Column Mode --------- yy/mm/dd hh:mm:ss
COMMAND ===> EXPLODE                                          SCROLL ===> CSR

For Table   => SYSIBM.SYSCOPY                  > Row number=> nn OF nn
Browse Mode => C                                 Max Char  => 070
SSID: ssid ----------FETCH STATUS: COMPLETE-------------------------- authid
      DBNAME   TSNAME   DSNUM          ICTYPE ICDATE START_RBA  FILESEQNO
      PTDB     PTQRR200              0 C      171209 .L±ú.5³:..              0

The EXPLODE command brings the column data into a native ISPF edit session where the non-displayable character can be seen and
edited.

RUVIEWE  nn.n   -------- RC/Edit View Explode Facility ------- yy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ==

Table Name   => SYSCOPY             > Column Name     => START_RBA
Table Creator=> SYSIBM    >           Column Type     => CHAR(10)
DB2 SSID     => ssid                  Column Length/50=> 000

            ----+----1----+----2----+----3----+----4----+----5
     ****** ****************** Top of Data *******************
     000001  L±ú 5³:
            0D8D3FF7204444444444444444444444444444444444444444
            03FE45AA600000000000000000000000000000000000000000
     --------------------------------------------------------
     ****** ***************** Bottom of Data *****************

In RC/Browse, after displaying the data, the HEX command can also be used to display all fields in hex format instead of the original display.

RUBROWC  nn.n   --------- RC/Browse: Column Mode --------- yy/mm/dd hh:mm:ss
COMMAND ===> hex on                                           SCROLL ===> CSR

For Table   => SYSIBM.SYSCOPY                  > Row number=> nn OF nn
Browse Mode => C                                 Max Char  => 070
SSID: ssid ----------FETCH STATUS: COMPLETE-------------------------- authid
      DBNAME   TSNAME   DSNUM          ICTYPE ICDATE START_RBA  FILESEQNO
      PTDB     PTQRR200              0 C      171209 .L±ú.5³:..              0

After the HEX ON command has been entered the screen changes to this:

RUBROWC  nn.n   --------- RC/Browse: Column Mode --------- yy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> CSR

For Table   => SYSIBM.SYSCOPY                  > Row number=> nn OF nn
Browse Mode => C                                 Max Char  => 070
SSID: ssid ----------FETCH STATUS: COMPLETE-------------------------- authid
      DBNAME   TSNAME   DSNUM          ICTYPE ICDATE START_RBA  FILESEQNO
      PTDB     PTQRR200 0              C      171209  L±ú 5³:   0
      DECC4444 DEDDDFFF 0000           C      FFFFFF 0D8D3FF720 0000
      73420000 73899200 0000           3      171209 03FE45AA60 0000

Entering HEX OFF will change it back to normal.

Additional Information

See the HEX Command section:  HEX

See the EXPLODE Command section:  EXPLODE