|
View previous topic :: View next topic
|
| Author |
Message |
soundarr
New User
Joined: 17 Jan 2008
Posts: 25
Location: Chennai
|
|
|
|
Hi,
SELECT * FROM TRX
WHERE TRX.NAME = 'KR'
AND LOCK_A IS NOT NULL
WITH UR;
LOCK_A is a CHAR(1) field. Above query gives me a record which when i put HEX ON displays a value '00'.
I understand '00' is a null value. Please advise.
Thanks,
Soundar |
|
| Back to top |
|
 |
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| Quote: |
| I understand '00' is a null value. |
True enough, but in the world of DBAs, their "null" means more like "does not exist", not that the column contain null values. X'00' is data, just like alpha or numeric data...... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I understand '00' is a null value. Please advise. |
A common mis-understanding. . .
x'00' is also known as low-values, hex zeros, and binary zeros. All of which are values. NULL is the absence of any value. The condition may be tested (i.e. IS NULL), but there can be no compare for some value that is null. |
|
| Back to top |
|
|
|
|
