how to show the null value from db2 command window

we are using db2 udb v8.1 , from db2 command window, how can i see the
value which has null in it? cause right now i only see it is blank,
not knowing actually it is a null value, i can only know it is null
value from other database tool, or from the program while reading the
value.

re: how to show the null value from db2 command window

try coalesec as Serge suggested:)

dai_xi@yahoo.com (xixi) wrote in message news:<c0f33a17.0406141606.2ff1377@posting.google.c om>...[color=blue]
> we are using db2 udb v8.1 , from db2 command window, how can i see the
> value which has null in it? cause right now i only see it is blank,
> not knowing actually it is a null value, i can only know it is null
> value from other database tool, or from the program while reading the
> value.[/color]