Considerations for Using Null-Capable Fields

It is possible that a null-map field can contain a value other than 1 or 0. For example, it is possible that SQL placed a value of 2 in a null-map field to indicate that the field contains a result of a divide by zero.

To be able to see a value other than 0 or 1 in a null-map, you must specify NULL-MAP-ALPHANUM on your COPY DDS statement.

NULL-MAP-ALPHANUM extends the range of values that can be received into or sent from the null map to include values other than 0 or 1. Only a value of 1 in a null map field indicates that the field is null. For more information on values other than 0 or 1 that can be sent or received in the null map, refer to the DB2® for i section of the Database and File Systems category in the IBM® i Information Center at this Web site - http://www.ibm.com/systems/i/infocenter/.