DB2 graphic  QMF Version 8

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
 


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004