LHEX primary command

In the FM/Db2 editor, the LHEX command displays the data for one or more columns in long hexadecimal format. In LHEX format, each character is shown as two hexadecimal characters, which are displayed from left to right. For example, '1' appears as 'F1' in LHEX format. Only (VAR)CHAR, (VAR)GRAPHIC, DATE, TIME, and TIMESTAMP columns are affected.

Syntax


1 LHEX
1 
2.1 fieldref
2.1 fldname
2.1 ALL
2.1 ON
2.1 OFF
1 RESET
fieldref
A single field reference (for example, #1), a range (for example, #2-#5), or a list of single field references/ranges separated by spaces (for example, #1 #4 #6-#7). A single field specification is #n; n is a positive integer and cannot exceed the number of columns in the Db2® object or result table being processed.
fldname
The name of a column in the Db2® object or result table being processed. The column name can be preceded by a pound sign (#). Any value entered is translated to upper case if the "Translate Db2® object names" system's option is selected.
ON|OFF
Indicates whether to turn the LHEX option on or off. Omitting this parameter results in the command acting as a toggle; the field's current LHEX display status is reversed.

Examples

LHEX ALL ON
Displays the data for all eligible columns in long hex.
LHEX #4 ON
Displays the data for column #4 in long hex.
LHEX #9 #2 OFF
Displays the data for columns #9 and #2 in character format.
LHEX #5-#7 ON
Displays the data for columns #5, #6, and #7 in long hex.

Availability

Related tasks