View non-display characters using RC/Browse
Article ID: 126991
Updated On:
Products
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 do not show the hex value of the field.
How this field be displayed in HEX.
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
dbname tsname 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
dbname tsname 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
dbname tsname 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
dbname tsname 0 C 171209 L±ú 5³: 0
44444444 44444444 0000 C FFFFFF 0D8D3FF720 0000
00000000 00000000 0000 3 171209 03FE45AA60 0000
Entering HEX OFF will change it back to normal.
Additional Information
Feedback
