NULL value

[156138]

What is hex equivalent for a NULL value.
I think there won't be any hex equivalent for NULL,correct me if iam wrong.

Suppose if a want directly edit a DB2 table in which
value of a NULLABLE field should be made as NULL.Is there is anyway to
do it.
_________________
Regards,
Vinod Reddy.

[dbzTHEdinosauer]

There is a lot of documentation on this subject; suprised you did not bother to read.

In DB2, the concept of NULL has to do with 'if there is a value assigned'. NULL is not a value, it is a condition. A Nullable column has an associated NULL Indicater which is set to -1 if the column is NULL and is not set to -1 if the nullable column indeed contains data. There is no hex value to represent NULL.
_________________
Dick Brenholtz
American in Varel, Germany

[Leo]

Hi Vinod

You can use "space" to make a field null , press the space bar . This method may not work for all the data types , in this case you will have to run a spufi query

SET column name = NULL
WHERE condition

Thanks
Leo