Avoiding using nulls as data when editing a QMF object

QMF uses GDDM for its panels, and nulls (X'00') are susceptible 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