|
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 ] Glenfydich or Glenmorangie or if I had the money Macallan! -- Content-Description: RE: Null or Blank From: Mark Allen <allenmark@nu-z.net> Reply-To: midrange-l@midrange.com To: midrange-l@midrange.com Subject: RE: Null or Blank Date: Wed, 9 Jan 2002 14:26:01 -0500 X-Plaintext: Picked text/plain from multipart/alternative -- [ Picked text/plain from multipart/alternative ] 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. : : _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.