View non-display characters using RC/Browse

book

Article ID: 126991

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS 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 do I display the field 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.

<Please see attached file for image>

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.

<Please see attached file for image>

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

<Please see attached file for image>

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.

<Please see attached file for image>

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.

<Please see attached file for image>

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

<Please see attached file for image>

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


 

Attachments

1558690205152000126991_sktwi1f5rjvs16g6v.jpeg get_app
1558690203216000126991_sktwi1f5rjvs16g6u.jpeg get_app
1558690201429000126991_sktwi1f5rjvs16g6t.jpeg get_app
1558690199606000126991_sktwi1f5rjvs16g6s.jpeg get_app
1558690197488000126991_sktwi1f5rjvs16g6r.jpeg get_app
1558690194551000126991_sktwi1f5rjvs16g6q.jpeg get_app