RE: Hex '00' to Hex '40'?

There is no null "value" - only the null indicator.  The two are separate,
distinct and unrelated.  It was a bit of a leap for me too, until I realised
that they really do need to keep them separate.  I now think of the null
indicator as another attribute of the field, like it's length, data type and
value.

Sadly, x'00' means "NUL" in the ASCII character set, and the C people use
null (x'00') terminated strings, so the concept of data value null and SQL
NULL are now jumbled up in people's minds.

Buck Calabro

> -----Original Message-----
> From: Howard Weatherly 
> Sent: Wednesday, June 30, 1999 9:41 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Hex '00' to Hex '40'?
> 
> Maybe I am confused, but I thought a "null" values' value was binary zero
> or
> x'00'. If you process via DB/2, the null indicator field will contain a
> negative
> value if the root field contains a null value, which could be tested for
> null or
> not null... or was I watching the Travel Channel?
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---