| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to select records from DB2 where field = null in ESQL ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| Bosco |
 Posted: Tue Sep 21, 2004 4:54 pm Post subject: How to select records from DB2 where field = null in ESQL ? |
 |
|
Novice
Joined: 30 Nov 2003
Posts: 17
|
Hi,
I would like to select records from a DB2 database table where a particular field is containing null value (ie the field was not assigned any value initially when the records was inserted). Does anyone knowvalue should I compare with in my ESQL statement?
eg
SET Environment.Messages[] = (SELECT A.MSGDATECREATE,
A.MSGTYPE,
A.MSGID,
A.MSGORIGINAL,
A.MSGGETQUEUE
FROM Database.LATEMSG AS A
WHERE A.MSGPROCESSED = ???);
A.MSGPROCESSED is defined as timestamp in DB2
I am using WBIMB v5.0.3
Thanks
Bosco |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Sep 21, 2004 5:53 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you try "Is NULL"?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Sep 22, 2004 12:22 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Just try NULL.
This should work fine.
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
