Avoiding using nulls as data when editing a QMF object
QMF uses GDDM to display its panels, and null values (which have an internal hexadecimal representation of X'00') are subject to GDDM screen presentation. Therefore, avoid using nulls on QMF panels, such as the Edit Query panel. Instead, use an alternative, such as a constant hex representation or the database HEX function in an SQL query.
For example, to change a byte to a null value (binary zero) in a table named TEST that has a column named FLD1 with a hex value of 03C1549F, run this update statement:
UPDATE TEST SET FLD1=X'0300549F' WHERE FLD=X'03C1549F'
Now this field can be displayed using the database HEX function:
SELECT HEX(FLD1) FROM TEST