View non-display characters using RC/Browse

Document ID : KB000126991
Last Modified Date : 13/02/2019
Show Technical Document Details
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.
Question:
The results when displaying the START_RBA column from SYSIBM.SYSCOPY don't show the hex value of the field. How do I display the field in HEX.
Environment:
DB2 for Z/OS
Answer:
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.

User-added image
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.

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

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

User-added image
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.

User-added image
After the HEX ON command has been entered the screen changes to this:

User-added image

Entering HEX OFF will change it back to normal.
Additional Information:

See the HEX Command section:  HEX

See the EXPLODE Command section:  EXPLODE