Re: Hex '00' to Hex '40'?

[Howard Weatherly <hweatherly@xxxxxxxxxxxx>]

Ok Buck, I see what you are getting at! but.... If I...

EXEC SQL UPDATE DB.OWN.TB SET FIELD_NAME=NULL END-EXEC

Will the field FIELD_NAME not contain NULL represented as x'00'?
     

Buck Calabro wrote:
> 
> 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
> +---
+---
| 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
+---