RE: Null or Blank

[Mark Allen <allenmark@xxxxxxxx>]

Glenfydich or Glenlivet????

Mark Allen
I.S. Manager
Wilkes Telephone & Electric
A Dycom Company
Phone: (706) 678-9565
Email: allenmark@nu-z.net
http://www.nu-z.net




:-----Original Message-----
:From: midrange-l-admin@midrange.com
:[mailto:midrange-l-admin@midrange.com] On Behalf Of Weatherly Howard
:Sent: Wednesday, January 09, 2002 2:16 PM
:To: 'midrange-lmidrangecom'
:Subject: RE: Null or Blank
:
:
:This message is in MIME format. Since your mail reader does
:not understand this format, some or all of this message may
:not be legible.
:--
:--
:[ Picked text/plain from multipart/alternative ]
:Buck, you are absolutely right, my minds eye remembered seeing
: x'00' where I knew there was a "DB2 Null Value" however
:today, I am looking in DBU, DSPPFM and seeing x'40' and no
:x'00' even where I know there is a DB2 null value!! I think I
:am ready for about 3 inches of a good single malt!
:
:
:--
:Content-Description: RE: Null or Blank
:
:From: Buck Calabro <Buck.Calabro@commsoft.net>
:Reply-To: midrange-l@midrange.com
:To: midrange-l@midrange.com
:Subject: RE: Null or Blank
:Date: Wed, 9 Jan 2002 12:25:49 -0500
:X-Plaintext: Picked text/plain from multipart/alternative
:
:--
:[ Picked text/plain from multipart/alternative ]
:>Yup, that x'00' is a null and you
:>will need to address it as
:>(is null | is not null)
:
:With the greatest of respect, the SQL concept of NULL is not
:the same as placing x'00' in a field.  The confusion arises
:out of an unfortunate naming convention.  SQL NULL is an
:attribute of the column, like size, type and text.  SQL NULL
:is not related to the contents of the field, which can be
:other than x'00'.  Likewise, placing x'00' in a null capable
:field means nothing to SQL.  SQL NULL will be FALSE for that field.
:  --buck
:_______________________________________________
:This is the Midrange Systems Technical Discussion (MIDRANGE-L)
:mailing list To post a message email: MIDRANGE-L@midrange.com
:To subscribe, unsubscribe, or change list options,
:visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
:or email: MIDRANGE-L-request@midrange.com
:Before posting, please take a moment to review the archives
:at http://archive.midrange.com/midrange-l.
:_______________________________________________
:This is the Midrange Systems Technical Discussion (MIDRANGE-L)
:mailing list To post a message email: MIDRANGE-L@midrange.com
:To subscribe, unsubscribe, or change list options,
:visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
:or email: MIDRANGE-L-request@midrange.com
:Before posting, please take a moment to review the archives
:at http://archive.midrange.com/midrange-l.
:
: